APPS.INV_ROI_INTEGRATION_GRP dependencies on OE_ORDER_LINES_ALL

Line 189: FROM oe_order_lines_all

185: FROM oe_lot_serial_numbers
186: WHERE (line_id = p_oe_order_line_id
187: OR line_set_id IN
188: (SELECT line_set_id
189: FROM oe_order_lines_all
190: WHERE line_id = p_oe_order_line_id
191: AND header_id = p_oe_order_header_id))
192: AND lot_number = v_lot_no;
193:

Line 384: FROM oe_order_lines_all ,mtl_units_of_measure

380: in INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity,
381: we should convert the l_rma_quantity into RMA UNIT_OF_MEASURE.*/
382: SELECT unit_of_measure
383: INTO l_rma_unit_of_measure
384: FROM oe_order_lines_all ,mtl_units_of_measure
385: WHERE header_id = p_oe_order_header_id
386: AND line_id = p_oe_order_line_id
387: AND uom_code = order_quantity_uom;
388:

Line 2616: FROM oe_order_lines_all

2612: FROM oe_lot_serial_numbers
2613: WHERE (line_id = p_oe_order_line_id
2614: OR line_set_id IN
2615: (SELECT line_set_id
2616: FROM oe_order_lines_all
2617: WHERE line_id = p_oe_order_line_id
2618: AND header_id = p_oe_order_header_id)) ;
2619:
2620: BEGIN

Line 2753: FROM oe_order_lines_all

2749: FROM mtl_material_transactions mmt ,
2750: mtl_transaction_lot_numbers mtln
2751: WHERE mmt.trx_source_line_id IN
2752: (SELECT line_id
2753: FROM oe_order_lines_all
2754: WHERE line_set_id = l_line_set_id)
2755: AND mmt.transaction_source_type_id = 12
2756: AND mmt.transaction_action_id in (1,27)
2757: AND mmt.transaction_type_id in (15,36,37)

Line 2799: FROM oe_order_lines_all

2795: FROM oe_lot_serial_numbers
2796: WHERE (line_id = p_oe_order_line_id
2797: OR line_set_id IN
2798: (SELECT line_set_id
2799: FROM oe_order_lines_all
2800: WHERE line_id = p_oe_order_line_id
2801: AND header_id = p_oe_order_header_id))
2802: AND lot_number = p_lot_number;
2803:

Line 2882: FROM oe_order_lines_all

2878:
2879: BEGIN
2880: SELECT line_set_id
2881: INTO l_line_set_id
2882: FROM oe_order_lines_all
2883: WHERE line_id = p_oe_order_line_id
2884: AND header_id = p_oe_order_header_id;
2885:
2886: l_progress :='065';

Line 2901: FROM oe_order_lines_all ,mtl_units_of_measure

2897: ----------Fetch RMA UNIT_OF_MEASURE
2898:
2899: SELECT unit_of_measure
2900: INTO l_rma_lot_unit_of_measure
2901: FROM oe_order_lines_all ,mtl_units_of_measure
2902: WHERE header_id = p_oe_order_header_id
2903: AND line_id = p_oe_order_line_id
2904: AND uom_code = order_quantity_uom;
2905: