DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 186: MTL_SYSTEM_ITEMS_B MSI

182:
183: CURSOR workorder_material_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS
184: select WRO.INVENTORY_ITEM_ID,OPERATION_SEQ_NUM,DATE_REQUIRED,STOCK_ENABLED_FLAG
185: FROM WIP_REQUIREMENT_OPERATIONS WRO,
186: MTL_SYSTEM_ITEMS_B MSI
187: WHERE WRO.WIP_ENTITY_ID = l_obj_id
188: AND MSI.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
189: AND MSI.ORGANIZATION_ID = WRO.ORGANIZATION_ID
190: AND l_obj_type_id = 1;