APPS.INV_ROI_INTEGRATION_GRP dependencies on OE_ORDER_LINES_ALL

Line 185: FROM oe_order_lines_all

181: FROM oe_lot_serial_numbers
182: WHERE (line_id = p_oe_order_line_id
183: OR line_set_id IN
184: (SELECT line_set_id
185: FROM oe_order_lines_all
186: WHERE line_id = p_oe_order_line_id
187: AND header_id = p_oe_order_header_id))
188: AND lot_number = v_lot_no;
189:

Line 2509: FROM oe_order_lines_all

2505: FROM oe_lot_serial_numbers
2506: WHERE (line_id = p_oe_order_line_id
2507: OR line_set_id IN
2508: (SELECT line_set_id
2509: FROM oe_order_lines_all
2510: WHERE line_id = p_oe_order_line_id
2511: AND header_id = p_oe_order_header_id)) ;
2512:
2513: BEGIN

Line 2646: FROM oe_order_lines_all

2642: FROM mtl_material_transactions mmt ,
2643: mtl_transaction_lot_numbers mtln
2644: WHERE mmt.trx_source_line_id IN
2645: (SELECT line_id
2646: FROM oe_order_lines_all
2647: WHERE line_set_id = l_line_set_id)
2648: AND mmt.transaction_source_type_id = 12
2649: AND mmt.transaction_action_id in (1,27)
2650: AND mmt.transaction_type_id in (15,36,37)

Line 2690: FROM oe_order_lines_all

2686: FROM oe_lot_serial_numbers
2687: WHERE (line_id = p_oe_order_line_id
2688: OR line_set_id IN
2689: (SELECT line_set_id
2690: FROM oe_order_lines_all
2691: WHERE line_id = p_oe_order_line_id
2692: AND header_id = p_oe_order_header_id))
2693: AND lot_number = p_lot_number;
2694:

Line 2773: FROM oe_order_lines_all

2769:
2770: BEGIN
2771: SELECT line_set_id
2772: INTO l_line_set_id
2773: FROM oe_order_lines_all
2774: WHERE line_id = p_oe_order_line_id
2775: AND header_id = p_oe_order_header_id;
2776:
2777: l_progress :='065';

Line 2792: FROM oe_order_lines_all ,mtl_units_of_measure

2788: ----------Fetch RMA UNIT_OF_MEASURE
2789:
2790: SELECT unit_of_measure
2791: INTO l_rma_lot_unit_of_measure
2792: FROM oe_order_lines_all ,mtl_units_of_measure
2793: WHERE header_id = p_oe_order_header_id
2794: AND line_id = p_oe_order_line_id
2795: AND uom_code = order_quantity_uom;
2796: