HTS_SCHEDULE_SHIFTS_VL

Details

• Schema: FUSION

• Object owner: HTS

• Object type: VIEW

Columns

Name

SHIFT_NAME SCHEDULE_SHIFT_ID SCHEDULE_ID SCHEDULE_UNIT_ID APPROVAL_REQ_TO_CLAIM_FLAG SKILL_ID PERSON_ID ASSIGNMENT_ID SHIFT_ID START_DATE_TIME END_DATE_TIME START_TIME_TZ_OFFSET END_TIME_TZ_OFFSET REF_DATE WORK_DURATION BREAK_DURATION SOURCE LOCKED_FLAG ASSIGNMENT_MODE SHIFT_CATEGORY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENTERPRISE_ID COMMENTS ASSIGNED_BY ASSIGNMENT_DATE PREMIUM_SHIFT_CODE SHIFT_INCENTIVE ALLOW_OVERTIME_FLAG AVAIL_TO_OTHER_DEPT_FLAG SHIFT_GROUP_ID SHIFT_TYPE_ID SHIFT_TYPE_CLASSE SHIFT_TYPE SHIFT_TYPE_CODE SHIFT_TYPE_PRODUCTIVITY PAID_BREAK_DURATION MANUAL_PAID_BREAK_DURATION

Query

SQL_Statement

SELECT sh_lib.SHIFT_NAME, sh.SCHEDULE_SHIFT_ID SCHEDULE_SHIFT_ID, sh.SCHEDULE_ID SCHEDULE_ID, sh.SCHEDULE_UNIT_ID SCHEDULE_UNIT_ID, sh.APPROVAL_REQ_TO_CLAIM_FLAG APPROVAL_REQ_TO_CLAIM_FLAG, sh.SKILL_ID SKILL_ID, sh.PERSON_ID PERSON_ID, sh.ASSIGNMENT_ID ASSIGNMENT_ID, sh.SHIFT_ID SHIFT_ID, sh.START_DATE_TIME START_DATE_TIME, sh.END_DATE_TIME END_DATE_TIME, sh.START_TIME_TZ_OFFSET START_TIME_TZ_OFFSET, sh.END_TIME_TZ_OFFSET END_TIME_TZ_OFFSET, sh.REF_DATE REF_DATE, sh.WORK_DURATION WORK_DURATION, nvl(sh.BREAK_DURATION, sh_lib.break_duration) BREAK_DURATION, sh.SOURCE SOURCE, sh.LOCKED_FLAG LOCKED_FLAG, sh.ASSIGNMENT_MODE ASSIGNMENT_MODE, nvl(sh.SHIFT_CATEGORY, sh_lib.SHIFT_CATEGORY) SHIFT_CATEGORY, sh.CREATED_BY CREATED_BY, sh.CREATION_DATE CREATION_DATE, sh.LAST_UPDATED_BY LAST_UPDATED_BY, sh.LAST_UPDATE_DATE LAST_UPDATE_DATE, sh.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, sh.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, sh.ENTERPRISE_ID ENTERPRISE_ID, sh.COMMENTS COMMENTS, sh.ASSIGNED_BY ASSIGNED_BY, sh.ASSIGNMENT_DATE ASSIGNMENT_DATE, sh.PREMIUM_SHIFT_CODE PREMIUM_SHIFT_CODE, sh.SHIFT_INCENTIVE SHIFT_INCENTIVE, sh.ALLOW_OVERTIME_FLAG ALLOW_OVERTIME_FLAG, sh.AVAIL_TO_OTHER_DEPT_FLAG AVAIL_TO_OTHER_DEPT_FLAG, sh.SHIFT_GROUP_ID SHIFT_GROUP_ID, sh.SHIFT_TYPE_ID SHIFT_TYPE_ID, ShiftTypeLookup.lookup_code shift_type_classe, ShiftTypeLookup.EXTENDED_LOOKUP_CODE_NAME shift_type, ShiftTypeLookup.EXTENDED_LOOKUP_CODE shift_type_code, ShiftTypeLookup.information_number1 shift_type_productivity, sh.PAID_BREAK_DURATION PAID_BREAK_DURATION, sh.MANUAL_PAID_BREAK_DURATION MANUAL_PAID_BREAK_DURATION FROM hts_schedule_shifts sh, hts_shifts_vl sh_lib, hcm_extended_lookup_codes_vl ShiftTypeLookup WHERE sh.shift_id = sh_lib.shift_id (+) and sh.shift_type_id = ShiftTypeLookup.EXTENDED_LOOKUP_CODE_ID