APPS.MSC_DS_SCHEDULE dependencies on MSC_BIS_PLAN_SUMMARY_KPI

Line 67: from msc_bis_plan_summary_kpi

63: cursor c_late_supply is
64: select round(sum(total_supply_count),p_round_val),
65: round(sum(late_supply_count),p_round_val),
66: round(avg(total_days_late),p_round_val)
67: from msc_bis_plan_summary_kpi
68: where plan_id = p_plan_id;
69:
70: cursor c_pas_due is
71: select count(*)

Line 96: from msc_bis_plan_summary_kpi

92: select to_date(key_date,'J') detail_date,
93: round(nvl(total_supply_count,0), p_round_val) total_supply_count,
94: round(nvl(late_supply_count,0), p_round_val) late_supply_count,
95: round(nvl(total_days_late,0), p_round_val) total_days_late
96: from msc_bis_plan_summary_kpi
97: where plan_id = p_plan_id
98: order by to_date(key_date,'J');
99:
100: i number := 1;