MATERIALIZED VIEW: APPS.FII_AP_HHIST_I_MV

Source

SELECT /* 12.0: bug#4526784 */ org_id org_id,
       supplier_id supplier_id,
       invoice_id invoice_id,
       period_type_id period_type_id,
       max(hold_time_id) hold_time_id,
       count(hold_time_id) hold_time_idc,
       max(hold_date) hold_date,
       count(hold_date) hold_datec,
       max(release_time_id) release_time_id,
       count(release_time_id) release_time_idc,
       max(release_date) release_date,
       count(release_date) release_datec,
       seq_id,
       count(*) cnt
FROM fii_ap_hhist_b_mv
GROUP BY org_id, supplier_id, invoice_id, period_type_id, seq_id