DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on PO_HEADERS_ALL

Line 1159: po_headers_all poh

1155: po_accrual_write_offs_all pawo,
1156: rcv_receiving_sub_ledger rrs,
1157: xla_distribution_links xld, --BUG#7275286
1158: rcv_transactions rt,
1159: po_headers_all poh
1160: ,cst_accrual_accounts ca --BUG#7528609
1161: WHERE pawo.org_id = p_operating_unit
1162: AND pawo.transaction_source_code = 'PO'
1163: AND pawo.po_transaction_id IS NOT NULL

Line 1555: po_headers_all poh,

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,
1559: fnd_currencies fc,

Line 1722: po_headers_all poh,

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,
1726: fnd_currencies fc,

Line 2399: po_headers_all poh

2395: financials_system_params_all fsp,
2396: po_distributions_all pod,
2397: po_lines_all pol,
2398: --{BUG#7554120
2399: po_headers_all poh
2400: --}
2401: WHERE fsp.org_id = p_operating_unit
2402: AND xal.code_combination_id = caa.accrual_account_id
2403: AND caa.operating_unit_id = p_operating_unit

Line 2437: FROM po_headers_all poh,

2433: )
2434: OR EXISTS
2435: (
2436: SELECT 1
2437: FROM po_headers_all poh,
2438: po_distributions_all pod
2439: WHERE pod.po_distribution_id = aida.po_distribution_id
2440: AND pod.po_release_id is NULL
2441: AND poh.po_header_id = pod.po_header_id

Line 3198: FROM po_headers_all poh

3194: )
3195: AND NOT EXISTS
3196: (
3197: SELECT 1
3198: FROM po_headers_all poh
3199: WHERE pod.po_release_id is NULL
3200: AND poh.org_id = p_operating_unit
3201: AND poh.po_header_id = pod.po_header_id
3202: AND NVL(poh.consigned_consumption_flag,'N') = 'Y'

Line 3332: po_headers_all poh,

3328: xla_ae_headers xah,
3329: xla_ae_lines xal,
3330: xla_transaction_entities_upg xte,
3331: xla_distribution_links xdl,
3332: po_headers_all poh,
3333: po_lines_all pol,
3334: po_distributions_all pod,
3335: cst_accrual_accounts caa,
3336: financials_system_params_all fsp

Line 3451: po_headers_all poh,

3447: xla_ae_headers xah,
3448: xla_ae_lines xal,
3449: xla_transaction_entities_upg xte,
3450: xla_distribution_links xdl,
3451: po_headers_all poh,
3452: po_lines_all pol,
3453: po_distributions_all pod,
3454: cst_accrual_accounts caa,
3455: financials_system_params_all fsp

Line 3591: po_headers_all poh /* -- Changes to pick Vendor from PO instead of APIA. Bug 7312170 */

3587: po_distributions_all pod,
3588: cst_accrual_accounts caa,
3589: financials_system_params_all fsp,
3590: xla_transaction_entities_upg xte,
3591: po_headers_all poh /* -- Changes to pick Vendor from PO instead of APIA. Bug 7312170 */
3592: WHERE xal.code_combination_id = caa.accrual_account_id
3593: AND caa.operating_unit_id = p_operating_unit
3594: AND fsp.org_id = p_operating_unit
3595: AND fsp.set_of_books_id = xah.ledger_id

Line 3678: po_headers_all poh

3674: l_request_id
3675: FROM cst_write_offs cwo,
3676: --{ Immunization for po_vendor merge
3677: po_distributions_all pod,
3678: po_headers_all poh
3679: --}
3680: WHERE cwo.po_distribution_id is NOT NULL
3681: AND cwo.operating_unit_id = p_operating_unit
3682: AND cwo.inventory_transaction_id is NULL -- do not pick up old deliver txns