Index: openacs-4/packages/workflow/tcl/case-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/case-procs-oracle.xql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/workflow/tcl/case-procs-oracle.xql 5 Feb 2004 10:37:33 -0000 1.9 +++ openacs-4/packages/workflow/tcl/case-procs-oracle.xql 15 Mar 2004 14:04:06 -0000 1.10 @@ -74,14 +74,14 @@ workflow_actions a, cr_items i, acs_objects io, - cc_users iou, + acs_users_all iou, cr_revisions r, workflow_case_log_data d where l.case_id = :case_id and l.action_id = a.action_id and i.item_id = l.entry_id and io.object_id = i.item_id - and iou.user_id = io.creation_user + and iou.user_id (+) = io.creation_user and r.revision_id = i.live_revision and d.entry_id (+) = l.entry_id order by creation_date