MATERIALIZED VIEW: APPS.FII_AP_HHIST_B_MV

Source

SELECT /* 12.0: bug#4526784 */ hold.rowid rowid_1,
        1 marker,
        hold.org_id org_id,
        hold.supplier_id supplier_id,
        hold.invoice_id invoice_id,
        hold.seq_id,
        hold.time_id hold_time_id,
        null release_time_id,
        hold.period_type_id period_type_id,
        hold.action_date hold_date,
        null release_date
 FROM FII.FII_AP_HOLD_HIST_B hold
 where hold.action = 'H'
 union all
 SELECT /* 12.0: bug#4526784 */ hold.rowid rowid_1,
        2 marker,
        hold.org_id org_id,
        hold.supplier_id supplier_id,
        hold.invoice_id invoice_id,
        hold.seq_id,
        null hold_time_id,
        hold.time_id release_time_id,
        hold.period_type_id period_type_id,
        null hold_date,
        hold.action_date release_date
 FROM FII.FII_AP_HOLD_HIST_B hold
 where hold.action = 'R'