DBA Data[Home] [Help]

APPS.INV_OPM_LOT_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 741: FROM ic_item_mst_b i, mtl_system_items_b d

737: l_field_name := 'Matching OPM Item';
738: l_field_value := to_char(p_organization_id) ||', '||to_char(p_inventory_item_id);
739: SELECT i.item_id
740: INTO l_item_id
741: FROM ic_item_mst_b i, mtl_system_items_b d
742: WHERE
743: d.organization_id = p_organization_id AND
744: d.inventory_item_id = p_inventory_item_id AND
745: d.segment1 = i.item_no;