APPS.MSC_DS_SCHEDULE dependencies on MSC_EXCEPTION_DETAILS_V

Line 16: from msc_exception_details_v

12: -- 90 Excessive Setups
13: -- 6,7 Orders to be Rescheduled In" and "Orders to be Rescheduled Out"
14: cursor c_exc_summary is
15: select exception_type, count(*) exc_count
16: from msc_exception_details_v
17: where plan_id = p_plan_id
18: and nvl(category_set_id, p_cat_set_id) = p_cat_set_id
19: and exception_type in (87, 36, 37, 90, 6, 7)
20: group by exception_type;

Line 72: from msc_exception_details_v

68: where plan_id = p_plan_id;
69:
70: cursor c_pas_due is
71: select count(*)
72: from msc_exception_details_v
73: where plan_id = p_plan_id
74: and exception_type = 10
75: and nvl(category_set_id, p_cat_set_id) = p_cat_set_id;
76: