View: GHR_DUTY_STATIONS_D

Product:	GHR - US Federal Human Resources
Description:	This views holds information about duty stations.
Implementation/DBA Data:	APPS.GHR_DUTY_STATIONS_D

View Text

SELECT DUTS.DUTY_STATION_ID
, DUTS.EFFECTIVE_START_DATE
, DUTS.EFFECTIVE_END_DATE
, DUTS.DUTY_STATION_CODE
, DUTS.NAME
, DECODE(DUTS.IS_DUTY_STATION
, 'Y'
, 'YES'
, 'NO') IS_DUTY_STATION
, DUTS.MSA_CODE
, DUTS.CMSA_CODE
, DUTS.STATE_OR_COUNTRY_CODE
, DUTS.COUNTY_CODE
, FUSER.USER_NAME LAST_UPDATED_BY
, DUTS.LAST_UPDATE_DATE
FROM GHR_DUTY_STATIONS_F DUTS
, FND_USER FUSER
WHERE FUSER.USER_ID (+) = DUTS.LAST_UPDATED_BY

Columns