HOW TO find workflows by activity or PLSQL function nameThis is a featured page

Platform: Oracle App: Oracle Applications Tool: Oracle Workflow
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver: 2.6.2
Revision Date: 17-Sep-2006 Keywords: HOWTO, WORKFLOW,FUNCTION,ACTIVITY,FIND

Goal
To find workflows by activity or PLSQL function name

Facts


Solution
In a complicated workflow, where there are many processes within an item type, it can be time consuming to find out which process uses a particular activity or function; you can use the script below to help you find out.

If you have a PLSQL package and you want to know which workflow, process and activity calls a particular function you can use the script below to find out.

SELECT
atlp.display_name process_display_name
,atl.display_name activity_display_name
,a.FUNCTION
,w.*
FROM
wf_process_activities w
,wf_activities a
,wf_activities_tl atl
,wf_activities_tl atlp
WHERE 1=1
AND (UPPER(a.FUNCTION) LIKE '%'||UPPER('&FunctionName')||'%'
OR (a.FUNCTION IS NULL AND '&FunctionName'='%')
)
AND w.activity_item_type = a.item_type
AND w.instance_label = a.NAME
AND a.NAME LIKE '%&ActivityName%'
AND atl.NAME = a.NAME
AND atl.item_type = a.item_type
AND atl.VERSION = a.VERSION
AND atl.LANGUAGE = 'US'
AND atlp.NAME = w.process_name
AND atlp.item_type = atl.item_type
AND atlp.VERSION = atl.VERSION
AND atlp.LANGUAGE = atl.LANGUAGE
AND atlp.VERSION = w.process_version
ORDER BY 1,2
/



consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 6:45 AM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: ACTIVITY FIND FUNCTION HOWTO WORKFLOW
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.