[Home] [Help]
1549: pawo.program_id,
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,
1716: pawo.program_id,
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,
2392: xla_ae_lines xal,
2393: xla_distribution_links xdl,
2394: cst_accrual_accounts caa,
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: --}
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
2432: AND NVL(pra.consigned_consumption_flag,'N') = 'Y'
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
2442: AND NVL(poh.consigned_consumption_flag,'N') = 'Y'
3130:
3131: CURSOR c_po_dists is
3132: SELECT /*+ LEADING(rt) USE_NL(rrs,pod) */
3133: DISTINCT pod.po_distribution_id
3134: FROM po_distributions_all pod,
3135: rcv_transactions rt,
3136: rcv_receiving_sub_ledger rrs
3137: WHERE pod.accrual_account_id is NOT NULL
3138: AND pod.accrue_on_receipt_flag = 'Y'
3143: /* start added below sql for OPM Receiving data to insert the AP PO data, pmarada, bug6995413 */
3144: UNION
3145: SELECT /*+ LEADING(rt) USE_NL(grat,pod) */
3146: DISTINCT pod.po_distribution_id
3147: FROM po_distributions_all pod,
3148: rcv_transactions rt,
3149: gmf_rcv_accounting_txns grat
3150: WHERE pod.accrual_account_id is NOT NULL
3151: AND pod.accrue_on_receipt_flag = 'Y'
3156: AND grat.org_id = p_operating_unit
3157: /* End OPM Financials */
3158: UNION
3159: SELECT DISTINCT pod.po_distribution_id
3160: FROM po_distributions_all pod,
3161: rcv_accounting_events rae,
3162: rcv_receiving_sub_ledger rrs
3163: WHERE pod.accrual_account_id is NOT NULL
3164: AND pod.accrue_on_receipt_flag = 'Y'
3176: ----------------------
3177: UNION
3178: SELECT DISTINCT aida.po_distribution_id
3179: FROM ap_invoice_distributions_all aida,
3180: po_distributions_all pod
3181: WHERE pod.accrual_account_id is NOT NULL
3182: AND aida.accounting_date between p_from_date AND p_to_date
3183: AND aida.po_distribution_id is NOT NULL
3184: AND aida.po_distribution_id = pod.po_distribution_id
3201: AND poh.po_header_id = pod.po_header_id
3202: AND NVL(poh.consigned_consumption_flag,'N') = 'Y'
3203: );
3204:
3205: TYPE dists_table is TABLE OF po_distributions_all.po_distribution_id%TYPE;
3206:
3207: po_dists_tab dists_table;
3208:
3209: CURSOR c_opm_count IS
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
3337: WHERE fsp.org_id = p_operating_unit
3338: AND xah.ledger_id = fsp.set_of_books_id
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
3456: WHERE fsp.org_id = p_operating_unit
3457: AND xah.ledger_id = fsp.set_of_books_id
3583: xla_ae_headers xah,
3584: xla_ae_lines xal,
3585: xla_distribution_links xdl,
3586: po_lines_all pol,
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 */
3673: l_build_id,
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