APPS.PO_SUPPLY dependencies on PO_LINE_LOCATIONS_ALL

Line 677: , po_line_locations_all pll

673: AND ms.supply_source_id IN
674: (
675: SELECT prl.requisition_line_id
676: FROM po_requisition_lines_clm_v prl
677: , po_line_locations_all pll
678: WHERE prl.line_location_id = pll.line_location_id
679: AND pll.po_release_id = p_docid
680: );
681:

Line 1319: po_line_locations_all pll,

1315: pd.destination_organization_id,
1316: pd.destination_subinventory,
1317: 'Y'
1318: FROM po_distributions_all pd,
1319: po_line_locations_all pll,
1320: po_lines_all pl
1321: WHERE pd.po_distribution_id = l_distid
1322: AND pll.line_location_id = pd.line_location_id
1323: AND pl.item_id IS NOT NULL --

Line 2923: FROM po_line_locations_all poll

2919: WHERE ms.supply_type_code = 'PO'
2920: AND ms.po_line_location_id =
2921: (
2922: SELECT poll. source_shipment_id
2923: FROM po_line_locations_all poll
2924: WHERE poll.line_location_id = p_shipid
2925: );
2926:
2927: IF (SQL%NOTFOUND) THEN