APPS.CSTPPIPV dependencies on PO_DISTRIBUTIONS_ALL

Line 121: po_distributions_all pda,

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'

Line 765: TYPE dists_tab_type is TABLE OF po_distributions_all.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;

761: conc_status BOOLEAN;
762: cst_process_error EXCEPTION;
763: cst_cstppipv_running EXCEPTION;
764:
765: TYPE dists_tab_type is TABLE OF po_distributions_all.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
766: l_po_dists_tab dists_tab_type;
767:
768: -- This cursor lists PO distributions w/ invoice distributions that has not been
769: -- transferred to Inventory nor WIP.

Line 777: FROM po_distributions_all pda,

773: SELECT DISTINCT
774: pda.po_distribution_id,
775: pla.item_id inventory_item_id,
776: pda.project_id
777: FROM po_distributions_all pda,
778: po_line_locations_all plla,
779: po_lines_all pla,
780: wip_entities we,
781: wip_discrete_jobs wdj

Line 865: FROM po_distributions_all pda,

861: /* bug 4873742 -- added to bypass performance repository issues */
862:
863: cursor c_po_dists2 is
864: SELECT pda.po_distribution_id
865: FROM po_distributions_all pda,
866: wip_entities we,
867: wip_discrete_jobs wdj,
868: wip_operation_resources wor
869: WHERE we.wip_entity_id = pda.wip_entity_id

Line 1322: po_distributions_all pda,

1318: pda.po_header_id,
1319: pda.po_line_id,
1320: p_adj_account
1321: FROM cst_ap_variance_headers cavh,
1322: po_distributions_all pda,
1323: wip_operation_resources wor,
1324: org_acct_periods oap,
1325: mtl_parameters mp,
1326: fnd_user fu

Line 2166: po_distributions_all pda,

2162: wdj.date_released+0.00001,
2163: rt.transaction_date))
2164: INTO l_transaction_date
2165: FROM rcv_transactions rt,
2166: po_distributions_all pda,
2167: wip_discrete_jobs wdj
2168: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2169: AND pda.po_distribution_id = p_po_distribution_id
2170: AND rt.transaction_type = 'RECEIVE'

Line 2177: po_distributions_all pda

2173: ))
2174: AND rt.transaction_date = (
2175: SELECT MAX(rt.transaction_date)
2176: FROM rcv_transactions rt,
2177: po_distributions_all pda
2178: WHERE rt.transaction_type = 'RECEIVE'
2179: AND pda.po_distribution_id = p_po_distribution_id
2180: AND ( rt.po_distribution_id = p_po_distribution_id /* bug 4137765 - for performance improvement */
2181: OR ( rt.po_line_location_id = pda.line_location_id