MATERIALIZED VIEW: APPS.CSY_RESOLUTION_QUALITY_MV

Source

select period_type, period_name,
         owner_type,
         incident_owner_id,
         incident_severity_id,
         sum(total_sr_resolved_1st_time) total_sr_resolved_1st_time,
         sum(total_sr_reopened)          total_sr_reopened,
         sum(tot_sr_reopened_once_or_more) tot_sr_reopened_once_or_more
    from csy_resolution_qlty resl,
          csy_periods_v per
  where resl.summary_date between per.start_date and per.end_date
   group by period_type,
         period_name,
         incident_severity_id,
         owner_type,
         incident_owner_id