select r.role_key, r.role_name, '' as assignment_widget from wf_tasks t, wf_transition_role_assign_map tram, wf_roles r where t.task_id = :task_id and tram.workflow_key = t.workflow_key and tram.transition_key = t.transition_key and r.workflow_key = tram.workflow_key and r.role_key = tram.assign_role_key order by r.sort_order select tp.header, tp.template_url from wf_context_task_panels tp, wf_cases c, wf_tasks t where t.task_id = :task_id and c.case_id = t.case_id and tp.context_key = c.context_key and tp.workflow_key = c.workflow_key and tp.transition_key = t.transition_key and tp.overrides_action_p = 't' and (tp.only_display_when_started_p = 'f' or (t.state = 'started' and t.holding_user = :user_id)) order by tp.overrides_action_p, tp.sort_order select tp.header, tp.template_url from wf_context_task_panels tp, wf_cases c, wf_tasks t where t.task_id = :task_id and c.case_id = t.case_id and tp.context_key = c.context_key and tp.workflow_key = c.workflow_key and tp.transition_key = t.transition_key and (tp.only_display_when_started_p = 'f' or (t.state = 'started' and t.holding_user = :user_id)) order by tp.overrides_action_p, tp.sort_order select count(*) from wf_user_tasks where task_id = :task_id and user_id = :user_id select a.attribute_name as name, a.pretty_name, a.datatype, v.attr_value as value from wf_attribute_value_audit v, acs_attributes a where v.journal_id = :journal_id and a.attribute_id = v.attribute_id select t.pretty_name, w.description from wf_workflows w, acs_object_types t where w.workflow_key = :workflow_key and t.object_type = w.workflow_key select transition_key, transition_name, sort_order from wf_transitions where workflow_key = :workflow_key and trigger_type = 'user' order by sort_order asc select a.attribute_name as name, a.pretty_name, a.datatype, v.attr_value as value from wf_attribute_value_audit v, acs_attributes a where v.journal_id = :journal_id and a.attribute_id = v.attribute_id select case_id from wf_tasks where task_id = :task_id select place_key from wf_places where workflow_key = :workflow_key select role_key from wf_roles where workflow_key = :workflow_key select transition_key from wf_transitions where workflow_key = :workflow_key insert into wf_context_transition_info (context_key, workflow_key, transition_key, estimated_minutes, instructions) values (:context_key, :workflow_key, :transition_key, :estimated_minutes, :instructions) select wf.description, ot.pretty_name, ot.pretty_plural, ot.table_name from wf_workflows wf, acs_object_types ot where wf.workflow_key = :workflow_key and ot.object_type = wf.workflow_key select place_key, place_name, sort_order from wf_places where workflow_key = :workflow_key order by sort_order asc select role_key, role_name, sort_order from wf_roles where workflow_key = :workflow_key select transition_key, transition_name, sort_order from wf_transitions where workflow_key = :workflow_key and trigger_type = 'user' order by sort_order asc select transition_key, place_key, direction, guard_callback, guard_custom_arg, guard_description from wf_arcs where workflow_key = :workflow_key order by transition_key asc select a.attribute_name as name, a.pretty_name, a.datatype, v.attr_value as value from wf_attribute_value_audit v, acs_attributes a where v.journal_id = :journal_id and a.attribute_id = v.attribute_id select transition_key, sort_order from wf_transition_attribute_map where workflow_key = :workflow_key and attribute_id = :attribute_id select transition_key, assign_role_key from wf_transition_role_assign_map where workflow_key = :workflow_key order by transition_key select transition_key, estimated_minutes, instructions, enable_callback, enable_custom_arg, fire_callback, fire_custom_arg, time_callback, time_custom_arg, deadline_callback, deadline_custom_arg, deadline_attribute_name, hold_timeout_callback, hold_timeout_custom_arg, notification_callback, notification_custom_arg, unassigned_callback, unassigned_custom_arg from wf_context_transition_info where workflow_key = :workflow_key and context_key = :context_key select role_key, assignment_callback, assignment_custom_arg from wf_context_role_info where workflow_key = :workflow_key and context_key = :context_key select transition_key, sort_order, header, template_url, overrides_action_p, only_display_when_started_p from wf_context_task_panels where context_key = :context_key and workflow_key = :workflow_key order by transition_key asc, sort_order asc