MSC_AP_CALENDAR_SHIFTS_TIME_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_CODE SHIFT_NUM SHIFT_NAME DESCRIPTION FROM_TIME TO_TIME SHIFT_TYPE_CODE

Query

SQL_Statement

Select distinct ''||zssp.schedule_id CALENDAR_CODE, zssv.shift_id shift_num, zssv.shift_name, zssv.shift_desc description, zssv.start_time_ms_num from_time, zssv.end_time_ms_num to_time, zssv.shift_type_code from ZMM_SR_SHIFTS_VL zssv, ZMM_SR_PATTERN_DTLS zspd, ZMM_SR_SCHEDULE_PATTERNS zssp, MSC_AP_SCHEDULES_V cal where zspd.pattern_id(+) = zssp.pattern_id and zspd.child_shift_id = zssv.shift_id and ''||zssp.schedule_id = cal.CALENDAR_CODE