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;
,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