MATERIALIZED VIEW: APPS.CSP_SUP_DEM_RH_MV

Source

select crsdt.inventory_item_id,
           min(crsdt.organization_id) organization_id,
      crsdt.hierarchy_node_id,
         crh.node_name,
         crh.parent_node_id,
      sum(nvl(crsdt.purchase_orders,0)) purchase_orders,
      sum(nvl(crsdt.sales_orders,0)) sales_orders,
      sum(nvl(crsdt.requisitions,0)) requisitions,
      sum(nvl(crsdt.interorg_transf_in,0)) interorg_transf_in,
      sum(nvl(greatest(crsdt.onhand_good,0),0)) onhand_good,
      sum(nvl(greatest(crsdt.onhand_bad,0),0)) onhand_bad,
      sum(nvl(crsdt.intransit_move_orders,0)) intransit_move_orders,
      sum(nvl(crsdt.interorg_transf_out,0)) interorg_transf_out,
      sum(nvl(crsdt.move_orders_in,0)) move_orders_in,
      sum(nvl(crsdt.move_orders_out,0)) move_orders_out,
      sum(nvl(crsdt.work_orders,0)) work_orders
  from     csp_sup_dem_rh_temp crsdt,
         csp_rep_hierarchies crh
  where  crh.hierarchy_node_id = crsdt.hierarchy_node_id
  group by
      crsdt.inventory_item_id,
      crsdt.hierarchy_node_id,
      crh.node_name,
         crh.parent_node_id