APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_ORDER_LINES

Line 32: FROM OE_ORDER_LINES

28: -- OPM 3494420
29: CURSOR c_lines ( p_line_id IN NUMBER ) IS
30:
31: SELECT inventory_item_id, ship_from_org_id, order_quantity_uom, ordered_quantity_uom2
32: FROM OE_ORDER_LINES
33: WHERE line_id = p_line_id;
34:
35: CURSOR c_item ( discrete_org_id IN NUMBER -- INVCONV
36: , discrete_item_id IN NUMBER) IS

Line 222: FROM OE_ORDER_LINES

218: oe_debug_pub.add( 'QUERYING FOR LINE_SET_ID' , 1 ) ;
219: END IF;
220: SELECT NVL(SUM(ORDERED_QUANTITY),0)
221: INTO l_ordered_qty
222: FROM OE_ORDER_LINES
223: WHERE line_set_id = p_Lot_Serial_rec.line_set_id;
224:
225: SELECT NVL(SUM(quantity),0)
226: INTO l_total_qty

Line 236: FROM OE_ORDER_LINES

232: oe_debug_pub.add( 'QUERYING FOR LINE_ID' , 1 ) ;
233: END IF;
234: SELECT NVL(ORDERED_QUANTITY,0)
235: INTO l_ordered_qty
236: FROM OE_ORDER_LINES
237: WHERE line_id = p_Lot_Serial_rec.line_id;
238:
239: SELECT NVL(SUM(quantity),0)
240: INTO l_total_qty