Hello all. I am very new beginner to this forums as well as entry level to oracle application.
My client project is upgrading from 11i to R12.
I have one oracle alert which contains below query (11i)
ACTUAL 11i query:
SELECT DISTINCT substr(haou.name,1,4),
FROM ap.ap_checks_all aca, ap.AP_CHECK_STOCKS_ALL acsa, apps.fnd_user u, hr.hr_all_organization_units haou,
ap.AP_INVOICE_PAYMENTS_ALL aipa, ap.ap_invoices_all aia
WHERE aca.check_stock_id = acsa.check_stock_id
and aca.check_id = aipa.check_id (+)
and aipa.invoice_id = aia.invoice_id
and aia.created_by = aca.created_by
AND aca.org_id = haou.organization_id
and aca.created_by = u.user_id
and acsa.name not in ('WIRE','BOA WIRES')
and aca.amount > 99.99
and trunc(aca.creation_date) >= trunc(sysdate)
order by 1,2
In R12 I know I have to change AP.AP_CHECK_STOCKS_ALL is obsolete in Oracle r12. I have to replace it with CE.CE_PAYMENT_DOCUMENTS.
But when u change it is saying error in joint of
aca.check_stock_id = acsa.check_stock_id . --- HERE I confused how to solve this joint.
How to joint AP.AP_CHECK_STOCKS_ALL and CE.CE_PAYMENT_DOCUMENTS. table
i.e aca.check_stock_id = acsa.check_stock_id.
Many Thanks in advance.