MSC_WTM_MANUFACTURING_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID CALENDAR_CODE DAY SUB_WEEK_START_DATE SUB_WEEK_END_DATE SUB_WEEK_LENGTH WEEK_START_DATE WEEK_END_DATE WEEK_LENGTH PERIOD_START_DATE PERIOD_END_DATE PERIOD_LENGTH

Query

SQL_Statement

SELECT head.id AS ID, head.hierarchy_id AS CALENDAR_CODE, day_subweek.day AS DAY, day_subweek.sub_week_start_date AS SUB_WEEK_START_DATE, day_subweek.sub_week_end_date AS SUB_WEEK_END_DATE, day_subweek.sub_week_length AS SUB_WEEK_LENGTH, week_periods.week_start_date AS WEEK_START_DATE, week_periods.week_end_date AS WEEK_END_DATE, week_periods.week_length AS WEEK_LENGTH, week_periods.period_start_date AS PERIOD_START_DATE, week_periods.period_end_date AS PERIOD_END_DATE, week_periods.period_length AS PERIOD_LENGTH FROM MSC_WTM_CALENDAR_HEADER head, MSC_WTM_CALENDAR_DAY_SUBWEEK day_subweek, MSC_WTM_CALENDAR_WEEK_PERIODS week_periods WHERE head.id = day_subweek.id and head.id = week_periods.id and head.hierarchy_id = week_periods.hierarchy_id and day_subweek.day = week_periods.day and head.calendar_type = 5