DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 178: MTL_SYSTEM_ITEMS_B MSI

174:
175: CURSOR workorder_material_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS
176: select WRO.INVENTORY_ITEM_ID,OPERATION_SEQ_NUM,DATE_REQUIRED,STOCK_ENABLED_FLAG
177: FROM WIP_REQUIREMENT_OPERATIONS WRO,
178: MTL_SYSTEM_ITEMS_B MSI
179: WHERE WRO.WIP_ENTITY_ID = l_obj_id
180: AND MSI.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
181: AND MSI.ORGANIZATION_ID = WRO.ORGANIZATION_ID
182: AND l_obj_type_id = 1;