[Home] [Help]
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
Name |
DUTY_STATION_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
DUTY_STATION_CODE |
NAME |
IS_DUTY_STATION |
MSA_CODE |
CMSA_CODE |
STATE_OR_COUNTRY_CODE |
COUNTY_CODE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |