[Home] [Help]
View: 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 |