DBA Data[Home] [Help]

APPS.OE_DEFAULT_LOT_SERIAL dependencies on OE_ORDER_LINES

Line 48: FROM OE_ORDER_LINES

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:

Line 102: FROM OE_ORDER_LINES

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

Line 372: FROM OE_ORDER_LINES

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