DBA Data[Home] [Help]

APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on BOM_CALENDAR_DATES

Line 771: FROM bom_calendar_dates bom_cal

767:
768: CURSOR valid_dates(l_cal_code IN VARCHAR2, l_excep_code IN NUMBER,
769: l_schedule_start_date IN NUMBER, l_schedule_end_date IN NUMBER) IS
770: SELECT to_number(to_char(bom_cal.calendar_date,'J')) workday
771: FROM bom_calendar_dates bom_cal
772: WHERE bom_cal.calendar_code = l_cal_code
773: AND bom_cal.exception_set_id = l_excep_code
774: AND bom_cal.calendar_date between to_date(l_schedule_start_date,'j') and
775: to_date(l_schedule_end_date,'j')