DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MSC_ATP_FUNC

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

2375: DECODE(R.demand_class_atp_flag,1,
2376: nvl(p_demand_class,
2377: nvl(p_default_dmd_class,'@@@')),'@@@')
2378: )))
2379: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))
2380: AND C.CALENDAR_CODE = p_cal_code
2381: AND C.EXCEPTION_SET_ID = G_CAL_EXC_SET_ID
2382: AND C.SR_INSTANCE_ID = I.SR_INSTANCE_ID
2383: -- Bug 2132288, 2442009

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

2922: 2, S.ORDER_NUMBER,
2923: 3, S.ORDER_NUMBER,
2924: 7, S.ORDER_NUMBER,
2925: 8, S.ORDER_NUMBER,
2926: 5, MSC_ATP_FUNC.Get_Designator(S.SCHEDULE_DESIGNATOR_ID),
2927: 11, S.ORDER_NUMBER,
2928: 12, S.ORDER_NUMBER,
2929: 14, S.ORDER_NUMBER,
2930: 15, S.ORDER_NUMBER,

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

3012: DECODE(R.demand_class_atp_flag,1,
3013: nvl(p_demand_class,
3014: nvl(p_default_dmd_class,'@@@')),'@@@')
3015: )))
3016: --AND MSC_ATP_FUNC.MPS_ATP(S.SCHEDULE_DESIGNATOR_ID) = 1))
3017: AND C.CALENDAR_CODE = p_cal_code
3018: AND C.EXCEPTION_SET_ID = G_CAL_EXC_SET_ID
3019: AND C.SR_INSTANCE_ID = p_instance_id
3020: -- Bug 2132288, 2442009