APPS.POS_CREATE_ASN dependencies on PO_LINES_ALL

Line 98: l_item_revision PO_LINES_ALL.ITEM_REVISION%TYPE;

94: k NUMBER := 1;
95: x_note_count number := 0;
96: l_primary_unit_of_measure varchar2(25);
97: l_item_id NUMBER;
98: l_item_revision PO_LINES_ALL.ITEM_REVISION%TYPE;
99: l_converted_qty NUMBER;
100: x_ship_to_location_id NUMBER;
101: l_supplier_username VARCHAR2(80);
102: l_supplier_displayname VARCHAR2(100);

Line 355: from po_lines_all

351: item_revision
352: into l_primary_unit_of_measure,
353: l_item_id,
354: l_item_revision
355: from po_lines_all
356: where po_line_id = P_PO_LINE_ID_T;
357:
358: po_uom_s.uom_convert(P_QUANTITY_T, P_UNIT_OF_MEASURE_T, l_item_id,
359: l_primary_unit_of_measure, l_converted_qty);

Line 709: po_lines_all pl

705: x_qty_rcv_exception_code,
706: x_item_id,
707: x_po_uom
708: FROM po_line_locations_all pll,
709: po_lines_all pl
710: WHERE pll.line_location_id = p_line_location_id
711: AND pll.po_line_id = pl.po_line_id;
712:
713:

Line 914: po_lines_all pl

910: pl.unit_meas_lookup_code
911: INTO x_item_id,
912: x_po_uom
913: FROM po_line_locations_all pll,
914: po_lines_all pl
915: WHERE pll.line_location_id = p_line_location_id
916: AND pll.po_line_id = pl.po_line_id;
917:
918: