MATERIALIZED VIEW: APPS.ISC_TRN_003_MV

Source

SELECT /* 12.0: bug#4526784 */  i_inv.carrier_id		CARRIER_ID, i_inv.mode_of_transport		MODE_OF_TRANSPORT, i_inv.service_level		SERVICE_LEVEL, grouping_id(service_level, carrier_id) AGG_LEVEL, grouping_id(i_inv.carrier_id, i_inv.mode_of_transport, i_inv.service_level, cal.ent_qtr_id, cal.ent_period_id, cal.week_id, cal.report_date_julian) GRP_ID, decode(grouping_id(cal.ent_qtr_id, cal.ent_period_id, cal.week_id, cal.report_date_julian),        14,cal.report_date_julian,13,cal.week_id, 11,cal.ent_period_id,7,cal.ent_qtr_id) TIME_ID, decode(grouping_id(cal.ent_qtr_id,cal.ent_period_id,cal.week_id,cal.report_date_julian),	14,1,13,16,11,32,7,64) 		PERIOD_TYPE_ID, cal.report_date_julian			DAY_ID,  cal.week_id				WEEK_ID, cal.ent_period_id			ENT_PERIOD_ID, cal.ent_qtr_id				ENT_QTR_ID, sum(i_inv.bill_amt_g)	 		BILL_AMT_G, count(i_inv.bill_amt_g)		BILL_AMT_G_CNT, sum(i_inv.bill_amt_g1)		 	BILL_AMT_G1, count(i_inv.bill_amt_g1)		BILL_AMT_G1_CNT, sum(i_inv.approved_amt_g)		APPROVED_AMT_G, count(i_inv.approved_amt_g)		APPROVED_AMT_G_CNT, sum(i_inv.approved_amt_g1)		APPROVED_AMT_G1, count(i_inv.approved_amt_g1)		APPROVED_AMT_G1_CNT, sum(f_inv.prim_fully_paid_amount)	FULLY_PAID_AMT_G, count(f_inv.prim_fully_paid_amount)	FULLY_PAID_AMT_G_CNT, sum(f_inv.sec_fully_paid_amount)	FULLY_PAID_AMT_G1, count(f_inv.sec_fully_paid_amount)	FULLY_PAID_AMT_G1_CNT, count(*) CNT FROM ISC.ISC_DBI_FTE_INVOICES_F i_inv,      FII.FII_AP_INVOICE_B f_inv,      FII.FII_TIME_DAY cal  WHERE i_inv.bill_number = f_inv.invoice_number    AND i_inv.supplier_id = f_inv.supplier_id    AND i_inv.org_id = f_inv.org_id    AND f_inv.source = 'FTE_INVOICES'    AND cal.report_date = f_inv.fully_paid_date    AND i_inv.bill_status <> 'OBSOLETE'  GROUP BY mode_of_transport, rollup(carrier_id), rollup(service_level),  grouping sets(ent_qtr_id, ent_period_id, week_id, report_date_julian)