eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HXT_WORK_SHIFTS_FMV

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_WORK_SHIFTS_FMV

View Text

SELECT HWS.ROWID ROW_ID
, HWS.SHT_ID
, HWS.TWS_ID
, HWS.WEEK_DAY
, HRL.MEANING
, HWS.SEQ_NO
, HWS.EARLY_START
, HWS.LATE_STOP
, HWS.CREATED_BY
, HWS.CREATION_DATE
, HWS.LAST_UPDATED_BY
, HWS.LAST_UPDATE_DATE
, HWS.LAST_UPDATE_LOGIN
, HWS.OFF_SHIFT_PREM_ID
, HWS.SHIFT_DIFF_OVRRD_ID
FROM HR_LOOKUPS HRL
, HXT_WORK_SHIFTS HWS
WHERE HRL.LOOKUP_TYPE = 'HXT_DAY_OF_WEEK'
AND HRL.LOOKUP_CODE = HWS.WEEK_DAY
AND HRL.APPLICATION_ID = 808

Columns

Name
ROW_ID
SHT_ID
TWS_ID
WEEK_DAY
MEANING
SEQ_NO
EARLY_START
LATE_STOP
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OFF_SHIFT_PREM_ID
SHIFT_DIFF_OVRRD_ID