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

Line 136: from mtl_serial_numbers

132: if (l_rebuildSerNum is NOT NULL and
133: l_rebuildItemID is NOT NULL) then
134: select current_status
135: into l_serial_status
136: from mtl_serial_numbers
137: where serial_number = l_rebuildSerNum
138: and current_organization_id= l_orgID
139: and inventory_item_id = l_rebuildItemID;
140: end if;

Line 203: mtl_serial_numbers msn,

199: meaa.owning_department_id,
200: tagging_required_flag,
201: to_number(shutdown_type_code) as shutdown_type_code
202: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
203: mtl_serial_numbers msn,
204: mtl_system_items msi,
205: mtl_eam_asset_activities meaa
206: WHERE transaction_temp_id = p_tempId
207: and mmtt.rebuild_activity_id = msi.inventory_item_id (+)

Line 268: from mtl_serial_numbers

264: --find maintenance object type,id,source
265: if (l_workorder.rebuild_item_id is not null and l_workorder.rebuild_serial_number is not null) then
266: BEGIN
267: select gen_object_id into l_maintenance_object_id
268: from mtl_serial_numbers
269: where inventory_item_id = l_workorder.rebuild_item_id and serial_number = l_workorder.rebuild_serial_number and current_organization_id =l_workorder.organization_id;
270: l_maintenance_object_type := 1;
271: EXCEPTION
272: WHEN NO_DATA_FOUND THEN