APPS.MSC_X_CVMI_PLANNING dependencies on MSC_SYSTEM_ITEMS

Line 40: FROM msc_system_items msi

36: , NVL(msi.forecast_horizon, 0) forecast_horizon
37: , msi.vmi_forecast_type
38: , msi.uom_code
39: , mvt.average_daily_demand
40: FROM msc_system_items msi
41: , msc_trading_partners mtp
42: , msc_vmi_temp mvt
43: WHERE msi.inventory_planning_code = 7
44: AND msi.organization_id = mtp.sr_tp_id

Line 276: UPDATE msc_system_items

272: ELSE
273: l_vmi_refresh_flag := NULL;
274: END IF;
275:
276: UPDATE msc_system_items
277: SET -- average_daily_demand = l_average_daily_demand
278: vmi_refresh_flag = NVL(l_vmi_refresh_flag, vmi_refresh_flag)
279: WHERE plan_id = p_plan_id
280: AND inventory_item_id = p_inventory_item_id