DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MSC_DESIGNATORS

Line 2368: FROM MSC_DESIGNATORS

2364: ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
2365: S.ORDER_TYPE = 5
2366: -- bug 2461071
2367: AND exists (SELECT '1'
2368: FROM MSC_DESIGNATORS
2369: WHERE INVENTORY_ATP_FLAG = 1
2370: AND DESIGNATOR_TYPE = 2
2371: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID
2372: AND DECODE(R.demand_class_atp_flag,1,

Line 3005: FROM MSC_DESIGNATORS

3001: ((R.INCLUDE_REP_MPS = 1 OR R.INCLUDE_DISCRETE_MPS = 1) AND
3002: S.ORDER_TYPE = 5
3003: -- bug 2461071
3004: AND exists (SELECT '1'
3005: FROM MSC_DESIGNATORS
3006: WHERE INVENTORY_ATP_FLAG = 1
3007: AND DESIGNATOR_TYPE = 2
3008: AND DESIGNATOR_ID = S.SCHEDULE_DESIGNATOR_ID
3009: AND DECODE(R.demand_class_atp_flag,1,