MATERIALIZED VIEW: APPS.MTH_SHIFT_GREGORIAN_DENORM_MV

Source

select  ws.shift_workday_pk_key, ws.shift_date, ws.plant_fk_key, ws.system_fk_key,ws.from_date,
  ws.To_Date, gc.day_id, gc.calendar_month_id, gc.calendar_quarter_id, gc.calendar_year_id, gc.CALENDAR_MONTH_START_DATE,
  gc.CALENDAR_QUARTER_START_DATE, gc.CALENDAR_YEAR_START_DATE, ws.ROWID rowid_ws, gc.ROWID rowid_gc
     FROM  MTH_WORKDAY_SHIFTS_D ws, MTH_GREGORIAN_CALENDAR gc
     where ws.SHIFT_DATE = gc.DAY
           AND gc.DAY IS NOT NULL