View: GHR_DUTY_STATIONS_V

Product:	GHR - US Federal Human Resources
Description:	This view makes self reference to get expanded duty station name.
Implementation/DBA Data:	APPS.GHR_DUTY_STATIONS_V

View Text

SELECT CITY.DUTY_STATION_CODE
, CITY.DUTY_STATION_ID
, CITY.NAME || DECODE(SUBSTR(CITY.DUTY_STATION_CODE
, 7
, 3)
, '000'
, NULL
, ' / ' || COUNTY.NAME) || ' / ' || STATE.NAME DUTY_STATION_DESC
, CITY.EFFECTIVE_START_DATE
, CITY.EFFECTIVE_END_DATE
FROM GHR_DUTY_STATIONS_F STATE
, GHR_DUTY_STATIONS_F COUNTY
, GHR_DUTY_STATIONS_F CITY
WHERE ( STATE.DUTY_STATION_CODE = CITY.STATE_OR_COUNTRY_CODE
AND CITY.EFFECTIVE_END_DATE BETWEEN STATE.EFFECTIVE_START_DATE
AND STATE.EFFECTIVE_END_DATE )
AND ( COUNTY.DUTY_STATION_CODE = CITY.COUNTY_CODE
AND CITY.EFFECTIVE_END_DATE BETWEEN COUNTY.EFFECTIVE_START_DATE
AND COUNTY.EFFECTIVE_END_DATE )
AND UPPER(NVL(CITY.IS_DUTY_STATION
, 'Y')) = 'Y'

Columns