MATERIALIZED VIEW: APPS.ISC_DBI_CFM_003_MV

Source

SELECT	/* 12.0: bug#4526784 */
	 	fact.item_inv_org_id 				INV_ORG_ID,
		star.id						ITEM_ID,
		nvl(star.vbh_category_id,-1)			ITEM_CATEGORY_ID,
		nvl(star.master_id,star.id) 			MASTER_ITEM_ID,
		fact.customer_id 				CUSTOMER_ID,
		fact.order_number 				ORDER_NUMBER,
		fact.header_id 					HEADER_ID,
		fact.line_number 				LINE_NUMBER,
		fact.booked_amt_g				RETURNED_AMT_G,
		fact.booked_amt_g1				RETURNED_AMT_G1,
		fact.booked_amt_f1				RETURNED_AMT_F,
		fact.return_reason_id				RETURN_REASON,
		fact.time_fulfilled_date_id 			TIME_FULFILLED_DATE_ID,
		fact.inv_uom_code				UOM,
		fact.booked_qty_inv				RETURNED_QTY,
		fact.rowid					FACT_ROWID,
		star.rowid					ITEM_ROWID
	   FROM	ISC.ISC_BOOK_SUM2_F 		fact,
		ENI.ENI_OLTP_ITEM_STAR 		star
	  WHERE	fact.inventory_item_id = star.inventory_item_id
	    AND	fact.item_inv_org_id = star.organization_id
	    AND	fact.line_category_code = 'RETURN'
	    AND	fact.fulfilled_flag = 'Y'
	    AND	fact.item_type_code <> 'SERVICE'
	    AND	fact.order_source_id <> 10
	    AND	fact.unit_selling_price <> 0
	    AND	fact.order_source_id <> 27
	    AND	fact.ordered_quantity <> 0
	    AND fact.charge_periodicity_code is NULL