APPS.MSC_POST_PRO dependencies on MSC_DESIGNATORS

Line 482: FROM MSC_DESIGNATORS

478: OR
479: ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
480: S.ORDER_TYPE = 5
481: AND exists (SELECT '1'
482: FROM MSC_DESIGNATORS
483: WHERE INVENTORY_ATP_FLAG = 1
484: AND DESIGNATOR_TYPE = 2
485: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID)))
486: AND C.CALENDAR_CODE = TP.calendar_code

Line 1784: FROM msc_designators desig,

1780: )
1781: )
1782: ), 0)
1783: INTO l_use_bor, l_optimized_plan, l_constraint_plan
1784: FROM msc_designators desig,
1785: msc_plans plans
1786: WHERE plans.plan_id = p_plan_id
1787: AND desig.designator = plans.compile_designator
1788: AND desig.sr_instance_id = plans.sr_instance_id

Line 3067: FROM MSC_DESIGNATORS

3063: DECODE(R.INCLUDE_FLOW_SCHEDULE_RECEIPTS, 1, 28, -1))
3064: OR ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
3065: S.ORDER_TYPE = 5
3066: AND exists (SELECT '1'
3067: FROM MSC_DESIGNATORS
3068: WHERE INVENTORY_ATP_FLAG = 1
3069: AND DESIGNATOR_TYPE = 2
3070: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID)))
3071: AND C.CALENDAR_CODE = l_calendar_code

Line 3177: FROM MSC_DESIGNATORS

3173: DECODE(R.INCLUDE_FLOW_SCHEDULE_RECEIPTS, 1, 28, -1))
3174: OR ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
3175: S.ORDER_TYPE = 5
3176: AND exists (SELECT '1'
3177: FROM MSC_DESIGNATORS
3178: WHERE INVENTORY_ATP_FLAG = 1
3179: AND DESIGNATOR_TYPE = 2
3180: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID)))
3181: AND C.CALENDAR_CODE = l_calendar_code

Line 6317: msc_designators desig

6313: -- Bug 3491498, check if plan is ATPable. Moved up to check it prior to refresh MSC_ATP_PLAN_SN
6314: SELECT count(*)
6315: INTO l_count
6316: FROM msc_plans plans,
6317: msc_designators desig
6318: WHERE desig.inventory_atp_flag = 1
6319: AND plans.plan_id = p_plan_id
6320: AND plans.compile_designator = desig.designator
6321: AND plans.sr_instance_id = desig.sr_instance_id

Line 6350: msc_designators desig

6346: /*
6347: SELECT count(*)
6348: INTO l_count
6349: FROM msc_plans plans,
6350: msc_designators desig
6351: WHERE desig.inventory_atp_flag = 1
6352: AND plans.plan_id = p_plan_id
6353: AND plans.compile_designator = desig.designator
6354: AND plans.sr_instance_id = desig.sr_instance_id

Line 8904: msc_designators desig

8900:
8901: SELECT count(*)
8902: INTO l_count
8903: FROM msc_plans plans,
8904: msc_designators desig
8905: WHERE plans.plan_id = p_plan_id
8906: AND plans.plan_type <> 4
8907: AND plans.compile_designator = desig.designator
8908: AND plans.sr_instance_id = desig.sr_instance_id