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

Source


select
  /* 12.0: bug#4526784 */
  nvl(edh.parent_id,-1) product_category_id
, mv1.repair_organization_id repair_organization_id
, mv1.repair_type_id repair_type_id
, mv1.customer_id customer_id
, 15 - grouping_id( mv1.customer_id
                  , nvl(edh.parent_id,-1)
                  , mv1.repair_organization_id
                  , mv1.repair_type_id
                  ) aggregation_flag
, mv1.time_id
, mv1.period_type_id
, sum( mv1.time_to_repair ) time_to_repair
, count( mv1.time_to_repair ) mv_time_to_repair_count
, sum( mv1.ro_count ) ro_count
, count( mv1.ro_count ) mv_ro_count
, grouping_id( mv1.customer_id
             , nvl(edh.parent_id,-1)
             , mv1.repair_organization_id
             , mv1.repair_type_id
             , mv1.time_id
             , mv1.period_type_id
             ) mv_grp_id
, count(*) mv_count
, sum( mv1.time_to_repair_b1 ) time_to_repair_b1
, count( mv1.time_to_repair_b1 ) mv_time_to_repair_b1_count
, sum( mv1.time_to_repair_b2 ) time_to_repair_b2
, count( mv1.time_to_repair_b2 ) mv_time_to_repair_b2_count
, sum( mv1.time_to_repair_b3 ) time_to_repair_b3
, count( mv1.time_to_repair_b3 ) mv_time_to_repair_b3_count
, sum( mv1.time_to_repair_b4 ) time_to_repair_b4
, count( mv1.time_to_repair_b4 ) mv_time_to_repair_b4_count
, sum( mv1.time_to_repair_b5 ) time_to_repair_b5
, count( mv1.time_to_repair_b5 ) mv_time_to_repair_b5_count
, sum( mv1.time_to_repair_b6 ) time_to_repair_b6
, count( mv1.time_to_repair_b6 ) mv_time_to_repair_b6_count
, sum( mv1.time_to_repair_b7 ) time_to_repair_b7
, count( mv1.time_to_repair_b7 ) mv_time_to_repair_b7_count
, sum( mv1.time_to_repair_b8 ) time_to_repair_b8
, count( mv1.time_to_repair_b8 ) mv_time_to_repair_b8_count
, sum( mv1.time_to_repair_b9 ) time_to_repair_b9
, count( mv1.time_to_repair_b9 ) mv_time_to_repair_b9_count
, sum( mv1.time_to_repair_b10 ) time_to_repair_b10
, count( mv1.time_to_repair_b10 ) mv_time_to_repair_b10_count
from
  isc_dr_mttr_01_mv mv1
, ENI.ENI_DENORM_HIERARCHIES edh
, INV.MTL_DEFAULT_CATEGORY_SETS mdc
where
    mv1.aggregation_flag = 15
and mv1.product_category_id = edh.child_id
and edh.object_id = mdc.category_set_id
and edh.top_node_flag = 'Y'
and edh.dbi_flag = 'Y'
and edh.object_type = 'CATEGORY_SET'
and mdc.functional_area_id = 11
group by
  mv1.time_id
, mv1.period_type_id
, nvl(edh.parent_id,-1)
, rollup( mv1.repair_organization_id
        , mv1.customer_id )
, rollup( mv1.repair_type_id )