Index: openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	1 Sep 2003 13:43:51 -0000	1.4
+++ openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	28 Sep 2003 01:24:26 -0000	1.5
@@ -1,4 +1,4 @@
--- Data model for the workflow package, part of the OpenACS system.
+>-- Data model for the workflow package, part of the OpenACS system.
 --
 -- @author Lars Pind (lars@collaboraid.biz)
 -- @author Peter Marklund (peter@collaboraid.biz)
@@ -514,3 +514,24 @@
 end;
 /
 show errors
+
+-----------------
+-- Useful views
+-----------------
+
+create or replace view workflow_case_assigned_actions as 
+    select c.workflow_id,
+           c.case_id, 
+           c.object_id,
+           a.action_id, 
+           a.assigned_role as role_id
+    from   workflow_cases c,
+           workflow_case_fsm cfsm,
+           workflow_actions a,
+           workflow_fsm_action_en_in_st aeis
+    where  cfsm.case_id = c.case_id
+    and    a.always_enabled_p = 'f'
+    and    aeis.state_id = cfsm.current_state
+    and    aeis.assigned_p = 't'
+    and    a.action_id = aeis.action_id
+    and    a.assigned_role is not null;
