DBA Data[Home] [Help]

APPS.MRP_ADJUST_DATES_PK dependencies on BOM_PERIOD_START_DATES

Line 283: FROM bom_period_start_dates cal

279: SET /* dates.last_update_date = SYSDATE,
280: dates.last_updated_by = user_id, */
281: dates.forecast_date =
282: (SELECT MAX(period_start_date)
283: FROM bom_period_start_dates cal
284: WHERE cal.calendar_code = cal_code
285: AND cal.exception_set_id = except_set_id
286: AND cal.period_start_date <= dates.forecast_date)
287: WHERE dates.bucket_type = 3

Line 297: FROM bom_period_start_dates cal

293: SET /* dates.last_update_date = SYSDATE,
294: dates.last_updated_by = user_id, */
295: dates.rate_end_date =
296: (SELECT MAX(period_start_date)
297: FROM bom_period_start_dates cal
298: WHERE cal.calendar_code = cal_code
299: AND cal.exception_set_id = except_set_id
300: AND cal.period_start_date <= dates.rate_end_date)
301: WHERE dates.rate_end_date IS NOT NULL