MATERIALIZED VIEW: APPS.ISC_DBI_CFM_001_MV

Source

SELECT /* 12.0: bug#4526784 */
	 	mv.inv_org_id						INV_ORG_ID,
		ecat.top_node_flag					TOP_NODE_FLAG,
		ecat.parent_id						PARENT_ID,
		ecat.imm_child_id					IMM_CHILD_ID,
		mv.time_snapshot_date_id				TIME_SNAPSHOT_DATE_ID,
		grouping_id(mv.inv_org_id,
			ecat.top_node_flag,
			ecat.parent_id,
			ecat.imm_child_id,
			mv.time_snapshot_date_id) 			GRP_ID,
		sum(mv.bklg_amt_g)					BKLG_AMT_G,
		count(mv.bklg_amt_g)					BKLG_AMT_G_CNT,
		sum(mv.bklg_amt_g1)					BKLG_AMT_G1,
		count(mv.bklg_amt_g1)					BKLG_AMT_G1_CNT,
		sum(mv.bklg_amt_f)					BKLG_AMT_F,
		count(mv.bklg_amt_f)					BKLG_AMT_F_CNT,
		sum(mv.bklog_qty)					BKLOG_QTY,
		count(mv.bklog_qty)					BKLOG_QTY_CNT,
		count(*)						CNT
	   FROM	isc_dbi_cfm_010_mv 			mv,
	  	ENI.ENI_DENORM_HIERARCHIES 		ecat,
	  	INV.MTL_DEFAULT_CATEGORY_SETS 		mtl
	  WHERE	mv.item_category_id = ecat.child_id
	    AND	ecat.object_type = 'CATEGORY_SET'
	    AND	ecat.object_id = mtl.category_set_id
	    AND	ecat.dbi_flag = 'Y'
	    AND	mtl.functional_area_id = 11
	    AND	mv.item_cat_flag = 1
	    AND	mv.customer_flag = 1
	  GROUP BY mv.inv_org_id,
		ecat.top_node_flag,
		ecat.parent_id,
		ecat.imm_child_id,
		mv.time_snapshot_date_id