DBA Data[Home] [Help]

APPS.MRP_SCHEDULE dependencies on MTL_PARAMETERS

Line 146: mtl_parameters param

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
150: AND sched.organization_id (+)= arg_org_id

Line 240: mtl_parameters param

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
244: AND sched.organization_id = arg_org_id

Line 296: mtl_parameters param

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
299: AND param.calendar_code = dates.calendar_code
300: AND query.query_id (+)= arg_query_id2

Line 385: mtl_parameters param

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
389: AND sched.organization_id = arg_org_id

Line 441: mtl_parameters param

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
444: AND param.calendar_code = dates.calendar_code
445: AND query.query_id (+)= arg_query_id2