eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WPS_RES_INSTANCE_AVAILABILITY dependencies on BOM_DEPT_RES_INSTANCES

Line 263: bom_dept_res_instances dept_ins,

259: FROM bom_shift_dates dates,
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

Line 339: bom_dept_res_instances dept_ins,

335: sysdate,
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