MATERIALIZED VIEW: APPS.ENI_DBI_GL_BASE_SUM_MV

Source

SELECT  /* 12.0: bug#4526784 */
			edgb.time_id,
			edgb.line_of_business_id,
			edhi.parent_id AS product_category_id,
			SUM(prim_actual_g) AS prim_actual_g,
			COUNT(prim_actual_g) AS cnt_prim_actual_g,

			SUM(sec_actual_g) AS sec_actual_g,   --added
			COUNT(sec_actual_g) AS cnt_sec_actual_g, --added

			COUNT(*),
			GROUPING_ID
			(
				time_Id,
				line_of_business_id,
				edhi.parent_id
			) AS GID,
			1 AS MARKER
		FROM
			eni_dbi_gl_base_mv edgb,
			ENI.ENI_DENORM_HIERARCHIES edhi
		WHERE
			edhi.child_id = edgb.product_category_id
		GROUP BY
			GROUPING SETS
			(
				(
					time_id,
					line_of_business_id,
					edhi.parent_id
				),
				(
					time_id,
					edhi.parent_id
				)
			)
		UNION ALL
		SELECT
			edgb.time_id,
			NULL AS line_of_business_id,
			NULL AS product_category_id,
			SUM(prim_actual_g) AS prim_actual_g,
			COUNT(prim_actual_g) AS cnt_prim_actual_g,

			SUM(sec_actual_g) AS sec_actual_g,   --added
			COUNT(sec_actual_g) AS cnt_sec_actual_g, --added

			COUNT(*),
			GROUPING_ID
			(
				time_id
			) AS GID,
			2 AS MARKER
		FROM
			eni_dbi_gl_base_mv edgb
		GROUP BY
			GROUPING SETS
			(
				(
					time_id
				)
			)
		UNION ALL
		SELECT
			edgb.time_id,
			edgb.line_of_business_id,
			NULL AS product_category_id,
			SUM(prim_actual_g) AS prim_actual_g,
			COUNT(prim_actual_g) AS cnt_prim_actual_g,

			SUM(sec_actual_g) AS sec_actual_g,   --added
			COUNT(sec_actual_g) AS cnt_sec_actual_g, --added

			COUNT(*),
			GROUPING_ID
			(
				time_id,
				line_of_business_id
			) AS GID,
			3 AS MARKER
		FROM
			eni_dbi_gl_base_mv edgb
		GROUP BY
			GROUPING SETS
			(
				(
					time_id,
					line_of_business_id
				)
			)