VIEW: APPS.GHR_DUTY_STATIONS_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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