MATERIALIZED VIEW: APPS.ISC_DBI_CFM_013_MV

Source

(SELECT	/* 12.0: bug#4526784 */
		pdue.inv_org_id							INV_ORG_ID,
		(star.inventory_item_id ||'-'|| star.organization_id) 	ITEM_ID,
		star.vbh_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.days_late_promise						DAYS_LATE_PROMISE,
		pdue.pdue_amt_f							PDUE_AMT_F,
		pdue.pdue_amt_g							PDUE_AMT_G,
		pdue.pdue_amt_g1						PDUE_AMT_G1,
		pdue.late_schedule_flag						LATE_SCHEDULE_FLAG,
		pdue.late_promise_flag						LATE_PROMISE_FLAG,
		pdue.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		pdue.rowid							PDUE_ROWID,
		star.rowid							ITEM_ROWID,
		1								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_PDUE2_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 */
		NULL								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.days_late_promise						DAYS_LATE_PROMISE,
		pdue.pdue_amt_f							PDUE_AMT_F,
		pdue.pdue_amt_g							PDUE_AMT_G,
		pdue.pdue_amt_g1						PDUE_AMT_G1,
		pdue.late_schedule_flag						LATE_SCHEDULE_FLAG,
		pdue.late_promise_flag						LATE_PROMISE_FLAG,
		pdue.time_snapshot_date_id					TIME_SNAPSHOT_DATE_ID,
		pdue.rowid							PDUE_ROWID,
		NULL								ITEM_ROWID,
		2								MARKER
	   FROM	ISC.ISC_BOOK_SUM2_PDUE2_F pdue
	  WHERE	inv_org_id is NULL)