MSC_SCHEDULES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SCHEDULE_ID PATTERN_ID SHIFT_ID AVAILABILITY_CODE DAY_START_NUM DAY_STOP_NUM PATTERN_LENGTH PATTERN_SEQ_NUM

Query

SQL_Statement

select zssb.schedule_id, shift_pattern.pattern_id, shift_pattern.shift_id,shift_pattern.availability_code, shift_pattern.day_start_num, shift_pattern.day_stop_num, shift_pattern.pattern_length, shift_pattern.pattern_seq_num from zmm_sr_schedules_b zssb, (select zspd.pattern_id, zspd.child_shift_id shift_id, zssb.availability_code, zspd.day_start_num, zspd.day_stop_num, zspb.length_days_num pattern_length, zssp.schedule_id, zssp.pattern_seq_num from zmm_sr_pattern_dtls zspd, zmm_sr_shifts_b zssb, zmm_sr_patterns_b zspb, zmm_sr_schedule_patterns zssp where zspd.child_shift_id = zssb.shift_id and zspd.pattern_id = zspb.pattern_id and zspd.pattern_id = zssp.pattern_id ) shift_pattern where zssb.schedule_id = shift_pattern.schedule_id(+) order by zssb.schedule_id,shift_pattern.pattern_seq_num