MATERIALIZED VIEW: APPS.ISC_DBI_CPM_005_MV

Source

select /* 12.0: bug#4526784 */
		3										customer_flag,
		1									 	item_cat_flag,
		ecat.top_node_flag								top_node_flag,
		mv.time_id		 							time_id,
		ecat.parent_id			     						parent_id,
		ecat.imm_child_id								imm_child_id,
		sum(mv.booked_amt_g)								booked_amt_g,
		count(mv.booked_amt_g)								c_booked_amt_g,
		sum(mv.booked_amt_g1)								booked_amt_g1,
		count(mv.booked_amt_g1)								c_booked_amt_g1,
		sum(mv.returned_amt_g)								returned_amt_g,
		count(mv.returned_amt_g)							c_returned_amt_g,
		sum(mv.returned_amt_g1)								returned_amt_g1,
		count(mv.returned_amt_g1)							c_returned_amt_g1,
		count(*)					 				c_total
	   FROM	isc_dbi_cpm_002_mv		mv,
		ENI.ENI_DENORM_HIERARCHIES	ecat,
		INV.MTL_DEFAULT_CATEGORY_SETS	mdcs
	  WHERE mv.customer_flag = 3
	    AND mv.item_cat_flag = 1
	    AND	mv.item_category_id = ecat.child_id
	    AND	ecat.dbi_flag = 'Y'
	    AND	ecat.object_type = 'CATEGORY_SET'
	    AND	ecat.object_id = mdcs.category_set_id
	    AND	mdcs.functional_area_id = 11
	GROUP BY
		mv.time_id,
		ecat.top_node_flag,
		ecat.parent_id,
		ecat.imm_child_id