[Home] [Help]
9601: -- If the requested ship date is before planning time fence (PTF) date then
9602: -- we fail the request. The logic is that production schedule is fixed before
9603: -- PTF. Hence no planned orders should be placed before PTF
9604:
9605: -- 3/4/2002, modified to honor planning_time_fence_flag from msc_plans to adjust for
9606: -- ptf only if plan option is checked.
9607:
9608: -- Bug 3535999 - l_ptf_date should be validated on mgf cal
9609: -- l_ptf_date := l_sysdate;
9623: l_ptf_date), -- Bug 3535999 - l_sysdate),
9624: pl.planning_time_fence_flag -- Bug 3525582
9625: into l_ptf_date, l_ptf_enabled -- Bug 3525582
9626: from msc_system_items itm,
9627: msc_plans pl
9628: where itm.plan_id = p_plan_id
9629: and itm.sr_instance_id = p_atp_record.instance_id
9630: and itm.organization_id = p_atp_record.organization_id
9631: --and itm.sr_inventory_item_id = p_atp_record.inventory_item_id
16874: from msc_system_items
16875: where plan_id in ( select plans.plan_id input_plan_id
16876: from msc_plan_schedules sched,
16877: msc_designators md,
16878: msc_plans plans
16879: where sched.plan_id = x_plan_info_rec.plan_id
16880: and sched.input_type = 1
16881: and sched.designator_type in (2,3,4,5)
16882: and sched.input_schedule_id = md.designator_id