MATERIALIZED VIEW: APPS.ENI_DBI_PRC_SUM1_MV

Source

SELECT /* 12.0: bug#4526784 */
	epum.time_id,
	epum.inventory_item_id,
	epum.product_category_id AS product_category_id,
	epum.organization_id,
        epum.item_org_id AS item_org_id,
	SUM(rev_prim_actual_g) AS rev_amount,
	COUNT(rev_prim_actual_g) AS cnt_rev_amount,
	SUM(rev_sec_actual_g) AS rev_sec_amount,
	COUNT(rev_sec_actual_g) AS cnt_rev_sec_amount,
	SUM(prim_actual_g) AS exp_amount,
	COUNT(prim_actual_g) AS cnt_exp_amount,
	SUM(sec_actual_g) AS exp_sec_amount,
	COUNT(sec_actual_g) AS cnt_exp_sec_amount,
	SUM(cogs_value_g) AS cogs_amount,
	COUNT(cogs_value_g) AS cnt_cogs_amount,
	SUM(cogs_value_sg) AS cogs_sec_amount,
	COUNT(cogs_value_sg) AS cnt_cogs_sec_amount,
	COUNT(*)
FROM
   eni_dbi_prc_union_mv epum
GROUP BY
	   epum.time_id,
	   epum.inventory_item_id,
	   epum.product_category_id,
	   epum.organization_id,
           epum.item_org_id