APPS.MSC_AATP_REQ dependencies on MSC_CALENDAR

Line 176: -- join to msc_calendar_dates is not needed.

172: AND P.PLAN_ID = AD.PLAN_ID
173: AND (AD.REFRESH_NUMBER > P.LATEST_REFRESH_NUMBER
174: OR AD.REFRESH_NUMBER = p_refresh_number)
175: -- since repetitive schedule demand is not supported in this case
176: -- join to msc_calendar_dates is not needed.
177:
178: UNION ALL
179:
180: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,

Line 252: -- join to msc_calendar_dates is not needed.

248: AND AD.ORGANIZATION_ID = p_organization_id
249: AND AD.DEMAND_CLASS = NVL(p_demand_class, AD.DEMAND_CLASS)
250: AND TRUNC(AD.DEMAND_DATE) < l_infinite_time_fence_date
251: -- since repetitive schedule demand is not supported in this case
252: -- join to msc_calendar_dates is not needed.
253: UNION ALL
254: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
255: SA.ALLOCATED_QUANTITY SD_QTY
256: FROM MSC_ALLOC_SUPPLIES SA

Line 435: -- join to msc_calendar_dates is not needed.

431: AND AD.SHIP_TO_SITE_ID = MTPS.PARTNER_SITE_ID(+) --bug3263368
432: AND AD.CUSTOMER_ID = MTP.PARTNER_ID(+)--bug3263368
433:
434: -- since repetitive schedule demand is not supported in this case
435: -- join to msc_calendar_dates is not needed.
436: UNION ALL
437: SELECT p_level col1,
438: p_identifier col2,
439: p_scenario_id col3,

Line 992: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

988: MSC_ATP_PROC.get_org_default_info(p_instance_id, p_organization_id,
989: l_default_atp_rule_id, l_calendar_code, l_calendar_exception_set_id,
990: l_default_demand_class, l_org_code);
991: -- Bug 3371817 - l_sys_next_date should be actually calculated using the calendar passed from ATP_Check
992: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
993: p_get_mat_in_rec.shipping_cal_code,
994: p_instance_id,
995: TRUNC(sysdate));
996: /*

Line 1000: FROM msc_calendar_dates cal

996: /*
997: BEGIN
998: SELECT cal.next_date
999: INTO l_sys_next_date
1000: FROM msc_calendar_dates cal
1001: WHERE cal.exception_set_id = l_calendar_exception_set_id
1002: AND cal.calendar_code = l_calendar_code
1003: AND cal.calendar_date = TRUNC(sysdate)
1004: AND cal.sr_instance_id = p_instance_id ;

Line 1019: l_substitution_end_date := MSC_CALENDAR.DATE_OFFSET(

1015: ---forward steal:subst
1016: IF NVL(p_substitution_window, 0) = 0 THEN
1017: l_substitution_end_date := l_infinite_time_fence_date;
1018: ELSE
1019: l_substitution_end_date := MSC_CALENDAR.DATE_OFFSET(
1020: p_organization_id,
1021: p_instance_id,
1022: 1,
1023: --bug 3589115: Move to sysdate for past due dates