SELECT WL.LINE_CODE , WL.DESCRIPTION , WL.LINE_ID , WL.ORGANIZATION_ID FROM WIP_LINES WL WHERE NVL(WL.DISABLE_DATE , SYSDATE + 1) > SYSDATE AND EXISTS (SELECT 'LOOKING FOR OSP RESOURCES' FROM WIP_OPERATION_RESOURCES WOR , WIP_FIRST_ACTIVE_SCHEDULE_V WRS WHERE WRS.ORGANIZATION_ID = WL.ORGANIZATION_ID AND WRS.LINE_ID = WL.LINE_ID AND WRS.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND WRS.REPETITIVE_SCHEDULE_ID = WOR.REPETITIVE_SCHEDULE_ID AND WOR.AUTOCHARGE_TYPE IN (3 , 4))