Loading

Wednesday, January 25, 2017

Query to fetch Workflow Vocation Rules in Oracle Apps R12












Below query will help you to get the vocation rules setup in the system.

SELECT wfr.rule_id,
       wfr.message_type,
       wfr.message_name,
       wfr.begin_date,
       wfr.end_date,
       wfr.action,
       wfr.role,
       wfr.action_argument,
       wfiy.display_name as type_display,
       wm.display_name as msg_display,
       wm.subject,
       wl.meaning as action_display,
       wfiy.name,
       wm.type,
       wm.name as name1,
       wl.lookup_type,
       wl.lookup_code
  FROM wf_routing_rules wfr,
       wf_item_types_vl wfiy,
       wf_messages_vl   wm,
       wf_lookups       wl
 WHERE wfr.role = '&USERNAME'
   AND wfr.message_type = wfiy.name(+)
   AND wfr.message_type = wm.type(+)
   AND wfr.message_name = wm.name(+)
   AND wfr.action = wl.lookup_code
   AND wl.lookup_type = 'WFSTD_ROUTING_ACTIONS'
 ORDER BY type_display, msg_display, begin_date;
 
 

0 Responses to “Query to fetch Workflow Vocation Rules in Oracle Apps R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.