VIEW: APPS.HR_LOCATIONS_LOV_V

Source

View Text - Preformatted

SELECT LOCATION_ID , LOCATION_CODE , ADDRESS_LINE_1||'.'|| ADDRESS_LINE_2||'.'|| ADDRESS_LINE_3||'.'||town_or_city ||'.'||region_1||'.'||region_2||'.'||region_3||'.'||postal_code||'.'||country ADDRESS , DESCRIPTION , INACTIVE_DATE , TIMEZONE_CODE FROM HR_LOCATIONS where location_use = 'HR'

View Text - HTML Formatted

SELECT LOCATION_ID
, LOCATION_CODE
, ADDRESS_LINE_1||'.'|| ADDRESS_LINE_2||'.'|| ADDRESS_LINE_3||'.'||TOWN_OR_CITY ||'.'||REGION_1||'.'||REGION_2||'.'||REGION_3||'.'||POSTAL_CODE||'.'||COUNTRY ADDRESS
, DESCRIPTION
, INACTIVE_DATE
, TIMEZONE_CODE
FROM HR_LOCATIONS
WHERE LOCATION_USE = 'HR'