Search from 700 + Posts

Dec 18, 2013

Query to Check if Oracle Business event has Subscription

Query to Check if Oracle Business event has Subscription 

select e.name,e.status event_status,s.status subscription_status ,nvl(s.PHASE,0) SUBSCRIPTION_PHASE
,s.LICENSED_FLAG subscription_LICENSED_FLAG
,e.LICENSED_FLAG event_LICENSED_FLAG
from wf_events e
,WF_EVENT_SUBSCRIPTIONS S
where
e.name like '%Enter_Your_Business_event_name%'
AND S.EVENT_FILTER_GUID = E.GUID

No comments:

Post a Comment