View: HRIFV_US_FEDREP_GEN_H_LOCEXP

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ 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

Columns