APPS.PO_SOURCING2_SV dependencies on PO_LINE_LOCATIONS

Line 317: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;

313:
314: --
315: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
316: l_source_document_header_id PO_LINES.po_header_id%TYPE;
317: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
318: l_new_price PO_LINES.unit_price%TYPE;
319: l_return_status VARCHAR2(1);
320: l_api_name CONSTANT VARCHAR2(30) := 'GET_BREAK_PRICE';
321: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

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 581: FROM po_line_locations

577: -- Get the old quantity saved on the database
578: BEGIN
579: SELECT nvl(quantity, 0)
580: INTO old_quantity
581: FROM po_line_locations
582: WHERE line_location_id = p_line_location_id;
583: EXCEPTION
584: WHEN OTHERS THEN old_quantity := 0;
585: END;

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 1066: FROM po_line_locations pll

1062: EXIT WHEN C1%notfound;
1063:
1064: SELECT SUM(pll.quantity - nvl(pll.quantity_cancelled, 0))
1065: INTO temp_quantity
1066: FROM po_line_locations pll
1067: WHERE decode(price_break_org, -1, pll.ship_to_organization_id,
1068: price_break_org) = pll.ship_to_organization_id
1069: AND decode(price_break_loc, -1, pll.ship_to_location_id,
1070: price_break_loc) = pll.ship_to_location_id

Line 1300: UPDATE po_line_locations

1296: g_user_id NUMBER := fnd_global.user_id;
1297:
1298: BEGIN
1299:
1300: UPDATE po_line_locations
1301: SET price_override = p_price,
1302: last_update_date = SYSDATE,
1303: last_updated_by = g_user_id
1304: WHERE line_location_id = p_line_location_id;

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