This document was uploaded by user and they confirmed that they have the permission to share
it. If you are author or own the copyright of this book, please report to us by using this DMCA
report form. Report DMCA
Overview
Download & View Business Event And Subscription Query.txt as PDF for free.
Query to find business events and it's subscription select we.name ,we.status event_status ,wes.status subscription_status ,nvl(wes.phase,0) subscription_phase ,wes.licensed_flag subscription_licensed_flag ,we.licensed_flag event_licensed_flag ,wes.rule_function from wf_events we ,wf_event_subscriptions wes where we.name like 'oracle.apps.fnd.%' and wes.event_filter_guid = we.guid;