DBA Data[Home] [Help]

APPS.MSC_X_PLANNING dependencies on MSC_VMI_TEMP

Line 133: , msc_vmi_temp mvt

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
137: AND mis.organization_id = p_organization_id

Line 273: UPDATE msc_vmi_temp

269: print_debug_info( ' vmi refresh flag updated, number of rows updated = '
270: || SQL%ROWCOUNT
271: );
272:
273: UPDATE msc_vmi_temp
274: SET average_daily_demand = p_average_daily_demand
275: WHERE plan_id = p_plan_id
276: AND inventory_item_id = p_inventory_item_id
277: AND organization_id = p_organization_id

Line 290: INSERT INTO msc_vmi_temp

286: || SQL%ROWCOUNT
287: );
288:
289: IF (SQL%ROWCOUNT = 0 ) THEN
290: INSERT INTO msc_vmi_temp
291: ( PLAN_ID,
292: INVENTORY_ITEM_ID,
293: ORGANIZATION_ID ,
294: SR_INSTANCE_ID ,