[Home] [Help]
54:
55: --
56: -- Populate MRP_FORM_QUERY
57: --
58: -- The view MRP_DAILY_SCHEDULES_V has already:
59: --
60: -- - bucketed the discrete schedule entries into the correct
61: -- workdate (previous workdate for invalid workdate)
62: --
141: sched.interorg_qty,
142: sched.original_interorg_qty)),
143: 0)
144: FROM bom_calendar_dates dates,
145: mrp_daily_schedules_v sched,
146: mtl_parameters param
147: WHERE param.organization_id = arg_org_id
148: AND param.calendar_exception_set_id = dates.exception_set_id
149: AND param.calendar_code = dates.calendar_code
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
243: AND param.calendar_code = dates.calendar_code
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
388: AND param.calendar_code = dates.calendar_code
494: var_tmp_forecast,
495: var_tmp_sales_order,
496: var_tmp_exploded,
497: var_tmp_interorg
498: FROM mrp_daily_schedules_v sched
499: WHERE sched.organization_id = arg_org_id
500: AND sched.schedule_designator = arg_schedule_designator
501: AND sched.inventory_item_id = arg_inventory_item_id
502: AND sched.schedule_level = arg_version_type