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_RESOURCE_CHANGES

Line 157: bom_resource_changes reschanges,

153: changes.shift_num,
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

Line 286: FROM bom_resource_changes changes

282: AND nvl(dept_ins.serial_number,-1) = nvl(arg_serial_num, -1)
283: AND param.organization_id = arg_organization_id
284: AND NOT EXISTS
285: (SELECT NULL
286: FROM bom_resource_changes changes
287: WHERE changes.department_id = dept_res1.department_id
288: AND changes.resource_id = dept_res1.resource_id
289: AND changes.simulation_set = arg_simulation_set
290: AND changes.shift_num = dates.shift_num