APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_VMI_TEMP

Line 3124: /* get avg dail usage from new table msc_vmi_temp reason collections full refresh*/

3120: return l_intransit_lead_time;
3121:
3122: END;
3123:
3124: /* get avg dail usage from new table msc_vmi_temp reason collections full refresh*/
3125:
3126:
3127:
3128: FUNCTION supplier_avg_daily_usage(

Line 3143: FROM msc_vmi_temp

3139:
3140: cursor vmi_temp_cur is
3141: SELECT using_organization_id,
3142: nvl(average_daily_demand,0.0) average_daily_usage
3143: FROM msc_vmi_temp
3144: WHERE plan_id = -1
3145: and sr_instance_id = p_sr_instance_id
3146: and organization_id = p_organization_id
3147: and inventory_item_id = p_inventory_item_id

Line 3186: FROM msc_vmi_temp

3182: l_average_daily_usage number:=0;
3183:
3184: cursor vmi_temp_cur is
3185: SELECT nvl(average_daily_demand,0.0) average_daily_usage
3186: FROM msc_vmi_temp
3187: WHERE plan_id = -1
3188: and sr_instance_id = p_sr_instance_id
3189: and organization_id = p_organization_id
3190: and inventory_item_id = p_inventory_item_id