HTS_WORK_PATTERNS_VL

Details

• Schema: FUSION

• Object owner: HTS

• Object type: VIEW

Columns

Name
WORK_PATTERN_ID WORK_PATTERN_ALTCD WORK_PATTERN_NAME WORK_PATTERN_TYPE_ID TEMPLATE_FLAG REPEAT_CYCLE REPEAT_NUM START_DAY_OF_PATTERN NON_WORKING_CYCLES OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID

Query

SQL_Statement

SELECT WPB.WORK_PATTERN_ID WORK_PATTERN_ID, WPB.WORK_PATTERN_ALTCD WORK_PATTERN_ALTCD, WPTL.WORK_PATTERN_NAME WORK_PATTERN_NAME, WPB.WORK_PATTERN_TYPE_ID WORK_PATTERN_TYPE_ID, WPB.TEMPLATE_FLAG TEMPLATE_FLAG, WPB.REPEAT_CYCLE REPEAT_CYCLE, WPB.REPEAT_NUM REPEAT_NUM, WPB.START_DAY_OF_PATTERN START_DAY_OF_PATTERN, WPB.NON_WORKING_CYCLES NON_WORKING_CYCLES, WPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WPB.CREATION_DATE CREATION_DATE, WPB.CREATED_BY CREATED_BY, WPB.LAST_UPDATED_BY LAST_UPDATED_BY, WPB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WPB.ENTERPRISE_ID ENTERPRISE_ID FROM HTS_WORK_PATTERNS_B WPB, HTS_WORK_PATTERNS_TL WPTL WHERE WPB.WORK_PATTERN_ID = WPTL.WORK_PATTERN_ID AND WPTL.LANGUAGE = USERENV('LANG')