MATERIALIZED VIEW: APPS.MSD_DEM_SCN_ENTRIES_MV

Source

select
    m1.scenario_id,
    m1.sr_instance_id,
    nvl(m1.sr_organization_id, -23453) organization_id,
    nvl(mtps.partner_id, -23453) customer_id,
    nvl(mtps.partner_site_id, -23453) customer_site_id,
    m1.inventory_item_id,
    nvl(mdc.demand_class, '-23453') demand_class,
    m1.start_time start_date,
    m1.quantity consensus_fcst,
    sum(m1.quantity) over(partition by m1.scenario_id, m1.sr_organization_id, m1.inventory_item_id, mtps.partner_id, m1.demand_class order by m1.start_time) consensus_fcst_cum,
    m1.priority,
    m1.unit_price price
from msd_dp_ascp_scn_entries_v m1,
    msc_trading_partners mtp,
    msc_trading_partner_sites mtps,
    msc_demand_classes mdc
where m1.demand_plan_id=5555555
    and m1.sr_instance_id = mtp.sr_instance_id (+)
    and m1.sr_organization_id = mtp.sr_tp_id (+)    
    and m1.sr_instance_id = mtps.sr_instance_id (+)
    and m1.sr_ship_to_loc_id = mtps.sr_tp_site_id (+)
    and m1.demand_class = mdc.meaning (+)
   and mtp.operating_unit_name = mtps.operating_unit_name
   and mtp.partner_type = 3