Index: openacs-4/packages/cms/www/modules/workflow/overdue-items-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/workflow/overdue-items-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/workflow/overdue-items-oracle.xql	19 Nov 2001 18:43:25 -0000	1.2
+++ openacs-4/packages/cms/www/modules/workflow/overdue-items-oracle.xql	19 Nov 2001 20:40:37 -0000	1.3
@@ -7,11 +7,11 @@
       <querytext>
       
   select
-    ca.transition_key, transition_name, ca.party_id, 
+    trans.transition_key, transition_name, ca.party_id, 
     item_id, content_item.get_title(item_id) as title,
     nvl(party.name(ca.party_id),person.name(ca.party_id)) as assigned_party,
     to_char(dead.deadline,'Mon. DD, YYYY') as deadline_pretty,
-    content_workflow.get_status(c.case_id, ca.transition_key) as status
+    content_workflow.get_status(c.case_id, trans.transition_key) as status
   from 
     wf_transitions trans, wf_cases c, wf_case_deadlines dead, 
     wf_case_assignments ca, cr_items i
Index: openacs-4/packages/cms/www/modules/workflow/overdue-items-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/workflow/overdue-items-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/workflow/overdue-items-postgresql.xql	19 Nov 2001 18:43:25 -0000	1.2
+++ openacs-4/packages/cms/www/modules/workflow/overdue-items-postgresql.xql	19 Nov 2001 20:40:37 -0000	1.3
@@ -7,11 +7,11 @@
       <querytext>
       
   select
-    ca.transition_key, transition_name, ca.party_id, 
+    trans.transition_key, transition_name, ca.party_id, 
     item_id, content_item__get_title(item_id,'f') as title,
     coalesce(party__name(ca.party_id),person__name(ca.party_id)) as assigned_party,
     to_char(dead.deadline,'Mon. DD, YYYY') as deadline_pretty,
-    content_workflow__get_status(c.case_id, ca.transition_key) as status
+    content_workflow__get_status(c.case_id, trans.transition_key) as status
   from 
     wf_transitions trans, wf_cases c, wf_case_deadlines dead, 
     wf_case_assignments ca, cr_items i