[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 |
APPS.HXT_WEEKLY_WORK_SCHEDULES_FMV