[Home] [Help]
View: HXT_WEEKLY_WORK_SCHEDULES_FMV
View Text
SELECT HWWS.ROWID ROW_ID
, HWWS.ID
, HWWS.NAME
, HWWS.BUSINESS_GROUP_ID
, HWWS.START_DAY
, HRL.MEANING
, HWWS.DATE_FROM
, HWWS.DESCRIPTION
, HWWS.DATE_TO
, HWWS.CREATED_BY
, HWWS.CREATION_DATE
, HWWS.LAST_UPDATED_BY
, HWWS.LAST_UPDATE_DATE
, HWWS.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS HRL
, HXT_WEEKLY_WORK_SCHEDULES HWWS
WHERE HRL.LOOKUP_TYPE = 'HXT_DAY_OF_WEEK'
AND HRL.LOOKUP_CODE = HWWS.START_DAY
AND HRL.APPLICATION_ID = 808
Columns
Name |
ROW_ID |
ID |
NAME |
BUSINESS_GROUP_ID |
START_DAY |
MEANING |
DATE_FROM |
DESCRIPTION |
DATE_TO |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |