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_ATP_FUNC

Line 423: MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),

419: I.organization_id,
420: I.inventory_item_id,
421: Decode(NVL(R.DEMAND_CLASS_ATP_FLAG,0),1 ,
422: NVL(DECODE(S.ORDER_TYPE, 5,
423: MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),
424: S.DEMAND_CLASS), NVL(TP.default_demand_class, '@@@')), '@@@')
425: demand_class,
426: C.NEXT_DATE SD_DATE, -- 2859130 remove trunc
427: Decode(order_type, -- 2859130 remove trunc

Line 2075: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM

2071: FROM msc_calendar_dates c
2072: WHERE C.PRIOR_SEQ_NUM >=
2073: DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
2074: NULL, C.PRIOR_SEQ_NUM,
2075: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM
2076: (D.ORGANIZATION_ID, P_INSTANCE_ID, l_sysdate)
2077: - NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0))
2078: AND C.CALENDAR_CODE = l_CALENDAR_CODE
2079: AND C.SR_INSTANCE_ID = p_instance_id

Line 2139: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,

2135: FROM msc_calendar_dates c
2136: WHERE C.PRIOR_SEQ_NUM >=
2137: DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
2138: NULL, C.PRIOR_SEQ_NUM,
2139: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,
2140: P_INSTANCE_ID,
2141: l_sysdate) - NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0))
2142: AND C.CALENDAR_CODE = l_CALENDAR_CODE
2143: AND C.SR_INSTANCE_ID = p_instance_id

Line 2238: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,

2234: FROM msc_calendar_dates c
2235: WHERE C.PRIOR_SEQ_NUM >=
2236: DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
2237: NULL, C.PRIOR_SEQ_NUM,
2238: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,
2239: P_INSTANCE_ID,
2240: l_sysdate) - NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0))
2241: AND C.CALENDAR_CODE = l_CALENDAR_CODE
2242: AND C.SR_INSTANCE_ID = p_instance_id

Line 2316: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,

2312: FROM msc_calendar_dates c
2313: WHERE C.PRIOR_SEQ_NUM >=
2314: DECODE(R.PAST_DUE_DEMAND_CUTOFF_FENCE,
2315: NULL, C.PRIOR_SEQ_NUM,
2316: MSC_ATP_FUNC.NEXT_WORK_DAY_SEQNUM(D.ORGANIZATION_ID,
2317: P_INSTANCE_ID,
2318: l_sysdate) - NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0))
2319: AND C.CALENDAR_CODE = l_CALENDAR_CODE
2320: AND C.SR_INSTANCE_ID = p_instance_id

Line 2993: 5, MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),

2989: UNION ALL -- new supplies information
2990: (SELECT /*+ ordered index(C,MSC_CALENDAR_DATES_U1) */I.inventory_item_id, -- 5098576/5199686
2991: Decode(NVL(R.DEMAND_CLASS_ATP_FLAG,0),1 ,
2992: NVL(DECODE(S.ORDER_TYPE,
2993: 5, MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),
2994: S.DEMAND_CLASS), NVL(l_default_demand_class, '@@@')), '@@@'),
2995: C.NEXT_DATE SD_DATE,
2996: --- bug 1843471, 2619493
2997: Decode(order_type, -- 2859130 remove trunc

Line 3099: 5, MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),

3095: UNION ALL -- with old supplies information
3096: (SELECT /*+ ordered index(C,MSC_CALENDAR_DATES_U1) */I.inventory_item_id, -- 5098576/5199686
3097: Decode(NVL(R.DEMAND_CLASS_ATP_FLAG,0),1 ,
3098: NVL(DECODE(S.ORDER_TYPE,
3099: 5, MSC_ATP_FUNC.Get_MPS_Demand_Class(S.SCHEDULE_DESIGNATOR_ID),
3100: S.DEMAND_CLASS), NVL(l_default_demand_class, '@@@')), '@@@'),
3101: C.NEXT_DATE SD_DATE,
3102: --- bug 1843471, 2619493
3103: -- 2859130 remove trunc on calendar_date