APPS.PO_SHIPMENTS_SV3 dependencies on PO_LINES_ALL

Line 53: from po_lines_all pol, --

49:
50: BEGIN
51:
52: SELECT max(line_location_id) into x_po_line_location_id_record.po_line_location_id
53: from po_lines_all pol, --
54: po_line_locations poll
55: where pol.po_line_id = poll.po_line_id
56: and NVL(X_po_line_location_id_record.item_id, pol.item_id) = pol.item_id
57: and NVL(X_po_line_location_id_record.po_line_id, pol.po_line_id) = pol.po_line_id

Line 256: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

252: X_Entity_Level VARCHAR2(25) := 'SHIPMENT';
253: X_orig_quantity NUMBER;
254:
255: --
256: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
257: l_matching_basis PO_LINES_ALL.matching_basis%TYPE;
258: --
259:
260: BEGIN

Line 257: l_matching_basis PO_LINES_ALL.matching_basis%TYPE;

253: X_orig_quantity NUMBER;
254:
255: --
256: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
257: l_matching_basis PO_LINES_ALL.matching_basis%TYPE;
258: --
259:
260: BEGIN
261:

Line 301: FROM po_lines_all pol

297: X_progress := '025';
298:
299: SELECT pol.order_type_lookup_code, pol.matching_basis
300: INTO l_value_basis, l_matching_basis
301: FROM po_lines_all pol
302: WHERE pol.po_line_id = X_Po_Line_Id;
303:
304: X_progress := '030';
305: --