Index: openacs-4/packages/notifications/www/manage-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/www/manage-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/notifications/www/manage-oracle.xql	20 Sep 2002 21:19:01 -0000	1.1
+++ openacs-4/packages/notifications/www/manage-oracle.xql	11 Dec 2002 02:13:28 -0000	1.1.2.1
@@ -10,21 +10,7 @@
 	   from notification_types
 	   where notification_types.type_id =
 	         notification_requests.type_id) as type, 
-	decode ((select short_name 
-	           from notification_types 
-                   where notification_types.type_id = 
-                         notification_requests.type_id), 
-                  'forums_forum_notif',  
-                   (select name 
-	            from forums_forums 
-		    where forum_id = 
-                    notification_requests.object_id),
-                   'forums_message_notif',
-                    (select subject 
-                     from forums_messages 
-                     where message_id = 
-                     notification_requests.object_id),  
-                   '') as object_name,
+	   acs_object.name(notification_requests.object_id) as object_name,
 	   (select name
 	   from notification_intervals
 	   where notification_intervals.interval_id =