DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MSC_ATP_FUNC

Line 2367: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))

2363: DECODE(R.demand_class_atp_flag,1,
2364: nvl(p_demand_class,
2365: nvl(p_default_dmd_class,'@@@')),'@@@')
2366: )))
2367: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))
2368: AND C.CALENDAR_CODE = p_cal_code
2369: AND C.EXCEPTION_SET_ID = G_CAL_EXC_SET_ID
2370: AND C.SR_INSTANCE_ID = I.SR_INSTANCE_ID
2371: -- Bug 2132288, 2442009

Line 2914: 5, MSC_ATP_FUNC.Get_Designator(S.SCHEDULE_DESIGNATOR_ID),

2910: 2, S.ORDER_NUMBER,
2911: 3, S.ORDER_NUMBER,
2912: 7, S.ORDER_NUMBER,
2913: 8, S.ORDER_NUMBER,
2914: 5, MSC_ATP_FUNC.Get_Designator(S.SCHEDULE_DESIGNATOR_ID),
2915: 11, S.ORDER_NUMBER,
2916: 12, S.ORDER_NUMBER,
2917: 14, S.ORDER_NUMBER,
2918: 15, S.ORDER_NUMBER,

Line 2999: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))

2995: DECODE(R.demand_class_atp_flag,1,
2996: nvl(p_demand_class,
2997: nvl(p_default_dmd_class,'@@@')),'@@@')
2998: )))
2999: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))
3000: AND C.CALENDAR_CODE = p_cal_code
3001: AND C.EXCEPTION_SET_ID = G_CAL_EXC_SET_ID
3002: AND C.SR_INSTANCE_ID = p_instance_id
3003: -- Bug 2132288, 2442009