HWM_WORK_DAY_DEF_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

WORK_DAY_DEF_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID NAME DESCRIPTION DAY_START_TIME DAY_BREAKER_RULE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID1 WORK_DAY_DEF_CD SGUID BREAK_THRESHOLD TIE_BREAK_CRITERIA IS_OVERTIME_NEXT_DAY EARNED_TIE_BREAK_CRITERIA EARNED_BREAK_THRESHOLD EARNED_DAY_BREAK_RULE EARNED_DAY_START_TIME IS_EARNED_NEXT_DAY IS_SAME_DEFINITION

Query

SQL_Statement

SELECT HWM_WORK_DAY_DEF_B.WORK_DAY_DEF_ID WORK_DAY_DEF_ID, HWM_WORK_DAY_DEF_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_WORK_DAY_DEF_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_WORK_DAY_DEF_B.MODULE_ID MODULE_ID, HWM_WORK_DAY_DEF_TL.NAME NAME, HWM_WORK_DAY_DEF_TL.DESCRIPTION DESCRIPTION, HWM_WORK_DAY_DEF_B.DAY_START_TIME DAY_START_TIME, HWM_WORK_DAY_DEF_B.DAY_BREAKER_RULE DAY_BREAKER_RULE, HWM_WORK_DAY_DEF_B.CREATED_BY CREATED_BY, HWM_WORK_DAY_DEF_B.CREATION_DATE CREATION_DATE, HWM_WORK_DAY_DEF_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_WORK_DAY_DEF_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_WORK_DAY_DEF_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_WORK_DAY_DEF_TL.ENTERPRISE_ID ENTERPRISE_ID1, HWM_WORK_DAY_DEF_B.WORK_DAY_DEF_CD WORK_DAY_DEF_CD, HWM_WORK_DAY_DEF_B.SGUID SGUID, HWM_WORK_DAY_DEF_B.BREAK_THRESHOLD BREAK_THRESHOLD, HWM_WORK_DAY_DEF_B.TIE_BREAK_CRITERIA TIE_BREAK_CRITERIA, HWM_WORK_DAY_DEF_B.IS_OVERTIME_NEXT_DAY IS_OVERTIME_NEXT_DAY, HWM_WORK_DAY_DEF_B.EARNED_TIE_BREAK_CRITERIA EARNED_TIE_BREAK_CRITERIA, HWM_WORK_DAY_DEF_B.EARNED_BREAK_THRESHOLD EARNED_BREAK_THRESHOLD, HWM_WORK_DAY_DEF_B.EARNED_DAY_BREAK_RULE EARNED_DAY_BREAK_RULE, HWM_WORK_DAY_DEF_B.EARNED_DAY_START_TIME EARNED_DAY_START_TIME, HWM_WORK_DAY_DEF_B.IS_EARNED_NEXT_DAY IS_EARNED_NEXT_DAY, HWM_WORK_DAY_DEF_B.IS_SAME_DEFINITION IS_SAME_DEFINITION FROM HWM_WORK_DAY_DEF_B, HWM_WORK_DAY_DEF_TL WHERE HWM_WORK_DAY_DEF_TL.WORK_DAY_DEF_ID = HWM_WORK_DAY_DEF_B.WORK_DAY_DEF_ID AND HWM_WORK_DAY_DEF_TL.LANGUAGE = USERENV('LANG')