DBA Data[Home] [Help]

APPS.MRP_RHX_RESOURCE_AVAILABILITY dependencies on MTL_PARAMETERS

Line 149: mtl_parameters param

145: changes.shift_num,
146: changes.capacity_change
147: from bom_shift_dates dates,
148: bom_resource_changes changes,
149: mtl_parameters param
150: WHERE dates.calendar_code = param.calendar_code
151: AND dates.exception_set_id = param.calendar_exception_set_id
152: AND dates.seq_num is not null
153: AND dates.shift_date between changes.from_date AND

Line 236: mtl_parameters param

232: FROM bom_shift_dates dates,
233: bom_shift_times shifts,
234: bom_resource_shifts res_shifts,
235: bom_department_resources dept_res1,
236: mtl_parameters param
237: WHERE dates.calendar_code = param.calendar_code
238: AND dates.exception_set_id = param.calendar_exception_set_id
239: AND dates.shift_num = shifts.shift_num
240: AND dates.seq_num is not null

Line 290: mtl_parameters param

286: sysdate,
287: var_gt_user_id
288: FROM bom_calendar_dates dates,
289: bom_department_resources dept_res1,
290: mtl_parameters param
291: WHERE dates.calendar_code = param.calendar_code
292: AND dates.exception_set_id = param.calendar_exception_set_id
293: AND dates.calendar_date <= arg_cutoff_date
294: AND dates.seq_num is not null