APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 755: PO_LINE_LOCATIONS_ALL PLL,

751: TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL,
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: (

Line 778: FROM PO_LINE_LOCATIONS_ALL POLL

774:
775: FROM PO_DISTRIBUTIONS_ALL POD
776: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
777: )DAR
778: FROM PO_LINE_LOCATIONS_ALL POLL
779: WHERE EXISTS
780: (SELECT 1 FROM PO_SESSION_GT PGT
781: WHERE PGT.INDEX_CHAR1 = 'LINKREQDIST_LINELOCID'
782: AND PGT.INDEX_NUM1 = POLL.LINE_LOCATION_ID)

Line 867: FROM PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_GT GT

863:
864: FROM PO_DISTRIBUTIONS_ALL POD
865: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
866: ) DAR
867: FROM PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_GT GT
868: WHERE GT.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
869: GROUP BY POLL.LINE_LOCATION_ID
870:
871: ) LOOP

Line 1203: PO_LINE_LOCATIONS_ALL PLL,

1199: Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUM,
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:

Line 1350: PO_LINE_LOCATIONS_ALL PLL,

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
1354: PLL.PO_LINE_ID = POL.PO_LINE_ID AND

Line 1452: PO_LINE_LOCATIONS_ALL PLL

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
1456: HAVING Count(1) > 1;

Line 1527: PO_LINE_LOCATIONS_ALL PLL

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:
1531: END IF;

Line 2596: FROM po_line_locations_all PLL

2592: BULK COLLECT
2593: INTO po_line_loc_id_tbl,
2594: draft_id_tbl,
2595: delete_flag_tbl
2596: FROM po_line_locations_all PLL
2597: WHERE EXISTS(
2598: SELECT 'Shipment exists in txn'
2599: FROM po_distributions_gt GT
2600: WHERE PLL.line_location_id = GT.line_location_id)