APPS.OE_UPG_SO_NEW dependencies on MTL_SO_RMA_INTERFACE

Line 1629: from mtl_so_rma_interface

1625: begin
1626: Select inventory_item_id,unit_code
1627: into r_inventory_item_id_2,
1628: r_uom_code_2
1629: from mtl_so_rma_interface
1630: where rma_line_id = mol.line_id;
1631: exception
1632: when others then
1633: r_no_config_item := TRUE;

Line 1646: from mtl_so_rma_interface

1642:
1643: begin
1644: IF r_pto_m_c_k THEN
1645: select received_quantity into v_received_quantity
1646: from mtl_so_rma_interface
1647: where mol.line_id = rma_line_id
1648: and mol.inventory_item_id = inventory_item_id;
1649: ELSE
1650: select received_quantity into v_received_quantity

Line 1651: from mtl_so_rma_interface

1647: where mol.line_id = rma_line_id
1648: and mol.inventory_item_id = inventory_item_id;
1649: ELSE
1650: select received_quantity into v_received_quantity
1651: from mtl_so_rma_interface
1652: where mol.line_id = rma_line_id;
1653: END IF;
1654:
1655: if v_received_quantity = 0 THEN

Line 8392: from mtl_so_rma_interface

8388: Cursor C1 is
8389: Select rma_interface_id,rma_id,rma_line_id,
8390: inventory_item_id,component_sequence_id,
8391: quantity, unit_code,received_quantity,delivered_quantity
8392: from mtl_so_rma_interface
8393: where rma_line_id = p_line_id
8394: and inventory_item_id <> l_inventory_item_id;
8395: --
8396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;