MATERIALIZED VIEW: APPS.ENI_DBI_CO_SUM_MV

Source

select /* 12.0: bug#4526784 */  organization_id
     , item_id
     , item_org_id
     , time_id
     , period_type_id
     , change_order_type_id
     , reason_code
     , priority_code
     , status_type
     , sum(implemented_sum) implemented_sum
     , count(implemented_sum) implemented_sum_cnt
     , sum(cancelled_sum) cancelled_sum
     , count(cancelled_sum) cancelled_sum_cnt
     , sum(new_sum) new_sum
     , count(new_sum) new_sum_cnt
     , sum(cycle_time_sum) cycle_time_sum
     , count(cycle_time_sum) cycle_time_sum_cnt
     , sum(cycle_time_cnt) cycle_time_cnt
     , count(cycle_time_cnt) cycle_time_cnt_cnt
     , sum(approve_to_impl_sum) approve_to_impl_sum
     , count(approve_to_impl_sum) approve_to_impl_sum_cnt
     , sum(approve_to_impl_cnt) approve_to_impl_cnt
     , count(approve_to_impl_cnt) approve_to_impl_cnt_cnt
     , sum(create_to_approve_sum) create_to_approve_sum
     , count(create_to_approve_sum) create_to_approve_sum_cnt
     , sum(create_to_approve_cnt) create_to_approve_cnt
     , count(create_to_approve_cnt) create_to_approve_cnt_cnt
     , sum(bucket1_sum) bucket1_sum
     , count(bucket1_sum) bucket1_sum_cnt
     , sum(bucket2_sum) bucket2_sum
     , count(bucket2_sum) bucket2_sum_cnt
     , sum(bucket3_sum) bucket3_sum
     , count(bucket3_sum) bucket3_sum_cnt
     , sum(bucket4_sum) bucket4_sum
     , count(bucket4_sum) bucket4_sum_cnt
     , count(*)
 from ENI_DBI_CO_UNION_MV mv
 group by 
       organization_id
     , item_id
     , item_org_id
     , time_id
     , period_type_id
     , change_order_type_id
     , reason_code
     , priority_code
     , status_type