MATERIALIZED VIEW: APPS.IBW_CMPANALYSIS_SUM_MV

Source

SELECT                      /*  Fix for bug # 4751315 */
       site_id                           site_id
      ,transaction_date                  transaction_date
      ,min(currency_cd_f)                currency_cd_f  --This is for Mergability of 2 rows so that Currency Code USD and Null for instance would give USD.
      ,campaign_source_code_id           campaign_source_code_id
      ,sum(visits)                       visits                --Visits
      ,sum(page_views)                   page_views            --Page Views
      ,sum(visit_duration)               visit_duration        --Visit Duration
      ,sum(web_registrations)  	         web_registrations     --Web Registrations
      ,sum(daily_uniq_visitors)          daily_uniq_visitors   --Daily Unique Visitors
      ,sum(a_leads)                      a_leads               --A Leads
      ,sum(carts)                        carts                 --Carts
      ,sum(orders)                       orders                --Orders
      ,sum(booked_amt_f)                 booked_amt_f          --Booked Amount
      ,sum(booked_amt_g)                 booked_amt_g
      ,sum(booked_amt_g1)                booked_amt_g1
      ,count(visits)                     d_visits
      ,count(page_views)                 d_page_views
      ,count(visit_duration)             d_visit_duration
      ,count(web_registrations)  	       d_web_registrations
      ,count(daily_uniq_visitors)        d_daily_uniq_visitors
      ,count(a_leads)                    d_a_leads
      ,count(carts)                      d_carts
      ,count(orders)                     d_orders
      ,count(booked_amt_f)               d_booked_amt_f
      ,count(booked_amt_g)               d_booked_amt_g
      ,count(booked_amt_g1)              d_booked_amt_g1
      ,count(*)                          d_total_cnt
      FROM
        ibw_cmpanalysis_mv
      GROUP by
        site_id
        ,transaction_date
        ,campaign_source_code_id