APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_FORM_QUERY_S

Line 3276: SELECT msc_form_query_s.nextval

3272: ''') OR (trunc(nvl(firm_date,new_due_date)) <='''||
3273: p_end_date|| ''' AND trunc(last_unit_completion_date) >= '''||
3274: p_start_date||'''))';/*End for bug 12746680 */
3275:
3276: SELECT msc_form_query_s.nextval
3277: INTO l_query_id
3278: FROM dual;
3279:
3280: --< bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies