SELECT HRE.FULL_NAME , HRE.EMPLOYEE_NUM , HRE.LOCATION_ID , CSH.SCHEDULE_OWNER_ID FROM CHV_SCHEDULE_HEADERS CSH , HR_EMPLOYEES_CURRENT_V HRE WHERE CSH.SCHEDULE_OWNER_ID = HRE.EMPLOYEE_ID UNION SELECT NULL , NULL , TO_NUMBER(NULL) , CSH.SCHEDULE_OWNER_ID FROM CHV_SCHEDULE_HEADERS CSH WHERE NOT EXISTS (SELECT 1 FROM HR_EMPLOYEES_CURRENT_V HRE WHERE CSH.SCHEDULE_OWNER_ID = HRE.EMPLOYEE_ID)