MSC_WTM_FISCAL_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 MONTH_START_DATE MONTH_END_DATE MONTH_LENGTH QUARTER_START_DATE QUARTER_END_DATE QUARTER_LENGTH YEAR_START_DATE YEAR_END_DATE YEAR_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, months.month_start_date AS MONTH_START_DATE, months.month_end_date AS MONTH_END_DATE, months.month_length AS MONTH_LENGTH, months.quarter_start_date AS QUARTER_START_DATE, months.quarter_end_date AS QUARTER_END_DATE , months.quarter_length AS QUARTER_LENGTH, months.year_start_date AS YEAR_START_DATE, months.year_end_date AS YEAR_END_DATE, months.year_length AS YEAR_LENGTH FROM MSC_WTM_CALENDAR_HEADER head, MSC_WTM_CALENDAR_DAY_SUBWEEK day_subweek, MSC_WTM_CALENDAR_MONTHS months WHERE head.id = day_subweek.id and head.id = months.id and head.hierarchy_id = months.hierarchy_id and day_subweek.day = months.day and head.calendar_type = 3