MATERIALIZED VIEW: APPS.ISC_DBI_CFM_017_MV

Source

SELECT	/* 12.0: bug#4526784 */
	 	mv.inv_org_id						INV_ORG_ID,
		mv.top_model_org_id					TOP_MODEL_ORG_ID,
		ecat.top_node_flag					TOP_NODE_FLAG,
		ecat.parent_id						PARENT_ID,
		ecat.imm_child_id					IMM_CHILD_ID,
		mv.time_id						TIME_ID,
		mv.period_type_id					PERIOD_TYPE_ID,
		mv.return_flag						RETURN_FLAG,
		mv.internal_flag					INTERNAL_FLAG,
		grouping_id(mv.inv_org_id,
			mv.top_model_org_id,
			ecat.top_node_flag,
			ecat.parent_id,
			ecat.imm_child_id,
			mv.time_id,
			mv.period_type_id,
			mv.return_flag,
			mv.internal_flag) 				GRP_ID,
		sum(mv.fulfilled_amt_g)					FULFILLED_AMT_G,
		count(mv.fulfilled_amt_g)				FULFILLED_AMT_G_CNT,
		sum(mv.fulfilled_amt_g1)				FULFILLED_AMT_G1,
		count(mv.fulfilled_amt_g1)				FULFILLED_AMT_G1_CNT,
		sum(mv.fulfilled_amt_f)					FULFILLED_AMT_F,
		count(mv.fulfilled_amt_f)				FULFILLED_AMT_F_CNT,
		sum(mv.fulfilled_qty) 					FULFILLED_QTY,
		count(mv.fulfilled_qty) 				FULFILLED_QTY_CNT,
		count(*)						CNT
	   FROM	isc_dbi_cfm_005_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,
		mv.top_model_org_id,
		ecat.top_node_flag,
		ecat.parent_id,
		ecat.imm_child_id,
		mv.time_id,
		mv.period_type_id,
		mv.return_flag,
		mv.internal_flag