MSC_AP_CAL_WEEK_START_DATES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_CODE WEEK_START_DATE SEQ_NUM NEXT_DATE PRIOR_DATE

Query

SQL_Statement
select ''||weekstdt.SCHEDULE_ID CALENDAR_CODE, weekstdt.WEEK_START_DATE, weekstdt.SEQ_NUM, weekstdt.NEXT_DATE, weekstdt.PRIOR_DATE From ZMM_SR_WEEK_START_DATES weekstdt, MSC_AP_SCHEDULES_V cal where cal.calendar_code = ''||weekstdt.SCHEDULE_ID