DBA Data[Home] [Help]

VIEW: APPS.HXT_SHIFTS_D

Source

View Text - Preformatted

SELECT shf.name, shf.description, shf.early_start, shf.late_stop, shf.standard_start, shf.standard_stop, shf.effective_start_date, shf.effective_end_date, FUSER.user_name, shf.last_update_date from hxt_shifts SHF, fnd_user_view FUSER WHERE FUSER.user_id = SHF.last_updated_by
View Text - HTML Formatted

SELECT SHF.NAME
, SHF.DESCRIPTION
, SHF.EARLY_START
, SHF.LATE_STOP
, SHF.STANDARD_START
, SHF.STANDARD_STOP
, SHF.EFFECTIVE_START_DATE
, SHF.EFFECTIVE_END_DATE
, FUSER.USER_NAME
, SHF.LAST_UPDATE_DATE
FROM HXT_SHIFTS SHF
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID = SHF.LAST_UPDATED_BY