APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_PLANS

Line 199: FROM msc_plans

195: weekly_material_constraints,
196: weekly_resource_constraints,
197: period_material_constraints,
198: period_resource_constraints
199: FROM msc_plans
200: WHERE plan_id = p_plan_id;
201:
202: CURSOR seqnum_cursor(p_date DATE) IS
203: SELECT next_seq_num

Line 660: msc_plans mp,

656: --sum(avail.capacity_units * decode(from_time,NULL,1,(( DECODE(sign(avail.to_time-avail.from_time), -1, avail.to_time+86400, avail.to_time) - avail.from_time)/3600))),
657: to_number(-1),
658: to_char('-1')
659: FROM msc_net_resource_avail avail,
660: msc_plans mp,
661: msc_form_query list
662: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
663: AND avail.shift_date >= g_dates(1)+1
664: AND NVL(avail.parent_id,0) <> -1

Line 1014: FROM msc_net_res_inst_avail avail, msc_plans mp,

1010:
1011: --sum(nvl(avail.capacity_units,1) * decode(from_time,NULL,1,(( DECODE(sign(avail.to_time-avail.from_time), -1, avail.to_time+86400, avail.to_time) - avail.from_time)/3600))),
1012: avail.res_instance_id,
1013: avail.serial_number
1014: FROM msc_net_res_inst_avail avail, msc_plans mp,
1015: msc_form_query list
1016: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
1017: AND avail.shift_date >= g_dates(1)+1
1018: AND NVL(avail.parent_id,0) <> -1

Line 1282: FROM msc_plans

1278:
1279: CURSOR plan_buckets IS
1280: SELECT DECODE(g_designator, -1, trunc(sysdate), trunc(curr_start_date)) - 1,
1281: DECODE(g_designator, -1, trunc(sysdate+365), trunc(curr_cutoff_date))
1282: FROM msc_plans
1283: WHERE plan_id = g_designator;
1284:
1285: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1286: SELECT cal.calendar_date

Line 2348: from msc_plans

2344: g_optimized_plan := SYS_NO;
2345: END IF;
2346:
2347: select plan_type into l_plan_type
2348: from msc_plans
2349: where plan_id = p_plan_id;
2350: if ( l_plan_type = 4 ) then -- sro plan
2351: g_optimized_plan := SYS_NO;
2352: end if;