Showing posts with label Workflow. Show all posts
Showing posts with label Workflow. Show all posts

Saturday, May 17, 2014

Oracle Workflow Important Tables

Workflow Tables


--Two classification of tables
--Definition and Setup
--if we have item key it is instance specific

SELECT * FROM wf_item_types WHERE NAME = 'XXKSRBWF';
SELECT * FROM wf_items;  -- will have item type and item key (instance table)

select * from wf_item_attributes;
SELECT * FROM wf_item_attribute_values;

SELECT * FROM wf_Activities;
SELECT * FROM wf_notifications;  --message type is same as item type in this table

SELECT * FROM wf_Resources;
select * from wf_process_Activities; --process_item_type is same as item_type