DBA Data[Home] [Help]

APPS.MRP_DEFAULT_FLOW_SCHEDULE dependencies on BOM_CALENDAR_DATES

Line 1200: FROM bom_calendar_dates bom_cal

1196:
1197:
1198: SELECT min(to_number(to_char(bom_cal.calendar_date,'J')))
1199: into l_valid_date
1200: FROM bom_calendar_dates bom_cal
1201: WHERE bom_cal.calendar_code = l_cal_code
1202: AND bom_cal.exception_set_id = l_excep_code
1203: AND bom_cal.calendar_date >= to_date(l_completion_date_num,'j')
1204: AND bom_cal.seq_num is NOT NULL;

Line 1227: FROM bom_calendar_dates bom_cal

1223:
1224:
1225: SELECT min(to_number(to_char(bom_cal.calendar_date,'J')))
1226: into l_valid_date
1227: FROM bom_calendar_dates bom_cal
1228: WHERE bom_cal.calendar_code = l_cal_code
1229: AND bom_cal.exception_set_id = l_excep_code
1230: AND bom_cal.calendar_date >= to_date(l_completion_date_num,'j')
1231: AND bom_cal.seq_num is NOT NULL;