VIEW: APPS.GHR_DUTY_STATIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'