44: --
45: BEGIN
46: SELECT line_set_id
47: INTO l_line_set_id
48: FROM OE_ORDER_LINES
49: WHERE line_id = g_Lot_Serial_rec.line_id;
50:
51: RETURN l_line_set_id;
52:
98:
99: CURSOR c_lines ( p_line_id IN NUMBER ) IS
100:
101: SELECT inventory_item_id, ship_from_org_id, order_quantity_uom, ordered_quantity_uom2
102: FROM OE_ORDER_LINES
103: WHERE line_id = p_line_id;
104: /*CURSOR c_opm_item ( discrete_org_id IN NUMBER -- INVCONV
105: , discrete_item_id IN NUMBER) IS
106: SELECT item_id
368: -- OPM 3494420
369: CURSOR c_lines ( p_line_id IN NUMBER ) IS
370:
371: SELECT inventory_item_id, ship_from_org_id, order_quantity_uom, ordered_quantity_uom2
372: FROM OE_ORDER_LINES
373: WHERE line_id = p_line_id;
374:
375: /*CURSOR c_opm_item ( discrete_org_id IN NUMBER
376: , discrete_item_id IN NUMBER) IS