MATERIALIZED VIEW: APPS.CSP_SUP_DEM_SUB_MV

Source

select inventory_item_id,
           organization_id,
      parts_loop_id,
      hierarchy_node_id,
      planning_parameters_id,
      level_id,
      subinventory_code,
      sum(nvl(purchase_orders,0)) purchase_orders,
      sum(nvl(sales_orders,0)) sales_orders,
      sum(nvl(requisitions,0)) requisitions,
      sum(nvl(interorg_transf_in,0)) interorg_transf_in,
      sum(nvl(onhand_good,0)) onhand_good,
      sum(nvl(onhand_bad,0)) onhand_bad,
      sum(nvl(intransit_move_orders,0)) intransit_move_orders,
      sum(nvl(interorg_transf_out,0)) interorg_transf_out,
      sum(nvl(move_orders_in,0)) move_orders_in,
      sum(nvl(move_orders_out,0)) move_orders_out,
      sum(nvl(work_orders,0)) work_orders,
      sum(nvl(excess_quantity,0)) excess_quantity
  from     csp_sup_dem_sub_temp
  group by
      inventory_item_id,
      organization_id,
      parts_loop_id,
      hierarchy_node_id,
      planning_parameters_id,
      level_id,
      subinventory_code