MATERIALIZED VIEW: APPS.POA_IDL_BS_J_MV

Source

SELECT /* 12.0: bug#4526784 */
 1 umarker,
 f.rowid frid,
 aps.rowid vrid,
 apss.rowid vsrid,
 cal.rowid crid,
 f.org_id,
 f.supplier_id,
 f.supplier_site_id,
 f.inv_dist_created_by inv_d_created_by,
 f.company_id,
 f.cost_center_id,
 cal.ent_qtr_id,
 cal.ent_period_id,
 cal.week_id,
 cal.report_date_julian day_id,
 f.amount_b,
 f.prim_amount_g amount_g,
 f.sec_amount_g amount_sg,
 f.po_matched_flag,
 aps.receipt_required_flag
FROM
FII.FII_AP_INV_B f,
AP.AP_SUPPLIERS aps,
AP.AP_SUPPLIER_SITES_ALL apss,
FII.FII_TIME_DAY cal
WHERE f.approved_flag = 'A'
AND   f.invoice_type <> 'EXPENSE REPORT'
AND   f.supplier_id = aps.vendor_id
AND   aps.employee_id is null
AND   f.supplier_site_id = apss.vendor_site_id
AND   apss.purchasing_site_flag = 'Y'
AND   f.account_date = cal.report_date
UNION ALL
SELECT /* 12.0: bug#4526784 */
 2 umarker,
 f.rowid frid,
 aps.rowid vrid,
 apss.rowid vsrid,
 cal.rowid crid,
 f.org_id,
 f.supplier_id,
 f.supplier_site_id,
 f.inv_dist_created_by inv_d_created_by,
 f.company_id,
 f.cost_center_id,
 cal.ent_qtr_id,
 cal.ent_period_id,
 cal.week_id,
 cal.report_date_julian day_id,
 f.amount_b,
 f.prim_amount_g amount_g,
 f.sec_amount_g amount_sg,
 f.po_matched_flag,
 aps.receipt_required_flag
FROM
FII.FII_AP_INV_DIST_F f,
AP.AP_SUPPLIERS aps,
AP.AP_SUPPLIER_SITES_ALL apss,
FII.FII_TIME_DAY cal
WHERE f.approved_flag = 'A'
AND   f.invoice_type <> 'EXPENSE REPORT'
AND   f.supplier_id = aps.vendor_id
AND   aps.employee_id is null
AND   f.supplier_site_id = apss.vendor_site_id
AND   apss.purchasing_site_flag = 'Y'
AND   f.account_date = cal.report_date