DBA Data[Home] [Help]

APPS.MRP_WB_BUCKET_DATES dependencies on BOM_PERIOD_START_DATES

Line 227: FROM bom_period_start_dates

223: -- beginning at the plan start_date
224: -- -----------------------------------------------------------------
225: DECLARE CURSOR PERIODS IS
226: SELECT period_start_date
227: FROM bom_period_start_dates
228: WHERE calendar_code = var_calendar_code
229: AND exception_set_id = var_exception_set_id
230: AND period_start_date >= var_the_date + DECODE(counter, 0, 0, 1)
231: AND rownum <= var_num_periods + DECODE(counter, 0, 1, 0)