oracle8.1.6
select
transition_name, party_id,
content_item.get_title(i.item_id) title,
to_char(cd.deadline,'Month DD, YYYY') deadline_pretty,
nvl(party.name(party_id),person.name(party_id)) name
from
wf_transitions t, cr_items i,
wf_cases c, wf_case_assignments ca, wf_case_deadlines cd
where
c.workflow_key = 'publishing_wf'
and
c.workflow_key = t.workflow_key
and
ca.transition_key = t.transition_key
and
ca.transition_key = cd.transition_key
and
c.case_id = ca.case_id
and
c.case_id = cd.case_id
and
c.case_id = :case_id
and
c.state = 'active'
and
c.object_id = i.item_id
begin
:1 := acs_mail_nt.post_request(
party_from => :user_id,
party_to => :party_id,
expand_group => 'f',
subject => :subject,
message => :message
);
end;
select
o.creation_user as admin_id, transition_name, party_id,
content_item.get_title(i.item_id) title,
to_char(deadline,'Month DD, YYYY') deadline_pretty,
nvl(party.name(party_id),person.name(party_id)) name,
nvl(party.name(admin_id),person.name(admin_id)) admin_name
from
wf_cases c, wf_case_assignments ca, wf_case_deadlines cd,
wf_transitions t, cr_items i, acs_objects o
where
c.workflow_key = 'publishing_wf'
and
c.workflow_key = t.workflow_key
and
c.case_id = ca.case_id
and
c.case_id = cd.case_id
and
c.case_id = :case_id
and
ca.transition_key = t.transition_key
and
ca.transition_key = cd.transition_key
and
t.transition_key = :transition_key
and
c.state = 'active'
and
c.object_id = i.item_id
and
c.case_id = o.object_id
begin
:1 := acs_mail_nt.post_request(
party_from => -1,
party_to => :admin_id,
expand_group => 'f',
subject => :subject,
message => :message
);
end;
select person.name( :user_id ) from dual
select
transition_name,
content_item.get_title(i.item_id) as title,
o.creation_user as admin_id,
person.name( o.creation_user ) as admin_name,
to_char(sysdate,'Mon DD, YYYY') as today
from
wf_tasks t, wf_transitions tr, wf_cases c,
cr_items i, acs_objects o
where
tr.transition_key = t.transition_key
and
tr.workflow_key = t.workflow_key
and
t.case_id = c.case_id
and
c.object_id = i.item_id
and
i.item_id = o.object_id
and
t.task_id = :task_id
begin
:1 := acs_mail_nt.post_request(
party_from => -1,
party_to => :admin_id,
expand_group => 'f',
subject => :subject,
message => :message
);
end;
select
content_workflow.can_touch( :item_id, :user_id )
from
dual