select period_type, period_name,
incident_severity_id,
owner_group_id,
sum (total_response_time ) total_response_time,
sum (total_requests_responded ) total_sr_responded,
sum (total_resp_sla_missed ) total_resp_sla_missed,
sum (total_wait_on_agent_resp ) total_agent_wait,
sum (total_wait_on_others_resp) total_others_wait,
sum (total_resolve_time) total_resolve_time,
sum (total_requests_resolved) total_sr_resolved,
sum (total_wait_on_agent_resl) total_wait_agent,
sum (total_wait_on_support_resl) total_wait_support,
sum (total_wait_on_int_org_resl) total_wait_internal,
sum (total_wait_on_ext_org_resl) total_wait_external,
sum (total_wait_on_customer_resl) total_wait_customer,
sum (total_resl_sla_missed) total_resl_sla_missed,
sum (decode(resp.summary_date, per.start_date,beginning_backlog,0))
beginning_backlog,
sum (decode(resp.summary_date, per.end_date ,ending_backlog,0))
ending_backlog,
sum (total_sr_assigned) total_sr_assigned,
sum (total_sr_reassigned_to_others) total_sr_reassigned_to_others
from csy_response_resolutions resp,
csy_periods_v per
where resp.summary_date between per.start_date and per.end_date
and owner_type = 'G'
group by period_type,
period_name,
incident_severity_id,
owner_group_id