[Home] [Help]
117: )
118: AND EXISTS
119: ( SELECT 'X'
120: FROM ap_invoice_distributions_all aida,
121: po_distributions_all pda,
122: po_line_locations_all plla,
123: po_lines_all pla
124: WHERE aida.po_distribution_id = pda.po_distribution_id
125: AND aida.posted_flag = 'Y'
785: conc_status BOOLEAN;
786: cst_process_error EXCEPTION;
787: cst_cstppipv_running EXCEPTION;
788:
789: TYPE dists_tab_type is TABLE OF po_distributions_all.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
790: l_po_dists_tab dists_tab_type;
791:
792: -- This cursor lists PO distributions w/ invoice distributions that has not been
793: -- transferred to Inventory nor WIP.
797: SELECT DISTINCT
798: pda.po_distribution_id,
799: pla.item_id inventory_item_id,
800: pda.project_id
801: FROM po_distributions_all pda,
802: po_line_locations_all plla,
803: po_lines_all pla,
804: wip_entities we,
805: wip_discrete_jobs wdj
885: /* bug 4873742 -- added to bypass performance repository issues */
886:
887: cursor c_po_dists2 is
888: SELECT pda.po_distribution_id
889: FROM po_distributions_all pda,
890: wip_entities we,
891: wip_discrete_jobs wdj,
892: wip_operation_resources wor
893: WHERE we.wip_entity_id = pda.wip_entity_id
1364: pda.po_header_id,
1365: pda.po_line_id,
1366: p_adj_account
1367: FROM cst_ap_variance_headers cavh,
1368: po_distributions_all pda,
1369: wip_operation_resources wor,
1370: org_acct_periods oap,
1371: mtl_parameters mp,
1372: fnd_user fu
2248: wdj.date_released+0.00001,
2249: rt.transaction_date))
2250: INTO l_transaction_date
2251: FROM rcv_transactions rt,
2252: po_distributions_all pda,
2253: wip_discrete_jobs wdj
2254: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2255: AND pda.po_distribution_id = p_po_distribution_id
2256: AND rt.transaction_type = 'RECEIVE'
2259: ))
2260: AND rt.transaction_date = (
2261: SELECT MAX(rt.transaction_date)
2262: FROM rcv_transactions rt,
2263: po_distributions_all pda
2264: WHERE rt.transaction_type = 'RECEIVE'
2265: AND pda.po_distribution_id = p_po_distribution_id
2266: AND ( rt.po_distribution_id = p_po_distribution_id /* bug 4137765 - for performance improvement */
2267: OR ( rt.po_line_location_id = pda.line_location_id