DBA Data[Home] [Help]

APPS.INV_OPM_LOT_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 835: FROM ic_item_mst_b i, mtl_system_items_b d

831: l_field_name := 'Matching OPM Item';
832: l_field_value := to_char(p_organization_id) ||', '||to_char(p_inventory_item_id);
833: SELECT i.item_id
834: INTO l_item_id
835: FROM ic_item_mst_b i, mtl_system_items_b d
836: WHERE
837: d.organization_id = p_organization_id AND
838: d.inventory_item_id = p_inventory_item_id AND
839: d.segment1 = i.item_no;