MATERIALIZED VIEW: APPS.BIM_I_LP_CHNL_MV

Source

SELECT /* Dummy Comment */
     a.group_id                      group_id
    ,a.resource_id                   resource_id
    ,a.channel_code                  channel_code
    ,a.update_time_id                update_time_id
    ,a.time_id                       time_id
    ,a.update_period_type_id         update_period_type_id
    ,a.period_type_id                period_type_id
    ,a.product_category_id           product_category_id
    ,sum(a.leads)                    leads
    ,sum(a.leads_new)                leads_new
    ,sum(a.leads_open)               leads_open
    ,sum(a.leads_changed)            leads_changed
    ,sum(a.leads_converted)          leads_converted
    ,sum(a.conversion_time)          conversion_time
    ,sum(a.leads_dead)               leads_dead
    ,sum(a.leads_closed)             leads_closed
    ,sum(a.leads_qualified)          leads_qualified
    ,sum(a.leads_new_conv)           leads_new_conv
    ,sum(a.leads_new_changed)        leads_new_changed
    ,sum(a.rank_a)                   leads_a
    ,sum(a.rank_a)                   rank_a
    ,sum(a.rank_b)                   rank_b
    ,sum(a.rank_c)                   rank_c
    ,sum(a.rank_d)                   rank_d
    ,sum(a.rank_z)                   rank_z
    ,sum(a.leads_qualified_a)        leads_qualified_a
    ,sum(a.lead_amount)              lead_amount
    ,sum(a.orders_booked_amt)        orders_booked_amt
    ,sum(a.orders_invoiced_amt)      orders_invoiced_amt
    ,count(a.leads)                  dummy1_fr
    ,count(a.leads_new)              dummy2_fr
    ,count(a.leads_open)             dummy3_fr
    ,count(a.leads_changed)          dummy4_fr
    ,count(a.leads_converted)        dummy5_fr
    ,count(a.conversion_time)        dummy6_fr
    ,count(a.leads_dead)             dummy7_fr
    ,count(a.leads_closed)           dummy8_fr
    ,count(a.leads_qualified)        dummy9_fr
    ,count(a.leads_new_conv)         dummy10_fr
    ,count(a.leads_new_changed)      dummy11_fr
    ,count(a.rank_a)                 dummy12_fr
    ,count(a.rank_a)                 dummy13_fr
    ,count(a.rank_b)                 dummy14_fr
    ,count(a.rank_c)                 dummy15_fr
    ,count(a.rank_d)                 dummy16_fr
    ,count(a.rank_z)                 dummy17_fr
    ,count(a.leads_qualified_a)      dummy18_fr
    ,count(a.lead_amount)            dummy19_fr
    ,count(a.orders_booked_amt)      dummy20_fr
    ,count(a.orders_invoiced_amt)    dummy21_fr
    ,count(*)                        dummy22_fr
FROM
    bim_i_lp_gensg_t_mv a
GROUP BY
    a.group_id
    ,a.resource_id
    ,a.channel_code
    ,a.update_time_id
    ,a.time_id
    ,a.update_period_type_id
    ,a.period_type_id
    ,a.product_category_id