APPS.MSC_X_CVMI_PLANNING dependencies on MSC_VMI_TEMP

Line 42: , msc_vmi_temp mvt

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
45: AND msi.sr_instance_id = mtp.sr_instance_id
46: AND mtp.partner_type = 3 -- org

Line 288: UPDATE msc_vmi_temp

284: print_debug_info( ' vmi refresh flag updated, number of rows updated = '
285: || SQL%ROWCOUNT
286: );
287:
288: UPDATE msc_vmi_temp
289: SET average_daily_demand = l_average_daily_demand
290: WHERE plan_id = p_plan_id
291: AND inventory_item_id = p_inventory_item_id
292: AND organization_id = p_organization_id

Line 301: INSERT INTO msc_vmi_temp

297: || SQL%ROWCOUNT
298: );
299:
300: IF (SQL%ROWCOUNT = 0 ) THEN
301: INSERT INTO msc_vmi_temp
302: ( PLAN_ID,
303: INVENTORY_ITEM_ID,
304: ORGANIZATION_ID ,
305: SR_INSTANCE_ID ,