APPS.MSC_X_PLANNING dependencies on MSC_ITEM_SUPPLIERS

Line 30: FROM msc_item_suppliers mis

26: , mis.sr_instance_id
27: , mis.supplier_id
28: , mis.supplier_site_id
29: , mis.using_organization_id
30: FROM msc_item_suppliers mis
31: WHERE mis.plan_id = -1
32: AND mis.vmi_flag = 1
33: ;
34:

Line 132: FROM msc_item_suppliers mis

128: , p_using_organization_id IN NUMBER
129:
130: ) IS
131: SELECT mis.forecast_horizon, mvt.average_daily_demand
132: FROM msc_item_suppliers mis
133: , msc_vmi_temp mvt
134: WHERE mis.inventory_item_id = p_inventory_item_id
135: AND mis.plan_id = p_plan_id
136: AND mis.sr_instance_id = p_sr_instance_id

Line 258: UPDATE msc_item_suppliers

254: ELSE
255: l_vmi_refresh_flag := NULL;
256: END IF;
257:
258: UPDATE msc_item_suppliers
259: SET -- average_daily_demand = p_average_daily_demand
260: vmi_refresh_flag = NVL(l_vmi_refresh_flag, vmi_refresh_flag)
261: WHERE plan_id = p_plan_id
262: AND inventory_item_id = p_inventory_item_id