MATERIALIZED VIEW: APPS.ISC_DBI_FM_0008_MV

Source

(SELECT	/* 12.0: bug#4526784 */
		pdue.inv_org_id							INV_ORG_ID,
		(star.inventory_item_id ||'-'|| star.organization_id) 	ITEM_ID,
		star.inv_category_id						ITEM_CATEGORY_ID,
		pdue.customer_id						CUSTOMER_ID,
		pdue.time_booked_date_id					TIME_BOOKED_DATE_ID,
		pdue.order_number						ORDER_NUMBER,
		pdue.header_id							HEADER_ID,
		pdue.pdue_line_cnt						PDUE_LINE_CNT,
		pdue.line_number 						LINE_NUMBER,
		pdue.uom							UOM,
		pdue.pdue_qty							PDUE_QTY,
		pdue.days_late							DAYS_LATE,
		pdue.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		pdue.rowid							PDUE_ROWID,
		star.rowid							ITEM_ROWID,
		1								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_PDUE_F 	pdue,
		ENI.ENI_OLTP_ITEM_STAR 		star
	  WHERE	pdue.inventory_item_id = star.inventory_item_id
	    AND	pdue.inv_org_id = star.organization_id)
	UNION ALL
	(SELECT	/* 12.0: bug#4526784 */
		pdue.inv_org_id							INV_ORG_ID,
		NULL								ITEM_ID,
		NULL								ITEM_CATEGORY_ID,
		pdue.customer_id						CUSTOMER_ID,
		pdue.time_booked_date_id					TIME_BOOKED_DATE_ID,
		pdue.order_number						ORDER_NUMBER,
		pdue.header_id							HEADER_ID,
		pdue.pdue_line_cnt	 					PDUE_LINE_CNT,
		pdue.line_number 						LINE_NUMBER,
		pdue.uom							UOM,
		pdue.pdue_qty							PDUE_QTY,
		pdue.days_late							DAYS_LATE,
		pdue.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		pdue.rowid							PDUE_ROWID,
		NULL								ITEM_ROWID,
		2								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_PDUE_F pdue
	  WHERE	pdue.inv_org_id is null)