SELECT RES.ID1 ID , RES.RESOURCE_NUMBER RESOURCE_NUMBER , RES.RESOURCE_TYPE RESOURCE_TYPE , RES.NAME NAME , RES.DESCRIPTION DESCRIPTION , RES.START_DATE_ACTIVE START_DATE_ACTIVE , RES.END_DATE_ACTIVE END_DATE_ACTIVE FROM OKX_RESOURCES_V RES WHERE EXISTS (SELECT 'X' FROM OKX_RESOURCE_ROLES_V RR WHERE RR.RESOURCE_TYPE = 'RS_INDIVIDUAL' AND RR.STATUS = 'A' AND NVL(RR.DELETE_FLAG , 'N') = 'N' AND RR.RESOURCE_ID =RES.ID1)