MATERIALIZED VIEW: APPS.POA_MID_BS_J_MV

Source

SELECT /* 12.0: bug#4526784 */
         1 umarker,
         f.rowid frid,
	 cal.rowid crid,
	 aps.rowid vrid,
	 f.org_id,
	 f.supplier_id,
	 f.supplier_site_id,
	 f.inv_dist_created_by inv_d_created_by,
	 f.source,
	 cal.ent_year_id,
         cal.ent_qtr_id,
         cal.ent_period_id,
         cal.week_id,
         cal.report_date_julian day_id,
	 f.dist_count dist_count
FROM 	 FII.FII_AP_INV_B f,
	 AP.AP_SUPPLIERS aps,
     	 FII.FII_TIME_DAY cal
WHERE    f.approved_flag = 'A'
	 and f.supplier_id = aps.vendor_id
	 and aps.employee_id is null
	 and f.inv_dist_creation_date = cal.report_date
         UNION ALL
         SELECT /* 12.0: bug#4526784 */
         2 umarker,
         f.rowid frid,
	 cal.rowid crid,
	 aps.rowid vrid,
	 f.org_id,
	 f.supplier_id,
	 f.supplier_site_id,
	 f.inv_dist_created_by inv_d_created_by,
	 f.source,
	 cal.ent_year_id,
         cal.ent_qtr_id,
         cal.ent_period_id,
         cal.week_id,
         cal.report_date_julian day_id,
	 f.dist_count dist_count
FROM 	 FII.FII_AP_INV_DIST_F f,
	 AP.AP_SUPPLIERS aps,
     	 FII.FII_TIME_DAY cal
WHERE    f.approved_flag = 'A'
	 and f.supplier_id = aps.vendor_id
	 and aps.employee_id is null
	 and f.inv_dist_creation_date = cal.report_date