MATERIALIZED VIEW: APPS.FII_AP_IVATY_XB_MV

Source

select /* 12.0: bug#4526784 */ org_id,
       supplier_id,
       time_id,
       period_type_id,
       grouping_id(org_id, supplier_id, time_id, period_type_id) gid,
       sum(invoice_amt_b) invoice_amt_entered_b,
       count(invoice_amt_b) invoice_amt_entered_bc,
       sum(prim_invoice_amt) invoice_amt_entered_prim_g,
       count(prim_invoice_amt) invoice_amt_entered_prim_gc,
       sum(sec_invoice_amt) invoice_amt_entered_sec_g,
       count(sec_invoice_amt) invoice_amt_entered_sec_gc,
       sum(invoice_entered_count) invoice_count_entered,
       count(invoice_entered_count) invoice_count_enteredc,
       sum(e_invoice_amt_b) e_invoice_amt_b,
       count(e_invoice_amt_b) e_invoice_amt_bc,
       sum(prim_e_invoice_amt) e_invoice_amt_prim_g,
       count(prim_e_invoice_amt) e_invoice_amt_prim_gc,
       sum(sec_e_invoice_amt) e_invoice_amt_sec_g,
       count(sec_e_invoice_amt) e_invoice_amt_sec_gc,
       sum(e_invoice_count) e_invoice_count,
       count(e_invoice_count) e_invoice_countc,
       sum(distribution_count) distribution_count,
       count(distribution_count) distribution_countc,
       sum(e_distribution_count) e_distribution_count,
       count(e_distribution_count) e_distribution_countc,
       sum(xml_count) xml_count,
       count(xml_count) xml_countc,
       sum(edi_count) edi_count,
       count(edi_count) edi_countc,
       sum(ers_count) ers_count,
       count(ers_count) ers_countc,
       sum(isp_count) isp_count,
       count(isp_count) isp_countc,
       sum(ASBN_count) ASBN_count,
       count(ASBN_count) ASBN_countc,
       sum(other_integrated_count) other_integrated_count,
       count(other_integrated_count) other_integrated_countc,
       sum(standard_count) standard_count,
       count(standard_count) standard_countc,
       sum(withholding_count) withholding_count,
       count(withholding_count) withholding_countc,
       sum(prepayment_count) prepayment_count,
       count(prepayment_count) prepayment_countc,
       sum(credit_count) credit_count,
       count(credit_count) credit_countc,
       sum(debit_count) debit_count,
       count(debit_count) debit_countc,
       sum(mixed_count) mixed_count,
       count(mixed_count) mixed_countc,
       sum(interest_count) interest_count,
       count(interest_count) interest_countc,
       count(*) cnt
 from FII_AP_IVATY_B_MV
 group by grouping sets(
                       (org_id, supplier_id, time_id, period_type_id),
                       (org_id, time_id, period_type_id)
                       )