MATERIALIZED VIEW: APPS.ISC_DBI_SCR_003_MV

Source

SELECT /* 12.0: bug#4526784 */   fact.time_booked_date_id				TIME_BOOKED_DATE_ID, fact.org_ou_id						ORG_OU_ID, fact.customer_id					CUSTOMER_ID, class.class_code					CLASS_CODE, fact.order_number					ORDER_NUMBER, fact.header_id						HEADER_ID, fact.line_number 					LINE_NUMBER, sc.sales_grp_id					SALES_GRP_ID, sc.resource_id						RESOURCE_ID, nvl(item.vbh_category_id,-1)				ITEM_CATEGORY_ID, nvl(item.master_id, item.id) 				ITEM_ID, grouping_id( fact.time_booked_date_id,fact.customer_id,class.class_code,fact.order_number,fact.line_number,sc.resource_id, sc.sales_grp_id, 	     nvl(item.vbh_category_id,-1),nvl(item.master_id, item.id),fact.header_id) GRP_ID, sum(fact.booked_amt_g * sc.sales_credit_percent / 100)	RETURNED_AMT_G, count(fact.booked_amt_g * sc.sales_credit_percent / 100)	RETURNED_AMT_G_CNT, sum(fact.booked_amt_g1 * sc.sales_credit_percent / 100)	RETURNED_AMT_G1, count(fact.booked_amt_g1 * sc.sales_credit_percent / 100)	RETURNED_AMT_G1_CNT, count(*)	CNT FROM ISC.ISC_BOOK_SUM2_F	fact,    ISC.ISC_SALES_CREDITS_F	sc,    ENI.ENI_OLTP_ITEM_STAR	item,    FII.FII_PARTY_MKT_CLASS	class WHERE fact.line_category_code = 'RETURN'   AND fact.line_id = sc.line_id   AND fact.inventory_item_id = item.inventory_item_id   AND fact.item_inv_org_id = item.organization_id   AND fact.customer_id = class.party_id   AND fact.order_source_id <> 27   AND fact.order_source_id <> 10   AND fact.item_type_code <> 'SERVICE'   AND fact.ordered_quantity <> 0   AND fact.charge_periodicity_code is NULL GROUP BY fact.time_booked_date_id,fact.org_ou_id,fact.customer_id,class.class_code,fact.header_id,fact.order_number,fact.line_number,sc.resource_id,   sc.sales_grp_id,nvl(item.vbh_category_id,-1),nvl(item.master_id, item.id)