MATERIALIZED VIEW: APPS.CSP_SUP_DEM_PN_MV

Source

select csdsm.inventory_item_id,
         min(csdsm.organization_id) organization_id,
         cpp.planning_parameters_id,
         cpp.level_id,
         cpp.node_name,
         cpp.parent_node_id,
         sum(nvl(csdsm.purchase_orders,0)) purchase_orders,
         sum(nvl(csdsm.sales_orders,0)) sales_orders,
         sum(nvl(csdsm.requisitions,0)) requisitions,
         sum(nvl(csdsm.interorg_transf_in,0)) interorg_transf_in,
         sum(nvl(greatest(csdsm.onhand_good,0),0)) onhand_good,
         sum(nvl(greatest(csdsm.onhand_bad,0),0)) onhand_bad,
         sum(nvl(csdsm.intransit_move_orders,0)) intransit_move_orders,
         sum(nvl(csdsm.interorg_transf_out,0)) interorg_transf_out,
         sum(nvl(csdsm.move_orders_in,0)) move_orders_in,
         sum(nvl(csdsm.move_orders_out,0)) move_orders_out,
         sum(nvl(csdsm.work_orders,0)) work_orders,
         sum(nvl(csdsm.excess_quantity,0)) excess_quantity
  from   csp_sup_dem_sub_mv csdsm,
         csp_planning_parameters cpp
  where  csdsm.level_id like cpp.level_id||'%'
  group by
         csdsm.inventory_item_id,
         cpp.planning_parameters_id,
         cpp.level_id,
         cpp.node_name,
         cpp.parent_node_id