DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_DESIGNATORS

Line 2207: FROM MSC_DESIGNATORS

2203: ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
2204: S.ORDER_TYPE = 5
2205: -- bug 2461071
2206: AND exists (SELECT '1'
2207: FROM MSC_DESIGNATORS
2208: WHERE INVENTORY_ATP_FLAG = 1
2209: AND DESIGNATOR_TYPE = 2
2210: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID
2211: AND DECODE(R.demand_class_atp_flag,1,

Line 2804: FROM MSC_DESIGNATORS

2800: ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
2801: S.ORDER_TYPE = 5
2802: -- bug 2461071
2803: AND exists (SELECT '1'
2804: FROM MSC_DESIGNATORS
2805: WHERE INVENTORY_ATP_FLAG = 1
2806: AND DESIGNATOR_TYPE = 2
2807: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID
2808: AND DECODE(R.demand_class_atp_flag,1,

Line 5823: FROM msc_designators desig,

5819: )
5820: ), 0),
5821: plans.summary_flag -- for summary enhancement
5822: INTO l_use_bor, MSC_ATP_PVT.G_OPTIMIZED_PLAN, l_constraint_plan, l_summary_flag
5823: FROM msc_designators desig,
5824: msc_plans plans
5825: WHERE plans.plan_id = p_plan_id
5826: AND desig.designator = plans.compile_designator
5827: AND desig.sr_instance_id = plans.sr_instance_id