SELECT WO.ORGANIZATION_ID , BD.DEPARTMENT_ID , WO.WIP_ENTITY_ID , WO.OPERATION_SEQ_NUM , WE.WIP_ENTITY_NAME || ':' || WO.OPERATION_SEQ_NUM /* || ':' || WOR.RESOURCE_SEQ_NUM */ "JOB_OP_NAME" , DECODE(WDJ.STATUS_TYPE , 6 , 'RED' , NULL) NODE_TEXT_COLOR , DECODE(WDJ.STATUS_TYPE , 6 , 'WPJOBOPH.GIF' , NULL) NODE_ICON , WO.FIRST_UNIT_START_DATE FROM BOM_STANDARD_OPERATIONS BSO , BOM_DEPARTMENTS BD , WIP_DISCRETE_JOBS WDJ , WIP_ENTITIES WE , WIP_OPERATIONS WO WHERE /* YOU NEED NOT JOIN REPETITIVE SCHEDULE AS IT'S NOT REQUIRED */ WO.DEPARTMENT_ID = BD.DEPARTMENT_ID AND WO.ORGANIZATION_ID = BD.ORGANIZATION_ID AND WE.WIP_ENTITY_ID = WO.WIP_ENTITY_ID AND WE.ORGANIZATION_ID = WO.ORGANIZATION_ID AND WE.ENTITY_TYPE = 1 /* ONLY DISCRETE JOBS */ AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID AND WDJ.ORGANIZATION_ID = WO.ORGANIZATION_ID AND WDJ.STATUS_TYPE IN (3 , 4 , 6) /* RELEASED AND COMPLETE CHARGES ALLOWED , ON HOLD */ AND WDJ.PRIMARY_ITEM_ID IS NOT NULL AND (WO.QUANTITY_WAITING_TO_MOVE+WO.QUANTITY_IN_QUEUE+WO.QUANTITY_RUNNING) > 0 AND BSO.STANDARD_OPERATION_ID (+) = WO.STANDARD_OPERATION_ID AND NVL(BSO.OPERATION_TYPE , 1) = 1 AND BSO.LINE_ID IS NULL GROUP BY WO.WIP_ENTITY_ID , WE.WIP_ENTITY_NAME , WO.ORGANIZATION_ID , WO.OPERATION_SEQ_NUM , BD.DEPARTMENT_ID , WDJ.STATUS_TYPE , WO.FIRST_UNIT_START_DATE WITH READ ONLY