APPS.MRP_SCHEDULE dependencies on BOM_PERIOD_START_DATES

Line 383: FROM bom_period_start_dates dates,

379: NVL(SUM(DECODE(arg_quantity_type, TYPE_CURRENT_QTY,
380: sched.interorg_qty,
381: sched.original_interorg_qty)),
382: 0)
383: FROM bom_period_start_dates dates,
384: mrp_daily_schedules_v sched,
385: mtl_parameters param
386: WHERE param.organization_id = arg_org_id
387: AND param.calendar_exception_set_id = dates.exception_set_id

Line 402: -- Outer-joined with BOM_PERIOD_START_DATES to get those

398: AND arg_cutoff_date
399: GROUP BY arg_query_id2, dates.period_start_date, dates.next_date;
400:
401: --
402: -- Outer-joined with BOM_PERIOD_START_DATES to get those
403: -- periods that do not have entries
404: --
405: INSERT INTO mrp_form_query
406: (QUERY_ID,

Line 439: FROM bom_period_start_dates dates,

435: NVL(SUM(query.number8), 0), -- orig: forecast
436: NVL(SUM(query.number9), 0), -- orig: sales order
437: NVL(SUM(query.number11), 0), -- orig: exploded
438: NVL(SUM(query.number12), 0) -- orig: interorg order
439: FROM bom_period_start_dates dates,
440: mrp_form_query query,
441: mtl_parameters param
442: WHERE param.organization_id = arg_org_id
443: AND param.calendar_exception_set_id = dates.exception_set_id