Oracle Workflow Queries

Workflow Definition

--Workflow Item Type的定义信息
select * from wf_item_types where name = 'TPLEAVE'
select * from wf_item_types_tl where name = 'TPLEAVE'

--工作流里各个节点信息
select * from wf_activities where item_type = 'TPLEAVE';
--End_Date没数据的那个版本，为当前有效版本
--Version有多个，是因为你UPLOAD了多次，每次UPLOAD都会新增一个版本
--Function的节点，那么Function中就会有对应的package.procedure的内容，比如ptleave.find_approver
--Function节点，可能还会涉及到Result_Type字段

--Message
select * from wf_messages where type = 'TPLEAVE';
select * from wf_messages_tl where type = 'TPLEAVE';

--Lookup Type
select * from wf_lookup_types_tl where lookup_type like 'OKNO';
--Lookup Code
select * from wf_lookups_tl where lookup_type like 'OKNO';

--Attributes
--Item Type Level Attributes
select *