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_all 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 1205: po_line_locations_all pll,

1201: pd.destination_organization_id,
1202: pd.destination_subinventory,
1203: 'Y'
1204: FROM po_distributions_all pd,
1205: po_line_locations_all pll,
1206: po_lines_all pl
1207: WHERE pd.po_distribution_id = l_distid
1208: AND pll.line_location_id = pd.line_location_id
1209: AND pl.item_id IS NOT NULL --

Line 2725: FROM po_line_locations_all poll

2721: WHERE ms.supply_type_code = 'PO'
2722: AND ms.po_line_location_id =
2723: (
2724: SELECT poll. source_shipment_id
2725: FROM po_line_locations_all poll
2726: WHERE poll.line_location_id = p_shipid
2727: );
2728:
2729: IF (SQL%NOTFOUND) THEN