INFO: Oracle Workflow APIs

Details for some of Oracle Workflow APIs are... 

1 WF_ENGINE
2 WF_CORE
3 WF_PURGE
4 WF_DIRECTORY
5 WF_PREF
6 WF_MONITOR

Query : to find the process in Workflow using a known function name or Activity name

select 
wat1.display_name "process name",wat.display_name "activity name",wa.function "function" 
from wf_process_activities wpa
,wf_activities_tl wat
,wf_activities_tl wat1
,wf_activities wa