eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 6326: msc_designators desig

6322: -- Bug 3491498, check if plan is ATPable. Moved up to check it prior to refresh MSC_ATP_PLAN_SN
6323: SELECT count(*)
6324: INTO l_count
6325: FROM msc_plans plans,
6326: msc_designators desig
6327: WHERE desig.inventory_atp_flag = 1
6328: AND plans.plan_id = p_plan_id
6329: AND plans.compile_designator = desig.designator
6330: AND plans.sr_instance_id = desig.sr_instance_id

Line 6359: msc_designators desig

6355: /*
6356: SELECT count(*)
6357: INTO l_count
6358: FROM msc_plans plans,
6359: msc_designators desig
6360: WHERE desig.inventory_atp_flag = 1
6361: AND plans.plan_id = p_plan_id
6362: AND plans.compile_designator = desig.designator
6363: AND plans.sr_instance_id = desig.sr_instance_id

Line 6392: msc_designators desig

6388:
6389: SELECT count(*)
6390: INTO l_count1
6391: FROM msc_plans plans,
6392: msc_designators desig
6393: WHERE desig.inventory_atp_flag = 1
6394: AND plans.plan_id = l_copy_plan_id
6395: AND plans.compile_designator = desig.designator
6396: AND plans.sr_instance_id = desig.sr_instance_id

Line 8942: msc_designators desig

8938:
8939: SELECT count(*)
8940: INTO l_count
8941: FROM msc_plans plans,
8942: msc_designators desig
8943: WHERE plans.plan_id = p_plan_id
8944: AND plans.plan_type <> 4
8945: AND plans.compile_designator = desig.designator
8946: AND plans.sr_instance_id = desig.sr_instance_id