eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

MATERIALIZED VIEW: APPS.ISC_SAM_003_MV

Source


select 	0								UMARKER,  	'SALES REP'							GRP_MARKER,  	fact.agreement_type_id						AGREEMENT_TYPE_ID,  	fact.customer_id						CUSTOMER_ID,  	cc.class_code							CLASS_CODE,  	fact.salesrep_id						RESOURCE_ID,  	fact.sales_grp_id						SALES_GRP_ID,  	fact.sales_grp_id						PARENT_GRP_ID,  	decode(grouping_id( fact.agreement_type_id,   		     cc.class_code,   		     fact.customer_id),0,0,4,1,1,2,5,3,3,4,7,5)		AGG_LEVEL,  	grouping_id( fact.agreement_type_id,  		     cc.class_code,  		     fact.customer_id,  		     fact.salesrep_id,  		     fact.sales_grp_id,  		     cal.ent_year_id)					GRP_ID,  	cal.ent_year_id							ENT_YEAR_ID,  	sum(fact.commit_prorated_amt_g)					COMMIT_AMT_G,   	sum(fact.commit_prorated_amt_g1)					COMMIT_AMT_G1,   	count(fact.commit_prorated_amt_g)				C_COMMIT_AMT_G,   	count(fact.commit_prorated_amt_g1)				C_COMMIT_AMT_G1,   	count(*)							C_TOTAL  from	ISC.ISC_DBI_BSA_ORDER_LINES_F		fact,  	FII.FII_PARTY_MKT_CLASS			cc,  	oki_time_ent_year_mv	cal  where	fact.time_activation_date_id < cal.start_date  and	nvl(fact.time_effective_end_date_id, cal.start_date+1) >= cal.start_date  and	fact.customer_id = cc.party_id  and	fact.transaction_phase_code = 'F'  and	fact.commit_prorated_amt_g is not null  and	fact.blanket_line_id is not null  and	nvl(fact.time_termination_date_id, fact.time_activation_date_id + 1) >= fact.time_activation_date_id  group by rollup(fact.agreement_type_id), fact.salesrep_id, fact.sales_grp_id,          rollup(cc.class_code, fact.customer_id),  	cal.ent_year_id  union all  select 	1								UMARKER,  	grp.umarker							GRP_MARKER,  	fact.agreement_type_id						AGREEMENT_TYPE_ID,  	fact.customer_id						CUSTOMER_ID,  	cc.class_code							CLASS_CODE,  	null								RESOURCE_ID,  	grp.prg_id							SALES_GRP_ID,  	grp.parent_prg_id						PARENT_GRP_ID,  	decode(grouping_id( fact.agreement_type_id,   		     cc.class_code,   		     fact.customer_id),0,0,4,1,1,2,5,3,3,4,7,5)		AGG_LEVEL,  	grouping_id( fact.agreement_type_id,  		     cc.class_code,  		     fact.customer_id,  		     grp.umarker,  		     grp.prg_id,  		     grp.parent_prg_id,  		     cal.ent_year_id)					GRP_ID,  	cal.ent_year_id							ENT_YEAR_ID,  	sum(fact.commit_prorated_amt_g)					COMMIT_AMT_G,   	sum(fact.commit_prorated_amt_g1)					COMMIT_AMT_G1,   	count(fact.commit_prorated_amt_g)				C_COMMIT_AMT_G,   	count(fact.commit_prorated_amt_g1)				C_COMMIT_AMT_G1,   	count(*)							C_TOTAL  from	ISC.ISC_DBI_BSA_ORDER_LINES_F		fact,  	FII.FII_PARTY_MKT_CLASS			cc,  	oki_rs_group_mv				grp,  	oki_time_ent_year_mv	cal  where	fact.time_activation_date_id < cal.start_date  and	nvl(fact.time_effective_end_date_id, cal.start_date+1) >= cal.start_date  and	fact.customer_id = cc.party_id  and	fact.sales_grp_id = grp.rg_id  and	fact.transaction_phase_code = 'F'  and	fact.commit_prorated_amt_g is not null  and	fact.blanket_line_id is not null  and	nvl(fact.time_termination_date_id, fact.time_activation_date_id + 1) >= fact.time_activation_date_id  group by rollup(fact.agreement_type_id), grp.umarker, grp.prg_id, grp.parent_prg_id,          rollup(cc.class_code, fact.customer_id),  	cal.ent_year_id