DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 185: FROM WIP_REQUIREMENT_OPERATIONS WRO,

181: AND l_obj_type_id = 1;
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