Query to check Business Event and its Subscription details from Backend

Kindly enter Business event name in below query to get details for business event and its subscriptions.

=====================================================

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 'xxcust.oracle.apps.cust.testBusinessEvent'
  and wes.event_filter_guid = we.guid;

=====================================================

Comments

Post a Comment

Popular posts from this blog

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Image
PHP, javascript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. javascript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained mini books cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, javascript, PHP with templates, and web applications.
Read more

3 Best Applications that Organize your Chat and Messaging Accounts

Image
Vast of Instant Messaging (IM) platforms are made available in the internet nowadays. It helps every users to easily exchange messages, multimedia or even real-time virtual interaction with each other through computers and other portable devices. These mode of communication are somewhat important for everyone in this modern society and this applications plays a very essential and effective role in our daily living. Some of us are just busy interacting with people in such a way of bringing everyone closer, business matters, family, friends and others. Facebook Messenger, WeChat, Skype, Google Hangouts and Slack are just a few to mention of this platforms, it offers similar services but with quite different features. One has to sign up with these IM applications to start communicating and most of this services are being offered free. As of these days, people do have multiple accounts in different platforms, interacting people from different sides for different matters. As for me, I ...
Read more

Japan Style: Architecture Interiors Design

Image
Enter the world of the stylish Japanese house, where every object in sight is a work of art. Japan Style introduces 20 special residences. With more than 200 color photographs, this book showcases the stunning beauty of old homes, and reveals how they are cared for by their owners. Traditional Japanese homes, with superbly crafted fine wood, great workmanship and seasonal interior arrangements, have an aesthetic of infinite simplicity. Unlike Japanese inns and historical buildings, the houses featured in this book are private property and are not open to public viewing. Japan Style offers a rare glimpse into the intimate world of the everyday Japanese and fascinating insight into the traditional architecture of Japan download link http://libgen.io/_ads/E7F3D5D3E376CB1E116D00AFC8E89AC4 .
Read more