DBA Data[Home] [Help]

APPS.MRP_ADJUST_DATES_PK dependencies on BOM_CAL_WEEK_START_DATES

Line 253: FROM bom_cal_week_start_dates cal

249: SET /* dates.last_update_date = SYSDATE,
250: dates.last_updated_by = user_id, */
251: dates.forecast_date =
252: (SELECT MAX(week_start_date)
253: FROM bom_cal_week_start_dates cal
254: WHERE cal.calendar_code = cal_code
255: AND cal.exception_set_id = except_set_id
256: AND cal.week_start_date <= dates.forecast_date)
257: WHERE dates.bucket_type = 2

Line 268: FROM bom_cal_week_start_dates cal

264: SET /* dates.last_update_date = SYSDATE,
265: dates.last_updated_by = user_id, */
266: dates.rate_end_date =
267: (SELECT MAX(week_start_date)
268: FROM bom_cal_week_start_dates cal
269: WHERE cal.calendar_code = cal_code
270: AND cal.exception_set_id = except_set_id
271: AND cal.week_start_date <= dates.rate_end_date)
272: WHERE dates.rate_end_date IS NOT NULL