Index: openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	22 Sep 2003 14:33:40 -0000	1.2
+++ openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	11 Dec 2003 21:39:53 -0000	1.3
@@ -21,6 +21,8 @@
     and    lm2.locale (+) = :locale
     and    lm2.message_key (+) = lmk.message_key
     and    lm2.package_key (+) = lmk.package_key
+    and    (lm2.deleted_p = 'f' or lm2.deleted_p is null)
+    and    lm1.deleted_p = 'f'
     $where_clause
     order  by upper(lm1.message_key), lm1.message_key