MATERIALIZED VIEW: APPS.BIM_I_MKT_CRPL_MV

Source

SELECT /* Dummy Comment */
       a.Time_Id			Time_Id,
       a.Period_type_id			Period_Type_Id,
       'Y'		                admin_flag,
       decode(grouping(a.object_country),1,'N',0,a.object_country) object_country,
       a.object_country                 object_country_c,
       decode(grouping(a.category_id),1,-9,0,a.category_id) category_id,
       a.category_id                    category_id_c,
       SUM(leads)			Total_Leads,
       COUNT(leads)		        Total_Leads_C,
       SUM(Total_Cost)			Total_Cost,
       COUNT(Total_Cost)		Total_Cost_C,
       SUM(Budget_Approved)		Budget_Approved,
       COUNT(Budget_Approved)		Budget_Approved_C,
       sum(a.actual_cost)  actual_cost
	,count(a.actual_cost)  actual_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.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
       ,COUNT(*)				All_C,
       GROUPING_ID(a.Object_country,a.time_id,a.period_type_id,a.category_id) grouping_id
FROM   bim_i_mkt_cpb_mv  a
GROUP BY a.Time_Id,
       a.Period_type_id,
       --a.all_access_flag,
       CUBE(a.Object_country,a.category_id)