SELECT l.location_id, l.location_code location_code, l.description location_description, l.inactive_date from hr_locations l WHERE l.location_use = 'HR'
View Text - HTML Formatted
SELECT L.LOCATION_ID , L.LOCATION_CODE LOCATION_CODE , L.DESCRIPTION LOCATION_DESCRIPTION , L.INACTIVE_DATE FROM HR_LOCATIONS L WHERE L.LOCATION_USE = 'HR'