APPS.MRP_SCHEDULE dependencies on BOM_CAL_WEEK_START_DATES

Line 238: FROM bom_cal_week_start_dates dates,

234: NVL(SUM(DECODE(arg_quantity_type, TYPE_CURRENT_QTY,
235: sched.interorg_qty,
236: sched.original_interorg_qty)),
237: 0)
238: FROM bom_cal_week_start_dates dates,
239: mrp_daily_schedules_v sched,
240: mtl_parameters param
241: WHERE param.organization_id = arg_org_id
242: AND param.calendar_exception_set_id = dates.exception_set_id

Line 257: -- Outer-joined with BOM_CAL_WEEK_START_DATES to get those

253: AND arg_cutoff_date
254: GROUP BY arg_query_id2, dates.week_start_date, dates.next_date;
255:
256: --
257: -- Outer-joined with BOM_CAL_WEEK_START_DATES to get those
258: -- weeks that do not have entries
259: --
260: INSERT INTO mrp_form_query
261: (QUERY_ID,

Line 294: FROM bom_cal_week_start_dates dates,

290: NVL(SUM(query.number8), 0), -- orig: forecast
291: NVL(SUM(query.number9), 0), -- orig: sales order
292: NVL(SUM(query.number11), 0), -- orig: exploded
293: NVL(SUM(query.number12), 0) -- orig: interorg order
294: FROM bom_cal_week_start_dates dates,
295: mrp_form_query query,
296: mtl_parameters param
297: WHERE param.organization_id = arg_org_id
298: AND param.calendar_exception_set_id = dates.exception_set_id