MATERIALIZED VIEW: APPS.ISC_DBI_PM_0003_MV

Source

SELECT	/* 12.0: bug#4526784 */
	 	mv.snapshot_id					SNAPSHOT_ID,
		mv.organization_id				ORGANIZATION_ID,
		ecat.parent_id 					PARENT_ID,
		grouping_id(mv.organization_id,
			ecat.parent_id,
			mv.start_date,
			mv.period_type_id) 			GRP_ID,
		mv.start_date					START_DATE,
		mv.period_type_id				PERIOD_TYPE_ID,
		sum(mv.mds_cost)				MDS_COST,
		count(mv.mds_cost) 				MDS_COST_CNT,
		sum(mv.mds_cost_g)				MDS_COST_G,
		count(mv.mds_cost_g) 				MDS_COST_G_CNT,
		sum(mv.mds_cost_g1)				MDS_COST_G1,
		count(mv.mds_cost_g1) 				MDS_COST_G1_CNT,
		sum(mv.mds_price)				MDS_PRICE,
		count(mv.mds_price) 				MDS_PRICE_CNT,
		sum(mv.mds_price_g)				MDS_PRICE_G,
		count(mv.mds_price_g) 				MDS_PRICE_G_CNT,
		sum(mv.mds_price_g1)				MDS_PRICE_G1,
		count(mv.mds_price_g1)				MDS_PRICE_G1_CNT,
		count(*) 					CNT
	   FROM	isc_dbi_pm_0001_mv 		mv,
		ENI.ENI_DENORM_HIERARCHIES 	ecat,
		INV.MTL_DEFAULT_CATEGORY_SETS 	mtl
	  WHERE	mv.vbh_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	ecat.top_node_flag = 'Y'
	    AND	mv.item_cat_flag = 2
	    AND	mv.union1_flag <> 0
	  GROUP BY mv.snapshot_id,
		mv.organization_id,
		ecat.parent_id,
		mv.start_date,
		mv.period_type_id