MATERIALIZED VIEW: APPS.CSP_SUP_DEM_PL_MV

Source

select inventory_item_id,
           min(organization_id) organization_id,
      parts_loop_id,
      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(greatest(onhand_good,0),0)) onhand_good,
      sum(nvl(greatest(onhand_bad,0),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
  from     csp_sup_dem_sub_mv
  where parts_loop_id > 0
  group by
      inventory_item_id,
      parts_loop_id