eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MATERIALIZED VIEW: APPS.IBW_CMPANLYS_CMPDIM_TIME_MV

Source


SELECT                               /*  Fix for bug # 4751315 */
      1                                         umarker
      , site_id                                 site_id
      , transaction_date                        transaction_date
      , campaign_source_code_id                 campaign_source_code_id
      , bim_source.parent_source_code_id        parent_source_code_id
      , bim_source.prior_id                     prior_id
      , currency_cd_f                           currency_cd_f
      , sum(visits)                             visits             --Visits
      , sum(visit_duration)                     visit_duration     --Denominator for Average Page View Duration
      , sum(page_views)                         page_views         --Numerator for Average Page View Duration
      , sum(web_registrations)                  web_registrations  --Web Registrations
      , sum(carts)                              carts              --Carts
      , sum(orders)                             orders             --Orders
      , sum(daily_uniq_visitors)                daily_uniq_visitors --Daily Unique Visitors
      , sum(a_leads)                            a_leads             --A Leads
      , sum(booked_amt_f)                       booked_amt_f        --Booked Amount
      , sum(booked_amt_g)                       booked_amt_g
      , sum(booked_amt_g1)                      booked_amt_g1
      , time_id                                 time_id
      , period_type_id                          period_type_id
      , ent_year_id                             ent_year_id
      , ent_qtr_id                              ent_qtr_id
      , ent_period_id                           ent_period_id
      , week_id                                 week_id
      , report_date_julian                      report_date_julian
      , count(visits)                           d_visits
      , count(visit_duration)                   d_visit_duration
      , count(page_views)                       d_page_views
      , count(web_registrations)                d_web_registrations
      , count(carts)                            d_carts
      , count(orders)                           d_orders
      , count(daily_uniq_visitors)              d_daily_uniq_visitors
      , count(a_leads)                          d_a_leads
      , 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_time_mv    camp
      , BIM.BIM_I_SOURCE_DENORM   bim_source
    WHERE
      camp.campaign_source_code_id = bim_source.source_code_id
    GROUP BY
        site_id
      , transaction_date
      , campaign_source_code_id
      , time_id
      , period_type_id
      , ent_year_id
      , ent_qtr_id
      , ent_period_id
      , week_id
      , report_date_julian
      , bim_source.parent_source_code_id
      , bim_source.prior_id
      , currency_cd_f