SELECT WO.WIP_ENTITY_ID , WO.ORGANIZATION_ID , WO.OPERATION_SEQ_NUM , WO.REPETITIVE_SCHEDULE_ID , BSO.OPERATION_CODE , BD.DEPARTMENT_CODE FROM BOM_DEPARTMENTS BD , BOM_STANDARD_OPERATIONS BSO , WIP_OPERATIONS WO WHERE WO.DEPARTMENT_ID = BD.DEPARTMENT_ID AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) AND NVL(BSO.OPERATION_TYPE , 1) = 1 AND BSO.LINE_ID IS NULL AND EXISTS (SELECT 'LOOKING FOR OSP RESOURCES' FROM WIP_OPERATION_RESOURCES WOR WHERE WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID AND WO.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND NVL(WO.REPETITIVE_SCHEDULE_ID , -1) = NVL(WOR.REPETITIVE_SCHEDULE_ID , -1) AND WOR.AUTOCHARGE_TYPE IN (3 , 4))