DBA Data[Home] [Help]

APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on BOM_CALENDAR_DATES

Line 772: FROM bom_calendar_dates bom_cal

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