APPS.CST_ACCRUAL_LOAD dependencies on PO_RELEASES_ALL

Line 1534: po_releases_all pra,

1530: pawo.program_update_date
1531: FROM
1532: po_accrual_write_offs_all pawo,
1533: po_distributions_all pod,
1534: po_releases_all pra,
1535: po_headers_all poh,
1536: ap_invoice_distributions_all aida,
1537: financials_system_params_all fsp,
1538: gl_sets_of_books gsob,

Line 1702: po_releases_all pra,

1698: pawo.program_update_date
1699: FROM
1700: po_accrual_write_offs_all pawo,
1701: po_distributions_all pod,
1702: po_releases_all pra,
1703: po_headers_all poh,
1704: ap_invoice_distributions_all aida,
1705: financials_system_params_all fsp,
1706: gl_sets_of_books gsob,

Line 2184: FROM po_releases_all pra,

2180: AND ( (aida.po_distribution_id IS NULL )
2181: OR (xlal.accounting_class_code in ('IPV','EXCHANGE_RATE_VARIANCE','TRV','TIPV','TERV'
2182: ,'ACCRUAL','ITEM EXPENSE'))
2183: OR EXISTS ( SELECT 1
2184: FROM po_releases_all pra,
2185: po_distributions_all pod
2186: WHERE pod.po_distribution_id = aida.po_distribution_id
2187: AND pod.po_release_id IS NOT NULL
2188: AND pra.po_release_id = pod.po_release_id

Line 2510: FROM po_releases_all pra

2506: OR ( pod.po_release_id is NULL
2507: AND NVL(poh.consigned_consumption_flag,'N') = 'Y' )
2508: OR EXISTS (
2509: SELECT 1
2510: FROM po_releases_all pra
2511: WHERE pod.po_release_id is NOT NULL
2512: AND pra.po_release_id = pod.po_release_id
2513: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'
2514: )

Line 2597: FROM po_releases_all pra

2593: OR ( pod.po_release_id is NULL
2594: AND NVL(poh.consigned_consumption_flag,'N') = 'Y' )
2595: OR EXISTS (
2596: SELECT 1
2597: FROM po_releases_all pra
2598: WHERE pod.po_release_id is NOT NULL
2599: AND pra.po_release_id = pod.po_release_id
2600: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'
2601: )

Line 3494: FROM po_releases_all pra

3490: AND aida.org_id = p_operating_unit
3491: AND pod.org_id = p_operating_unit
3492: AND NOT EXISTS
3493: (SELECT 1
3494: FROM po_releases_all pra
3495: WHERE pod.po_release_id is NOT NULL
3496: AND pra.org_id = p_operating_unit
3497: AND pra.po_release_id = pod.po_release_id
3498: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'

Line 3520: FROM po_releases_all pra

3516: AND cwo.operating_unit_id = p_operating_unit
3517: AND cwo.po_distribution_id = pod.po_distribution_id
3518: AND NOT EXISTS
3519: (SELECT NULL
3520: FROM po_releases_all pra
3521: WHERE pod.po_release_id is NOT NULL
3522: AND pra.po_release_id = pod.po_release_id
3523: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'
3524: )