MATERIALIZED VIEW: APPS.BIM_I_CPB_METR_MV

Source

select    a.time_id
               ,a.period_type_id
	       ,b.parent_source_code_id source_code_id
	       ,b.prior_id  immediate_parent_id
	       ,a.object_region
               ,a.object_country
	       ,a.category_id
	       ,a.activity_id
               ,sum(leads) total_leads
               ,count(leads) total_leads_c
                ,sum(a.total_cost) total_cost
                ,count(a.total_cost) total_cost_c
		,sum(a.booked_amt) booked_amt
                ,count(a.booked_amt) booked_amt_c
		,sum(a.invoiced_amt) invoiced_amt
                ,count(a.invoiced_amt) invoiced_amt_c
                ,sum(a.won_opportunity_amt) won_opportunity_amt
                ,count(a.won_opportunity_amt) won_opportunity_amt_c
		,sum(a.budget_approved) budget_approved
                ,count(a.budget_approved) budget_approved_c
		,sum(a.actual_cost)  actual_cost
		,count(a.actual_cost)  actual_cost_c
		,sum(a.customers_targeted)  customers_targeted
		,count(a.customers_targeted)  customers_targeted_c
		,sum(a.responses_forecasted)  responses_forecasted
		,count(a.responses_forecasted)  responses_forecasted_c
		,sum(a.responses_positive)  responses_positive
		,count(a.responses_positive)  responses_positive_c
                ,sum(a.total_cost_s) total_cost_s
                ,count(a.total_cost_s) total_cost_s_c
		,sum(a.booked_amt_s) booked_amt_s
                ,count(a.booked_amt_s) booked_amt_s_c
		,sum(a.invoiced_amt_s) invoiced_amt_s
                ,count(a.invoiced_amt_s) invoiced_amt_s_c
                ,sum(a.won_opportunity_amt_s) won_opportunity_amt_s
                ,count(a.won_opportunity_amt_s) won_opportunity_amt_s_c
		,sum(a.budget_approved_s) budget_approved_s
                ,count(a.budget_approved_s) budget_approved_s_c
		,sum(a.actual_cost_s)  actual_cost_s
		,count(a.actual_cost_s)  actual_cost_s_c
			,sum(a.budget_approved_sch) budget_approved_sch
			,count(a.budget_approved_sch) budget_approved_sch_c
			,sum(a.budget_approved_sch_s) budget_approved_sch_s
			,count(a.budget_approved_sch_s) budget_approved_sch_s_c
                ,count(*)  all_c
        From  bim_i_mkt_cpb_mv a,
	      BIM.BIM_I_SOURCE_DENORM b
       where  a.source_code_id = b.source_code_id
	  group by
		 a.period_type_id
		 ,a.time_id
		 ,a.object_country
		 ,a.object_region
		 ,a.category_id
		 ,b.parent_source_code_id
		 ,b.prior_id
		 ,a.activity_id