MATERIALIZED VIEW: APPS.ISC_DBI_FM_0007_MV

Source

(SELECT	/* 12.0: bug#4526784 */
		back.inv_org_id							INV_ORG_ID,
		(star.inventory_item_id ||'-'|| star.organization_id) 	ITEM_ID,
		star.inv_category_id						ITEM_CATEGORY_ID,
		back.customer_id						CUSTOMER_ID,
		back.order_number						ORDER_NUMBER,
		back.header_id							HEADER_ID,
		back.time_request_date_id					TIME_REQUEST_DATE_ID,
		back.time_schedule_date_id					TIME_SCHEDULE_DATE_ID,
		back.line_number 						LINE_NUMBER,
		back.days_late_request						DAYS_LATE_REQUEST,
		back.days_late_schedule						DAYS_LATE_SCHEDULE,
		back.backorder_qty						BACKORDER_QTY,
		back.uom							UOM,
		back.backorder_line_cnt						BACKORDER_LINE_CNT,
		back.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		back.rowid							BACK_ROWID,
		star.rowid							ITEM_ROWID,
		1								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_BKORD_F 	back,
		ENI.ENI_OLTP_ITEM_STAR 		star
	  WHERE	back.inventory_item_id = star.inventory_item_id
	    AND	back.inv_org_id = star.organization_id)
	UNION ALL
	(SELECT	/* 12.0: bug#4526784 */
		back.inv_org_id							INV_ORG_ID,
		NULL								ITEM_ID,
		NULL								ITEM_CATEGORY_ID,
		back.customer_id						CUSTOMER_ID,
		back.order_number						ORDER_NUMBER,
		back.header_id							HEADER_ID,
		back.time_request_date_id					TIME_REQUEST_DATE_ID,
		back.time_schedule_date_id					TIME_SCHEDULE_DATE_ID,
		back.line_number						LINE_NUMBER,
		back.days_late_request						DAYS_LATE_REQUEST,
		back.days_late_schedule						DAYS_LATE_SCHEDULE,
		back.backorder_qty						BACKORDER_QTY,
		back.uom							UOM,
		back.backorder_line_cnt						BACKORDER_LINE_CNT,
		back.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		back.rowid							BACK_ROWID,
		NULL								ITEM_ROWID,
		2								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_BKORD_F back
	  WHERE	inv_org_id is NULL)