VIEW: APPS.HR_LOCATIONS_ALL_LOV_V

Source

View Text - Preformatted

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 ,loc.timezone_code 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')

View Text - HTML Formatted

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
, LOC.TIMEZONE_CODE
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')