APPS.PO_SOURCING2_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 338: FROM po_line_locations_all pll, -- GA FPI

334: */
335: CURSOR unit_price IS
336: SELECT pll.price_override,
337: pll.line_location_id -- SERVICES FPJ
338: FROM po_line_locations_all pll, -- GA FPI
339: po_headers_all poh -- 5684820
340: /*
341: Bug fix for 2687718.
342: Added QUOTATION in the WHERE clause to ensure that pricing works when

Line 1043: FROM po_line_locations_all pll -- GA FPI

1039:
1040: CURSOR C1 IS
1041: SELECT DISTINCT nvl(pll.ship_to_organization_id, - 1),
1042: nvl(pll.ship_to_location_id, - 1)
1043: FROM po_line_locations_all pll -- GA FPI
1044: /*
1045: Bug fix for 2687718.
1046: Added QUOTATION in the WHERE clause to ensure that pricing works when
1047: a Standard PO is sourced to a Quotation through the Supplier Catalog.

Line 1325: FROM po_line_locations_all

1321: x_min_shipment_num OUT NOCOPY NUMBER) IS
1322: BEGIN
1323: SELECT MIN(shipment_num)
1324: INTO x_min_shipment_num
1325: FROM po_line_locations_all
1326: WHERE po_line_id = p_po_line_id
1327: AND nvl(cancel_flag, 'N') = 'N'
1328: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
1329: EXCEPTION

Line 1422: FROM po_line_locations_all poll

1418: l_progress := '001';
1419: BEGIN
1420: SELECT poll.ship_to_location_id, poll.ship_to_organization_id, poll.need_by_date, poll.line_location_id
1421: INTO l_ship_to_location_id, l_ship_to_organization_id, l_need_by_date, l_line_location_id
1422: FROM po_line_locations_all poll
1423: WHERE poll.po_line_id = p_po_line_id
1424: AND poll.shipment_num = p_min_shipment_num;
1425: EXCEPTION
1426: WHEN OTHERS THEN