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 687: po_lines_all pl

683: x_qty_rcv_exception_code,
684: x_item_id,
685: x_po_uom
686: FROM po_line_locations_all pll,
687: po_lines_all pl
688: WHERE pll.line_location_id = p_line_location_id
689: AND pll.po_line_id = pl.po_line_id;
690:
691:

Line 810: po_lines_all pl

806: pl.unit_meas_lookup_code
807: INTO x_item_id,
808: x_po_uom
809: FROM po_line_locations_all pll,
810: po_lines_all pl
811: WHERE pll.line_location_id = p_line_location_id
812: AND pll.po_line_id = pl.po_line_id;
813:
814: