APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_ORDER_LINES

Line 31: FROM OE_ORDER_LINES

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

Line 219: FROM OE_ORDER_LINES

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

Line 233: FROM OE_ORDER_LINES

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