APPS.MSC_ATP_PVT dependencies on MSC_PLANS

Line 10312: -- 3/4/2002, modified to honor planning_time_fence_flag from msc_plans to adjust for

10308: -- If the requested ship date is before planning time fence (PTF) date then
10309: -- we fail the request. The logic is that production schedule is fixed before
10310: -- PTF. Hence no planned orders should be placed before PTF
10311:
10312: -- 3/4/2002, modified to honor planning_time_fence_flag from msc_plans to adjust for
10313: -- ptf only if plan option is checked.
10314:
10315: -- Bug 3535999 - l_ptf_date should be validated on mgf cal
10316: -- l_ptf_date := l_sysdate;

Line 10334: msc_plans pl

10330: l_ptf_date), -- Bug 3535999 - l_sysdate),
10331: pl.planning_time_fence_flag -- Bug 3525582
10332: into l_ptf_date, l_ptf_enabled -- Bug 3525582
10333: from msc_system_items itm,
10334: msc_plans pl
10335: where itm.plan_id = p_plan_id
10336: and itm.sr_instance_id = p_atp_record.instance_id
10337: and itm.organization_id = p_atp_record.organization_id
10338: --and itm.sr_inventory_item_id = p_atp_record.inventory_item_id

Line 11379: FROM msc_plans

11375: MSC_ATP_PVT.G_PLAN_INFO_REC.enforce_pur_lead_time,
11376: MSC_ATP_PVT.G_PLAN_INFO_REC.sr_instance_id,
11377: MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date,
11378: MSC_ATP_PVT.G_PLAN_INFO_REC.organization_id
11379: FROM msc_plans
11380: WHERE plan_id = p_plan_id;
11381: END IF;
11382: --Bug 5651914 end
11383:

Line 17741: msc_plans plans

17737: from msc_system_items
17738: where plan_id in ( select plans.plan_id input_plan_id
17739: from msc_plan_schedules sched,
17740: msc_designators md,
17741: msc_plans plans
17742: where sched.plan_id = x_plan_info_rec.plan_id
17743: and sched.input_type = 1
17744: and sched.designator_type in (2,3,4,5)
17745: and sched.input_schedule_id = md.designator_id