APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_SYSTEM_ITEMS

Line 839: msc_system_items msi,

835: -- msc_planners mp,
836: msc_companies customer,
837: msc_company_sites customer_site,
838: msc_companies oem,
839: msc_system_items msi,
840: msc_sup_dem_entries sup_dem,
841: msc_sup_dem_entries sd,
842: msc_trading_partners mtp,
843: msc_trading_partner_maps map1,

Line 959: msc_system_items msi,

955: -- msc_planners mp,
956: msc_companies customer,
957: msc_company_sites customer_site,
958: msc_companies oem,
959: msc_system_items msi,
960: msc_trading_partners mtp,
961: msc_trading_partner_maps map1,
962: msc_trading_partner_maps map2,
963: msc_company_relationships mcr

Line 1816: , msc_system_items msi

1812: BEGIN
1813: SELECT mp.user_name
1814: INTO l_supplier_contact
1815: FROM msc_planners mp
1816: , msc_system_items msi
1817: WHERE msi.plan_id = -1 -- p_plan_id
1818: AND msi.organization_id = p_customer_model_org_id
1819: AND msi.inventory_item_id = p_inventory_item_id
1820: AND msi.sr_instance_id = p_sr_instance_id

Line 2030: msc_system_items msi,

2026: , nvl(msi.vmi_maximum_days, -1)
2027: , nvl(mvt.average_daily_demand, 0)
2028: , mtp.partner_name
2029: FROM
2030: msc_system_items msi,
2031: msc_sup_dem_entries sd,
2032: msc_trading_partners mtp,
2033: msc_trading_partner_maps map1,
2034: msc_trading_partner_maps map2,

Line 2233: msc_system_items msi,

2229: , mtp.partner_name
2230: , sd.publisher_order_type_desc
2231:
2232: FROM
2233: msc_system_items msi,
2234: msc_sup_dem_entries sd,
2235: msc_trading_partners mtp,
2236: msc_trading_partner_maps map1,
2237: msc_trading_partner_maps map2,

Line 2299: msc_system_items msi,

2295: , sd.END_ORDER_LINE_NUMBER
2296: , mtp.partner_name
2297: , sd.publisher_order_type_desc
2298: FROM
2299: msc_system_items msi,
2300: msc_sup_dem_entries sd,
2301: msc_trading_partners mtp,
2302: msc_trading_partner_maps map1,
2303: msc_trading_partner_maps map2,

Line 2880: FROM msc_system_items msi

2876: , mtp.modeled_customer_site_id
2877: , msi.forecast_horizon
2878: , msi.vmi_forecast_type
2879: , mvt.average_daily_demand
2880: FROM msc_system_items msi
2881: , msc_trading_partners mtp
2882: , msc_vmi_temp mvt
2883: WHERE msi.inventory_planning_code = 7 -- (?)
2884: AND msi.organization_id = mtp.sr_tp_id

Line 2911: UPDATE msc_system_items

2907: || '-' || forecast_item.sr_instance_id
2908: || '-' || forecast_item.modeled_customer_id
2909: || '-' || forecast_item.modeled_customer_site_id
2910: );
2911: UPDATE msc_system_items
2912: SET vmi_refresh_flag = 0
2913: WHERE plan_id = forecast_item.plan_id
2914: AND inventory_item_id = forecast_item.inventory_item_id
2915: AND organization_id = forecast_item.organization_id