Fusion warehouse calendar query

Summary:

Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does not have current year data. What would be otherway of work around to get the query work.

Content (required):

SELECT distinct

    iop.organization_code,

    mc.calendar_name,

    mc.description,

    mcm.year,

    mcm.year_description,

    mcm.year_start_date,

    mcm.year_end_date,

    mcm.quarter,

    mcm.quarter_seq_num,

    mcm.quarter_start_date,

    mcm.quarter_end_date,

    mcm.month,

    mcm.start_of_month,

    mcm.month_start_date,

    mcm.month_end_date,

    mc.quarterly_calendar_type,