Query to check vacation rule in oracle apps

Query to check vacation rule in oracle apps


SELECT
  wfrr.rule_id,
  wfrr.message_type,
  wfrr.message_name,
  wfrr.begin_date,
  wfrr.end_date,
  wfrr.action,
  wfrr.action_argument,
  witv.display_name ,
  wfmv.display_name,
  wfmv.subject,
  wfl.meaning ,
  witv.name,
  wfmv.TYPE,
  wfmv.name ,
  wfl.lookup_type,
  wfl.lookup_code
FROM
  apps.wf_routing_rules wfrr,
  apps.wf_item_types_vl witv,
  apps.wf_messages_vl wfmv,
  apps.wf_lookups wfl
WHERE 1=1
AND wfrr.message_type    = witv.name (+)
AND wfrr.message_type  = wfmv.TYPE (+)
AND wfrr.message_name  = wfmv.name (+)
AND wfrr.action        = wfl.lookup_code
AND wfl.lookup_type    = 'WFSTD_ROUTING_ACTIONS'
AND wfrr.end_date     IS NULL
AND wfrr.message_type IN ('POAPPRV','REQAPPRV','APINV','APEXP','APCCARD')
  --and wfrr.action_argument in ('JCENA','MCGEY')
ORDER BY  begin_date;