Wednesday 24 August 2022

Query to find package name from business event

select w_even.name
  ,w_even.status event_status
  ,w_e_subs.status subscription_status
  ,nvl(w_e_subs.phase,0) subscription_phase
  ,w_e_subs.rule_function
from wf_events w_even
  ,wf_event_subscriptions w_e_subs
where
  w_even.name like '%oracle.apps.ont%' -- Business Event name
  and w_e_subs.event_filter_guid = w_even.guid;

No comments:

Post a Comment