ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to find the list of users with Vacation Rules enabled in Orace Apps

How to find the list of users with Vacation Rules enabled in Orace Apps

原创 Linux操作系统 作者:palmfuu 时间:2011-07-22 19:51:33 0 删除 编辑

Here is the code snippet for querying the list of users who have vacation rules enabled.

SELECT routingruleseo.rule_id,
       routingruleseo.MESSAGE_TYPE,
       routingruleseo.message_name,
       routingruleseo.begin_date,
       routingruleseo.end_date,
       routingruleseo.action,
       routingruleseo.role from_user,
       routingruleseo.action_argument to_user,
       itemtypeseo.display_name AS type_display,
       messageseo.display_name AS msg_display,
       messageseo.subject,
       lookupseo.meaning AS action_display,
       itemtypeseo.NAME,
       messageseo.TYPE,
       messageseo.NAME AS name1,
       lookupseo.lookup_type,
       lookupseo.lookup_code
  FROM apps.wf_routing_rules routingruleseo,
       apps.wf_item_types_vl itemtypeseo,
       apps.wf_messages_vl   messageseo,
       apps.wf_lookups       lookupseo
 WHERE routingruleseo.MESSAGE_TYPE = itemtypeseo.NAME(+)
   AND routingruleseo.MESSAGE_TYPE = messageseo.TYPE(+)
   AND routingruleseo.message_name = messageseo.NAME(+)
   AND routingruleseo.action = lookupseo.lookup_code
   AND lookupseo.lookup_type = 'WFSTD_ROUTING_ACTIONS'
 ORDER BY type_display, msg_display/*, begin_date*/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24838271/viewspace-702881/,如需转载,请注明出处,否则将追究法律责任。

下一篇: position hierarchy qry
请登录后发表评论 登录
全部评论

注册时间:2011-07-21

  • 博文量
    5
  • 访问量
    9824