Useful Workflow scripts

WF_WORKLIST_V

WF_WORKLIST_V is a view of WF_NOTIFICATIONS that is used to display messages in a work list.

View Definition:

CREATE VIEW WF_WORKLIST_V

AS

Workflow tables/queries in Oracle Apps

WORKFLOW TABLES

SELECT * FROM WF_USER_ROLE_ASSIGNMENTS

SELECT * FROM WF_USER_ROLES

SELECT * FROM WF_ROLES

SELECT * FROM WF_ITEMS