APPS.MSC_AATP_PVT dependencies on MSC_PLANS

Line 5827: msc_plans plans

5823: trunc(plan_start_date)
5824:
5825: INTO l_optimized_plan,l_constraint_plan, l_plan_start_date
5826: FROM msc_designators desig,
5827: msc_plans plans
5828: WHERE plans.plan_id = p_plan_id
5829: AND desig.designator = plans.compile_designator
5830: AND desig.sr_instance_id = plans.sr_instance_id
5831: AND desig.organization_id = plans.organization_id;

Line 8727: -- FROM msc_plans

8723: -- Commented out
8724: -- SELECT trunc(plan_start_date), sr_instance_id, organization_id,
8725: -- trunc(cutoff_date)
8726: -- INTO l_plan_start_date, l_instance_id, l_org_id, l_cutoff_date
8727: -- FROM msc_plans
8728: -- WHERE plan_id = p_sup_atp_info_rec.plan_id;
8729:
8730: -- Instead re-assigned local values using global variable
8731: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;

Line 8928: msc_plans mp

8924: ELSE
8925: SELECT tp.calendar_code
8926: INTO l_calendar_code
8927: FROM msc_trading_partners tp,
8928: msc_plans mp
8929: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
8930: AND tp.sr_instance_id = mp.sr_instance_id
8931: AND tp.partner_type = 3
8932: AND tp.sr_tp_id = mp.organization_id;

Line 10870: msc_plans plans,

10866: INTO l_plan_id
10867: FROM msc_department_resources mdr,
10868: msc_trading_partners tp,
10869: msc_apps_instances ins,
10870: msc_plans plans,
10871: msc_designators desig
10872: WHERE desig.inventory_atp_flag = 1
10873: AND plans.compile_designator = desig.designator
10874: AND plans.sr_instance_id = desig.sr_instance_id