APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_PLANS

Line 179: FROM msc_plans

175: weekly_material_constraints,
176: weekly_resource_constraints,
177: period_material_constraints,
178: period_resource_constraints
179: FROM msc_plans
180: WHERE plan_id = p_plan_id;
181:
182: CURSOR seqnum_cursor(p_date DATE) IS
183: SELECT next_seq_num

Line 1107: FROM msc_plans

1103:
1104: CURSOR plan_buckets IS
1105: SELECT DECODE(g_designator, -1, trunc(sysdate), trunc(curr_start_date)) - 1,
1106: DECODE(g_designator, -1, trunc(sysdate+365), trunc(curr_cutoff_date))
1107: FROM msc_plans
1108: WHERE plan_id = g_designator;
1109:
1110: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1111: SELECT cal.calendar_date

Line 2100: from msc_plans

2096: g_optimized_plan := SYS_NO;
2097: END IF;
2098:
2099: select plan_type into l_plan_type
2100: from msc_plans
2101: where plan_id = p_plan_id;
2102: if ( l_plan_type = 4 ) then -- sro plan
2103: g_optimized_plan := SYS_NO;
2104: end if;