APPS.PO_SOURCING2_SV dependencies on PO_LINE_LOCATIONS

Line 242: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;

238:
239: --
240: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
241: l_source_document_header_id PO_LINES.po_header_id%TYPE;
242: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
243: l_new_price PO_LINES.unit_price%TYPE;
244: l_return_status VARCHAR2(1);
245: l_api_name CONSTANT varchar2(30) := 'GET_BREAK_PRICE';
246: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;

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 472: from po_line_locations

468: -- Get the old quantity saved on the database
469: begin
470: select nvl(quantity, 0)
471: into old_quantity
472: from po_line_locations
473: where line_location_id = p_line_location_id;
474: exception
475: when others then old_quantity := 0;
476: end;

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

844: exit when C1%notfound;
845:
846: SELECT sum(pll.quantity - nvl(pll.quantity_cancelled, 0))
847: INTO temp_quantity
848: FROM po_line_locations pll
849: WHERE decode(price_break_org, -1, pll.ship_to_organization_id,
850: price_break_org) = pll.ship_to_organization_id
851: AND decode(price_break_loc, -1, pll.ship_to_location_id,
852: price_break_loc) = pll.ship_to_location_id

Line 1082: UPDATE po_line_locations

1078: g_user_id number := fnd_global.user_id;
1079:
1080: BEGIN
1081:
1082: UPDATE po_line_locations
1083: SET price_override = p_price,
1084: last_update_date = sysdate,
1085: last_updated_by = g_user_id
1086: WHERE line_location_id = p_line_location_id;

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