Oracle Apps Knowledge Sharing

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;