APPS.PO_SOURCING2_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 259: FROM po_line_locations_all pll, -- GA FPI

255: */
256: cursor unit_price IS
257: SELECT pll.price_override,
258: pll.line_location_id -- SERVICES FPJ
259: FROM po_line_locations_all pll, -- GA FPI
260: po_headers_all poh -- 5684820
261: /*
262: Bug fix for 2687718.
263: Added QUOTATION in the WHERE clause to ensure that pricing works when

Line 825: FROM po_line_locations_all pll -- GA FPI

821:
822: cursor C1 is
823: SELECT distinct nvl(pll.ship_to_organization_id, -1),
824: nvl(pll.ship_to_location_id, -1)
825: FROM po_line_locations_all pll -- GA FPI
826: /*
827: Bug fix for 2687718.
828: Added QUOTATION in the WHERE clause to ensure that pricing works when
829: a Standard PO is sourced to a Quotation through the Supplier Catalog.

Line 1107: from po_line_locations_all

1103: x_min_shipment_num OUT NOCOPY NUMBER) IS
1104: BEGIN
1105: select min(shipment_num)
1106: into x_min_shipment_num
1107: from po_line_locations_all
1108: where po_line_id = p_po_line_id
1109: and nvl(cancel_flag, 'N') = 'N'
1110: and nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
1111: EXCEPTION

Line 1204: from po_line_locations_all poll

1200: l_progress := '001';
1201: BEGIN
1202: select poll.ship_to_location_id, poll.ship_to_organization_id, poll.need_by_date, poll.line_location_id
1203: into l_ship_to_location_id, l_ship_to_organization_id, l_need_by_date, l_line_location_id
1204: from po_line_locations_all poll
1205: where poll.po_line_id = p_po_line_id
1206: and poll.shipment_num = p_min_shipment_num;
1207: EXCEPTION
1208: when others then