MATERIALIZED VIEW: APPS.ISC_DBI_FM_0003_MV

Source

SELECT	/* 12.0: bug#4526784 */
	 	fact.item_inv_org_id 							INV_ORG_ID,
		(star.inventory_item_id ||'-'|| star.organization_id) 		ITEM_ID,
		nvl(star.inv_category_id,-1)						ITEM_CATEGORY_ID,
		fact.ship_to_party_id 							CUSTOMER_ID,
		fact.order_number 							ORDER_NUMBER,
		fact.header_id 								HEADER_ID,
		fact.time_shipped_date_id 						TIME_SHIPPED_DATE_ID,
		fact.count_ship_line							LATE_LINE_CNT,
		(fact.time_shipped_date_id - fact.time_promise_date_id)			DAYS_LATE_PROMISE,
		(fact.time_shipped_date_id - fact.time_schedule_date_id)		DAYS_LATE,
		(fact.shipped_date - fact.booked_date)					BOOK_TO_SHIP_DAYS,
		(CASE WHEN fact.time_shipped_date_id > fact.time_schedule_date_id
			THEN 1 ELSE 0 END)						LATE_SCHEDULE_FLAG,
		(CASE WHEN fact.time_shipped_date_id > fact.time_promise_date_id
			THEN 1 ELSE 0 END)						LATE_PROMISE_FLAG,
		fact.inv_uom_code							UOM,
		fact.shipped_qty_inv							SHIPPED_LATE_QTY,
		fact.line_number 							LINE_NUMBER,
		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.time_shipped_date_id > fact.time_schedule_date_id)
		  OR (fact.time_shipped_date_id > fact.time_promise_date_id))
	    AND	fact.line_category_code <> 'RETURN'
	    AND	fact.item_type_code <> 'SERVICE'
	    AND	fact.ordered_quantity <> 0
	    AND	fact.order_source_id <> 27
	    AND	count_ship_line = 1
	    AND fact.charge_periodicity_code is NULL