DBA Data[Home] [Help]

APPS.WPS_RES_INSTANCE_AVAILABILITY dependencies on MTL_PARAMETERS

Line 158: mtl_parameters param

154: reschanges.capacity_change
155: from bom_shift_dates dates,
156: bom_res_instance_changes changes,
157: bom_resource_changes reschanges,
158: mtl_parameters param
159: WHERE dates.calendar_code = param.calendar_code
160: AND dates.exception_set_id = param.calendar_exception_set_id
161: AND dates.seq_num is not null
162: AND dates.shift_date between changes.from_date AND

Line 264: mtl_parameters param

260: bom_shift_times shifts,
261: bom_resource_shifts res_shifts,
262: bom_department_resources dept_res1,
263: bom_dept_res_instances dept_ins,
264: mtl_parameters param
265: WHERE dates.calendar_code = param.calendar_code
266: AND dates.exception_set_id = param.calendar_exception_set_id
267: AND dates.shift_num = shifts.shift_num
268: AND dates.seq_num is not null

Line 340: mtl_parameters param

336: var_gt_user_id
337: FROM bom_calendar_dates dates,
338: bom_department_resources dept_res1,
339: bom_dept_res_instances dept_ins,
340: mtl_parameters param
341: WHERE dates.calendar_code = param.calendar_code
342: AND dates.exception_set_id = param.calendar_exception_set_id
343: AND dates.calendar_date <= arg_cutoff_date
344: AND dates.seq_num is not null