View: HR_LOCATIONS_LOV_V

Product:	PER - Human Resources
Description:	HR Web Offers list of values view.
Implementation/DBA Data:	APPS.HR_LOCATIONS_LOV_V

View Text

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
FROM HR_LOCATIONS
WHERE LOCATION_USE = 'HR'

Columns