MATERIALIZED VIEW: APPS.ISC_DBI_SCR_002_MV

Source

SELECT /* 12.0: bug#4526784 */	 f.grp_marker					GRP_MARKER, f.parent_grp_id				PARENT_GRP_ID, f.sales_grp_id					SALES_GRP_ID, f.resource_id					RESOURCE_ID, cat.top_node_flag				CAT_TOP_NODE_FLAG, cat.parent_id					ITEM_CATEGORY_ID, f.time_id					TIME_ID, f.period_type_id				PERIOD_TYPE_ID, grouping_id( f.grp_marker,f.parent_grp_id,f.sales_grp_id,f.resource_id, 	     cat.top_node_flag,cat.parent_id,f.period_type_id,f.time_id)	GRP_ID, sum(f.booked_amt_g)			BOOKED_AMT_G, count(f.booked_amt_g)			BOOKED_AMT_G_CNT, sum(f.booked_amt_g1)			BOOKED_AMT_G1, count(f.booked_amt_g1)			BOOKED_AMT_G1_CNT, sum(f.returned_amt_g)			RETURNED_AMT_G, count(f.returned_amt_g)		RETURNED_AMT_G_CNT, sum(f.returned_amt_g1)			RETURNED_AMT_G1, count(f.returned_amt_g1)		RETURNED_AMT_G1_CNT, sum(f.net_booked_amt_g)		NET_BOOKED_AMT_G, count(f.net_booked_amt_g)		NET_BOOKED_AMT_G_CNT, sum(f.net_booked_amt_g1)		NET_BOOKED_AMT_G1, count(f.net_booked_amt_g1)		NET_BOOKED_AMT_G1_CNT, sum(f.backlog_amt_g)			BACKLOG_AMT_G, count(f.backlog_amt_g)			BACKLOG_AMT_G_CNT, sum(f.backlog_amt_g1)			BACKLOG_AMT_G1,  count(f.backlog_amt_g1)		BACKLOG_AMT_G1_CNT, sum(f.recognized_amt_g)		RECOGNIZED_AMT_G, count(f.recognized_amt_g)		RECOGNIZED_AMT_G_CNT, sum(f.recognized_amt_g1)		RECOGNIZED_AMT_G1, count(f.recognized_amt_g1)		RECOGNIZED_AMT_G1_CNT, sum(f.deferred_amt_g)			DEFERRED_AMT_G, count(f.deferred_amt_g)		DEFERRED_AMT_G_CNT, sum(f.deferred_amt_g1)			DEFERRED_AMT_G1, count(f.deferred_amt_g1)		DEFERRED_AMT_G1_CNT, sum(f.booked_rev_yr_g)   		BOOKED_REV_YR_G, sum(f.booked_rev_qr_g)  		BOOKED_REV_QR_G, sum(f.booked_rev_pe_g)     		BOOKED_REV_PE_G, sum(f.booked_rev_wk_g)  		BOOKED_REV_WK_G, sum(f.booked_rev_yr_g1)    		BOOKED_REV_YR_G1, sum(f.booked_rev_qr_g1)  		BOOKED_REV_QR_G1, sum(f.booked_rev_pe_g1)  		BOOKED_REV_PE_G1, sum(f.booked_rev_wk_g1)  		BOOKED_REV_WK_G1, count(f.booked_rev_yr_g)	  	BOOKED_REV_YR_G_CT, count(f.booked_rev_qr_g) 	 	BOOKED_REV_QR_G_CT, count(f.booked_rev_pe_g) 	 	BOOKED_REV_PE_G_CT, count(f.booked_rev_wk_g)	   	BOOKED_REV_WK_G_CT, count(f.booked_rev_yr_g1)  		BOOKED_REV_YR_G1_CT, count(f.booked_rev_qr_g1)  		BOOKED_REV_QR_G1_CT, count(f.booked_rev_pe_g1)  		BOOKED_REV_PE_G1_CT, count(f.booked_rev_wk_g1)  		BOOKED_REV_WK_G1_CT, count(*)	CNT FROM isc_dbi_scr_001_mv	f,   ENI.ENI_DENORM_HIERARCHIES		cat,   INV.MTL_DEFAULT_CATEGORY_SETS	mtl WHERE f.customer_flag = 3   AND f.item_cat_flag <> 1   AND f.item_category_id = cat.child_id   AND cat.object_type = 'CATEGORY_SET'   AND cat.dbi_flag = 'Y'   AND cat.object_id = mtl.category_set_id   AND mtl.functional_area_id = 11 GROUP BY f.parent_grp_id, f.sales_grp_id,f.grp_marker,f.resource_id, cat.top_node_flag,cat.parent_id,f.time_id,f.period_type_id