View: HR_LOCATIONS_ALL_LOV_V

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

View Text

SELECT LOC.LOCATION_ID
, LOT.LOCATION_CODE
, 'HR'
, LOC.BUSINESS_GROUP_ID
, LOT.DESCRIPTION
, LOC.INACTIVE_DATE
, LOC.SHIP_TO_LOCATION_ID
, LOC.SHIP_TO_SITE_FLAG
, LOC.STYLE
, LOC.ADDRESS_LINE_1 || '.' || LOC.ADDRESS_LINE_2 ||'.'|| LOC.ADDRESS_LINE_3 ||'.'|| LOC.TOWN_OR_CITY || '.'|| LOC.REGION_1 ||'.'|| LOC.REGION_2 ||'.'|| LOC.REGION_3 ||'.'|| LOC.POSTAL_CODE ||'.' || LOC.COUNTRY ADDRESS
, LOC.TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3
, LOC.OBJECT_VERSION_NUMBER
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE NVL (LOC.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) ) = NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG')

Columns