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.EAM_REBUILDS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 116: from mtl_serial_numbers msn, mtl_parameters mp

112: end if;
113: begin
114: select serial_number, current_status, gen_object_id, current_organization_id
115: into l_dummy_char, l_current_status, l_object_id, l_cur_organization_id
116: from mtl_serial_numbers msn, mtl_parameters mp
117: where inventory_item_id = p_rebuild_item_id
118: and current_organization_id = mp.organization_id
119: and mp.maint_organization_id = p_organization_id
120: and serial_number = p_rebuild_serial_number;

Line 136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii

132: if (p_validate_mode <> VALIDATE_ISSUE) then
133:
134:
135: select msn.gen_object_id into l_parent_object_id
136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii
137: where wdj.wip_entity_id = p_wip_entity_id
138: and wdj.maintenance_object_id = cii.instance_id
139: and wdj.maintenance_object_type = 3
140: and cii.serial_number = msn.serial_number