oracle8.1.6
select c.case_id,
c.workflow_id,
c.object_id,
s.state_id,
s.short_name as state_short_name,
s.pretty_name as pretty_state,
s.hide_fields as state_hide_fields
from workflow_cases c,
workflow_case_fsm cfsm,
workflow_fsm_states s
where c.case_id = :case_id
and cfsm.case_id = c.case_id
and cfsm.current_state = s.state_id (+)
and cfsm.parent_enabled_action_id = :parent_enabled_action_id
select c.case_id,
c.workflow_id,
c.object_id,
s.state_id,
s.short_name as state_short_name,
s.pretty_name as pretty_state,
s.hide_fields as state_hide_fields
from workflow_cases c,
workflow_case_fsm cfsm,
workflow_fsm_states s
where c.case_id = :case_id
and cfsm.case_id = c.case_id
and cfsm.current_state = s.state_id (+)
and cfsm.parent_enabled_action_id is null
select m.party_id,
p.email,
acs_object.name(m.party_id) as name
from workflow_case_role_party_map m,
parties p
where m.case_id = :case_id
and m.role_id = :role_id
and p.party_id = m.party_id
select l.entry_id,
l.case_id,
l.action_id,
a.short_name as action_short_name,
a.pretty_past_tense as action_pretty_past_tense,
io.creation_user,
iou.first_names as user_first_names,
iou.last_name as user_last_name,
iou.email as user_email,
io.creation_date,
to_char(io.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
blob_to_string(r.content) as comment_string, -- needs il8-ing...
r.mime_type as comment_mime_type,
d.key,
d.value
from workflow_case_log l,
workflow_actions a,
cr_items i,
acs_objects io,
cc_users 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 r.revision_id = i.live_revision
and d.entry_id (+) = l.entry_id
order by creation_date
select enabled_action_id
from workflow_case_enabled_actions
where execution_time <= sysdate
and completed_p = 'f'
select acs_object.name(:object_id) as name from dual
select distinct acs_object.name(p.party_id) || ' (' || p.email || ')' as label, p.party_id
from [ad_decode $subquery "" "cc_users" $subquery] p
where upper(nvl(acs_object.name(p.party_id) || ' ', '') || p.email) like upper('%'||:value||'%')
order by label
select acs_object.name(p.party_id) || ' (' || p.email || ')' as label, p.party_id
from parties p
where p.party_id in ([join $party_id_list ", "])
order by label
begin
:1 := workflow_case_pkg.del(:case_id);
end;
insert into workflow_case_enabled_actions
(enabled_action_id,
case_id,
action_id,
parent_enabled_action_id,
assigned_p,
execution_time)
select :enabled_action_id,
:case_id,
:action_id,
:parent_enabled_action_id,
:db_assigned_p,
sysdate + a.timeout_seconds/(24*60*60)
from workflow_actions a
where a.action_id = :action_id
select q.*
from (select 1
from workflow_case_enabled_actions ean
where ean.action_id = :action_id
and ean.case_id = :case_id
and completed_p = 'f'
) q
where rownum = 1
select enabled_action_id,
case_id,
action_id,
assigned_p,
completed_p,
parent_enabled_action_id,
to_char(execution_time, 'YYYY-MM-DD HH24:MI:SS') as execution_time_ansi,
nvl((select a2.trigger_type
from workflow_case_enabled_actions e2,
workflow_actions a2
where e2.enabled_action_id = e.parent_enabled_action_id
and a2.action_id = e2.action_id), 'workflow') as parent_trigger_type
from workflow_case_enabled_actions e
where enabled_action_id = :enabled_action_id