APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_LINES_ALL

Line 756: PO_LINES_ALL POL ,

752: PO_REQUISITION_LINES_ALL PRL,
753: PO_REQ_DISTRIBUTIONS_ALL PRD,
754:
755: PO_LINE_LOCATIONS_ALL PLL,
756: PO_LINES_ALL POL ,
757: PO_HEADERS_ALL POH,
758:
759: (
760: SELECT

Line 1204: PO_LINES_ALL POL

1200: PLL.SHIPMENT_NUM,
1201: GT.DISTRIBUTION_NUM
1202: FROM PO_DISTRIBUTIONS_GT GT,
1203: PO_LINE_LOCATIONS_ALL PLL,
1204: PO_LINES_ALL POL
1205: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1206: POL.PO_LINE_ID = PLL.PO_LINE_ID
1207:
1208: ) LOOP

Line 1349: PO_LINES_ALL POL,

1345: PLL.SHIPMENT_NUM,
1346: PLD.DISTRIBUTION_NUM
1347: FROM
1348: PO_DISTRIBUTIONS_GT GT,
1349: PO_LINES_ALL POL,
1350: PO_LINE_LOCATIONS_ALL PLL,
1351: PO_DISTRIBUTIONS_ALL PLD
1352: WHERE GT.LINE_LOCATION_ID = PLD.LINE_LOCATION_ID AND
1353: PLD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 1451: PO_LINES_ALL POL,

1447: PLL.SHIPMENT_NUM,
1448: GT.DISTRIBUTION_NUM
1449: FROM
1450: PO_DISTRIBUTIONS_GT GT,
1451: PO_LINES_ALL POL,
1452: PO_LINE_LOCATIONS_ALL PLL
1453: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1454: PLL.PO_LINE_ID = POL.PO_LINE_ID
1455: GROUP BY POL.LINE_NUM, PLL.SHIPMENT_NUM, GT.DISTRIBUTION_NUM

Line 1526: PO_LINES_ALL POL,

1522: PLL.MATCHING_BASIS
1523:
1524: FROM
1525: PO_DISTRIBUTIONS_GT GT,
1526: PO_LINES_ALL POL,
1527: PO_LINE_LOCATIONS_ALL PLL
1528: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1529: PLL.PO_LINE_ID = POL.PO_LINE_ID ;
1530:

Line 2638: FROM po_lines_all PL

2634: BULK COLLECT
2635: INTO po_line_id_tbl,
2636: draft_id_tbl,
2637: delete_flag_tbl
2638: FROM po_lines_all PL
2639: WHERE EXISTS(
2640: SELECT 'Line exists in txn'
2641: FROM po_distributions_gt GT
2642: WHERE PL.po_line_id = GT.po_line_id)