DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on PO_RELEASES_ALL

Line 1554: po_releases_all pra,

1550: pawo.program_update_date
1551: FROM
1552: po_accrual_write_offs_all pawo,
1553: po_distributions_all pod,
1554: po_releases_all pra,
1555: po_headers_all poh,
1556: ap_invoice_distributions_all aida,
1557: financials_system_params_all fsp,
1558: gl_sets_of_books gsob,

Line 1721: po_releases_all pra,

1717: pawo.program_update_date
1718: FROM
1719: po_accrual_write_offs_all pawo,
1720: po_distributions_all pod,
1721: po_releases_all pra,
1722: po_headers_all poh,
1723: ap_invoice_distributions_all aida,
1724: financials_system_params_all fsp,
1725: gl_sets_of_books gsob,

Line 2427: FROM po_releases_all pra,

2423: AND ((aida.po_distribution_id IS NULL )
2424: OR (xal.accounting_class_code in ('IPV','EXCHANGE_RATE_VARIANCE','TRV','TIPV','TERV'))
2425: OR EXISTS (
2426: SELECT 1
2427: FROM po_releases_all pra,
2428: po_distributions_all pod
2429: WHERE pod.po_distribution_id = aida.po_distribution_id
2430: AND pod.po_release_id is NOT NULL
2431: AND pra.po_release_id = pod.po_release_id

Line 3189: FROM po_releases_all pra

3185: AND aida.org_id = p_operating_unit
3186: AND pod.org_id = p_operating_unit
3187: AND NOT EXISTS
3188: (SELECT 1
3189: FROM po_releases_all pra
3190: WHERE pod.po_release_id is NOT NULL
3191: AND pra.org_id = p_operating_unit
3192: AND pra.po_release_id = pod.po_release_id
3193: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'