APPS.MSC_AATP_PVT dependencies on MSC_PLANS

Line 5597: msc_plans plans

5593: trunc(plan_start_date)
5594:
5595: INTO l_optimized_plan,l_constraint_plan, l_plan_start_date
5596: FROM msc_designators desig,
5597: msc_plans plans
5598: WHERE plans.plan_id = p_plan_id
5599: AND desig.designator = plans.compile_designator
5600: AND desig.sr_instance_id = plans.sr_instance_id
5601: AND desig.organization_id = plans.organization_id;

Line 8497: -- FROM msc_plans

8493: -- Commented out
8494: -- SELECT trunc(plan_start_date), sr_instance_id, organization_id,
8495: -- trunc(cutoff_date)
8496: -- INTO l_plan_start_date, l_instance_id, l_org_id, l_cutoff_date
8497: -- FROM msc_plans
8498: -- WHERE plan_id = p_sup_atp_info_rec.plan_id;
8499:
8500: -- Instead re-assigned local values using global variable
8501: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;

Line 8697: msc_plans mp

8693: ELSE
8694: SELECT tp.calendar_code
8695: INTO l_calendar_code
8696: FROM msc_trading_partners tp,
8697: msc_plans mp
8698: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
8699: AND tp.sr_instance_id = mp.sr_instance_id
8700: AND tp.partner_type = 3
8701: AND tp.sr_tp_id = mp.organization_id;

Line 10639: msc_plans plans,

10635: INTO l_plan_id
10636: FROM msc_department_resources mdr,
10637: msc_trading_partners tp,
10638: msc_apps_instances ins,
10639: msc_plans plans,
10640: msc_designators desig
10641: WHERE desig.inventory_atp_flag = 1
10642: AND plans.compile_designator = desig.designator
10643: AND plans.sr_instance_id = desig.sr_instance_id