Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-oracle.xql	25 Apr 2001 04:52:44 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-oracle.xql	19 Nov 2001 18:27:40 -0000	1.2
@@ -1,10 +1,11 @@
 <?xml version="1.0"?>
+
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="journal_select">      
       <querytext>
-
+      
     select j.journal_id,
            j.action,
            j.action_pretty,
@@ -18,16 +19,14 @@
            a.attribute_name as attribute_name, 
 	   a.pretty_name as attribute_pretty_name,
 	   a.datatype as attribute_datatype, 
-	   ai.wf_datatype as attribute_wf_datatype,
 	   v.attr_value as attribute_value
     from   journal_entries j, acs_objects o, parties p,
-           wf_attribute_value_audit v, acs_attributes a, wf_attribute_info ai
+           wf_attribute_value_audit v, acs_attributes a
     where  j.object_id = :case_id
       and  o.object_id = j.journal_id
       and  p.party_id (+) =  o.creation_user
       and  v.journal_id (+) = j.journal_id
       and  a.attribute_id (+) = v.attribute_id
-      and  ai.attribute_id (+) = v.attribute_id
     order  by o.creation_date $sql_order, j.journal_id $sql_order
 
       </querytext>