VIEW: APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP

Source

View Text - Preformatted

SELECT locT.location_code location_name , locT.description location_description , loc.address_line_1 address_line_1 , loc.address_line_2 address_line_2 , loc.address_line_3 address_line_3 , loc.town_or_city city , loc.region_1 county , hr_general.decode_lookup('US_STATE',loc.region_2) state_name , loc.region_2 state_code , loc.country country , loc.postal_code zip_code , loc.inactive_date inactive_date , loc.style address_style , loc.tax_name default_tax_code /* descriptive flex */ ,'_DF:PER:HR_LOCATIONS:loc' /* ids */ , loc.location_id location_id , loc.business_group_id business_group_id FROM hr_locations_all loc , hr_locations_all_tl locT WHERE loc.location_id = locT.location_id AND locT.language = userenv('LANG') AND loc.style = 'US' AND loc.location_id not in ( select sub_entity_id from hri_gen_hrchy_summary ) WITH READ ONLY

View Text - HTML Formatted

SELECT LOCT.LOCATION_CODE LOCATION_NAME
, LOCT.DESCRIPTION LOCATION_DESCRIPTION
, LOC.ADDRESS_LINE_1 ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2 ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3 ADDRESS_LINE_3
, LOC.TOWN_OR_CITY CITY
, LOC.REGION_1 COUNTY
, HR_GENERAL.DECODE_LOOKUP('US_STATE'
, LOC.REGION_2) STATE_NAME
, LOC.REGION_2 STATE_CODE
, LOC.COUNTRY COUNTRY
, LOC.POSTAL_CODE ZIP_CODE
, LOC.INACTIVE_DATE INACTIVE_DATE
, LOC.STYLE ADDRESS_STYLE
, LOC.TAX_NAME DEFAULT_TAX_CODE /* DESCRIPTIVE FLEX */
, '_DF:PER:HR_LOCATIONS:LOC' /* IDS */
, LOC.LOCATION_ID LOCATION_ID
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOCT
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND LOCT.LANGUAGE = USERENV('LANG')
AND LOC.STYLE = 'US'
AND LOC.LOCATION_ID NOT IN ( SELECT SUB_ENTITY_ID
FROM HRI_GEN_HRCHY_SUMMARY ) WITH READ ONLY