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.BIX_EMAIL_DETAILS_MV

Source


(SELECT /* 12.0: bug#4526784 */ bef.time_id time_id,
          bef.period_type_id period_type_id,
          bef.period_start_date period_start_date,
          bef.email_account_id email_account_id,
          bef.email_classification_id email_classification_id,
          bef.agent_id agent_id, bef.party_id party_id,
          bef.outcome_id outcome_id,
          bef.result_id result_id,
          bef.reason_id reason_id,
          GROUPING_ID(bef.time_id,bef.period_type_id,bef.period_start_date, bef.email_account_id,
                      bef.email_classification_id,bef.agent_id,bef.party_id, bef.outcome_id,
                      bef.result_id,bef.reason_id ) g_id,
          (CASE WHEN GROUPING_ID(bef.time_id,bef.period_type_id,bef.period_start_date, bef.email_account_id,
                bef.email_classification_id,bef.agent_id,bef.party_id, bef.outcome_id,bef.result_id,bef.reason_id ) = 15
                THEN 'ACR'
                WHEN GROUPING_ID(bef.time_id,bef.period_type_id,bef.period_start_date, bef.email_account_id,
                bef.email_classification_id,bef.agent_id,bef.party_id,bef.outcome_id,bef.result_id,bef.reason_id ) = 23
                THEN 'ACP'
                WHEN GROUPING_ID(bef.time_id,bef.period_type_id,bef.period_start_date, bef.email_account_id,
                bef.email_classification_id,bef.agent_id,bef.party_id, bef.outcome_id,bef.result_id,bef.reason_id ) = 31
                THEN 'AC'
                WHEN GROUPING_ID(bef.time_id,bef.period_type_id,bef.period_start_date, bef.email_account_id,
                bef.email_classification_id,bef.agent_id,bef.party_id, bef.outcome_id,bef.result_id,bef.reason_id ) = 24
                THEN 'ACORR' ELSE 'UNKNOWN' END ) row_type,
                SUM(bef.emails_offered_in_period) emails_offered_in_period,
                SUM(bef.emails_fetched_in_period) emails_fetched_in_period,
                SUM(bef.emails_replied_in_period) emails_replied_in_period,
                SUM(bef.emails_rpld_by_goal_in_period) emails_rpld_by_goal_in_period,
                SUM(bef.AGENT_EMAILS_RPLD_BY_GOAL) AGENT_EMAILS_RPLD_BY_GOAL,
                SUM(bef.emails_deleted_in_period) emails_deleted_in_period,
                SUM(bef.emails_trnsfrd_out_in_period) emails_trnsfrd_out_in_period,
                SUM(bef.emails_trnsfrd_in_in_period) emails_trnsfrd_in_in_period,
                SUM(bef.emails_rsl_and_trfd_in_period) emails_rsl_and_trfd_in_period,
                SUM(bef.emails_assigned_in_period) emails_assigned_in_period,
                SUM(bef.emails_auto_routed_in_period) emails_auto_routed_in_period,
                SUM(bef.emails_auto_uptd_sr_in_period) emails_auto_uptd_sr_in_period,
                SUM(bef.sr_created_in_period) sr_created_in_period,
                SUM(bef.accumulated_open_emails) accumulated_open_emails,
                SUM(bef.accumulated_open_age) accumulated_open_age,
                SUM(bef.accumulated_emails_in_queue) accumulated_emails_in_queue,
                SUM(bef.accumulated_queue_time) accumulated_queue_time,
                SUM(bef.email_resp_time_in_period) email_resp_time_in_period,
                SUM(bef.agent_resp_time_in_period) agent_resp_time_in_period,
                SUM(bef.accumulated_emails_one_day) accumulated_emails_one_day,
                SUM(bef.accumulated_emails_three_days) accumulated_emails_three_days,
                SUM(bef.accumulated_emails_week) accumulated_emails_week,
                SUM(bef.accumulated_emails_week_plus) accumulated_emails_week_plus,
                SUM(bef.one_rsln_in_period) one_rsln_in_period,
                SUM(bef.two_rsln_in_period) two_rsln_in_period,
                SUM(bef.three_rsln_in_period) three_rsln_in_period,
                SUM(bef.four_rsln_in_period) four_rsln_in_period,
                SUM(bef.interaction_threads_in_period) interaction_threads_in_period,
                SUM(bef.EMAILS_ORR_COUNT_IN_PERIOD) EMAILS_ORR_COUNT_IN_PERIOD,
                SUM(bef.EMAILS_AUTO_REPLIED_IN_PERIOD) EMAILS_AUTO_REPLIED_IN_PERIOD,
                SUM(bef.EMAILS_AUTO_DELETED_IN_PERIOD) EMAILS_AUTO_DELETED_IN_PERIOD,
                SUM(bef.EMAILS_AUTO_RESOLVED_IN_PERIOD) EMAILS_AUTO_RESOLVED_IN_PERIOD,
                SUM(bef.EMAILS_COMPOSED_IN_PERIOD) EMAILS_COMPOSED_IN_PERIOD,
                SUM(bef.LEADS_CREATED_IN_PERIOD) LEADS_CREATED_IN_PERIOD,
                SUM(bef.EMAILS_REROUTED_IN_PERIOD) EMAILS_REROUTED_IN_PERIOD,
                COUNT(bef.emails_offered_in_period) emails_offered_c,
                COUNT(bef.emails_fetched_in_period) emails_fetched_c,
                COUNT(bef.emails_replied_in_period) emails_replied_c,
                COUNT(bef.emails_rpld_by_goal_in_period) emails_rpld_by_goal_c,
                COUNT(bef.AGENT_EMAILS_RPLD_BY_GOAL) AGENT_EMAILS_RPLD_BY_GOAL_C,
                COUNT(bef.emails_deleted_in_period) emails_deleted_c,
                COUNT(bef.emails_trnsfrd_out_in_period) emails_trnsfrd_out_c,
                COUNT(bef.emails_trnsfrd_in_in_period) emails_trnsfrd_in_c,
                COUNT(bef.emails_rsl_and_trfd_in_period) emails_rsl_and_trfd_c,
                COUNT(bef.emails_assigned_in_period) emails_assigned_c,
                COUNT(bef.emails_auto_routed_in_period) emails_auto_routed_c,
                COUNT(bef.emails_auto_uptd_sr_in_period) emails_auto_uptd_sr_c,
                COUNT(bef.sr_created_in_period) sr_created_c,
                COUNT(bef.accumulated_open_emails) accu_open_emails_c,
                COUNT(bef.accumulated_open_age) accu_open_age_c,
                COUNT(bef.accumulated_emails_in_queue) accu_emails_in_queue_c,
                COUNT(bef.accumulated_queue_time) accu_queue_time_c,
                COUNT(bef.email_resp_time_in_period) email_resp_time_c,
                COUNT(bef.agent_resp_time_in_period) agent_resp_time_c,
                COUNT(bef.accumulated_emails_one_day) accu_emails_one_day_c,
                COUNT(bef.accumulated_emails_three_days) accu_emails_three_days_c,
                COUNT(bef.accumulated_emails_week) accu_emails_week_c,
                COUNT(bef.accumulated_emails_week_plus) accu_emails_week_plus_c,
                COUNT(bef.one_rsln_in_period) one_rsln_c,
                COUNT(bef.two_rsln_in_period) two_rsln_c,
                COUNT(bef.three_rsln_in_period) three_rsln_c,
                COUNT(bef.four_rsln_in_period) four_rsln_c,
                COUNT(bef.interaction_threads_in_period) interaction_thread_c,
                COUNT(bef.EMAILS_ORR_COUNT_IN_PERIOD) EMAILS_ORR_COUNT_C,
                COUNT(bef.EMAILS_AUTO_REPLIED_IN_PERIOD) EMAILS_AUTO_REPLIED_c,
                COUNT(bef.EMAILS_AUTO_DELETED_IN_PERIOD) EMAILS_AUTO_DELETED_c,
                COUNT(bef.EMAILS_AUTO_RESOLVED_IN_PERIOD) EMAILS_AUTO_RESOLV_c,
                COUNT(bef.EMAILS_COMPOSED_IN_PERIOD) EMAILS_COMPOSED_c,
                COUNT(bef.LEADS_CREATED_IN_PERIOD) LEADS_CREATED_c,
                COUNT(bef.EMAILS_REROUTED_IN_PERIOD) EMAILS_REROUTED_c,
                COUNT(*) tot_cnt
   FROM BIX.BIX_EMAIL_DETAILS_F bef
   GROUP BY GROUPING SETS((bef.time_id, bef.period_type_id, bef.period_start_date,bef.email_account_id,
                           bef.email_classification_id, bef.agent_id ),
                          (bef.time_id, bef.period_type_id, bef.period_start_date, bef.email_account_id,
                           bef.email_classification_id, bef.party_id ),
                          (bef.time_id, bef.period_type_id, bef.period_start_date, bef.email_account_id,
                          bef.email_classification_id ),
                          (bef.time_id, bef.period_type_id, bef.period_start_date, bef.email_account_id,
                          bef.email_classification_id, bef.outcome_id, bef.result_id, bef.reason_id)
                          )
						  )