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

14 comments:

  1. It’s amazing in support of me to truly have a blog site, which will be valuable meant for my knowledge. Thanks admin. PARALLEL PROFITS STEVE CLAYTON

    ReplyDelete
  2. Wow! This is the perfect blog I am looking this type of blog its awesome blog here , share great information about this topic. This informative blog helps many readers with their decision-making regarding the situation. Great articles and will look forward for more!
    architect nijmegen

    ReplyDelete
  3. Enthusiastic beginning is very common in every sector when anyone enters into a new world. But it is very hard to keep such enthusiasm for a long time after huddles come out from invited sources. Read this blog and know more about this topic.hulp bij belastingaangifte amsterdam

    ReplyDelete
  4. Gracefully written information on this blog are going to support me for my coming assignments. Every point was very clear and taught me few new parameters. I would like to use this information in coming future.bioresonantie enschede

    ReplyDelete
  5. On my website you'll see similar texts, write what you think. bb13 colors tv

    ReplyDelete
  6. What's more, PMP accreditation of the PM is required by numerous businesses and they won't contract individuals who don't have PM confirmation. ExcelR PMP Certification

    ReplyDelete
  7. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Searching PPSR

    ReplyDelete
  8. Meet Joey Ticket, the lowest fee guarantee for mobile vouchers! This mobile voucher can be purchased with your mobile phone or with a credit card.  소액결제현금화

    ReplyDelete
  9. I like this post,And I figure that they having a great time to peruse this post,they might take a decent site to make an information,thanks for sharing it to me. make money online

    ReplyDelete
  10. I’d forever want to be update on new posts on this website , saved to favorites ! . stage lighting rental in Orlando

    ReplyDelete
  11. educational paper writing want to be a hundred% precise and grammatical errors free as purchaser always appears for a professional writer who can help with superb writing issuer and can show expertise thru their writing talent. concept of author is notably preferred. shack tv

    ReplyDelete
  12. What a fantabulous post this has been. Never observed this sort of valuable post.
    https://thelostwaysreview.eubookshop.com/

    ReplyDelete
  13. Your post is providing some really good information. I liked its essence and enjoyed reading it. Keep sharing such important posts about this blog and its much more helpful for us .
    Nirav Gandhi Amar Gandhi

    ReplyDelete
  14. Interesting blog post. It was informative. Thanks for sharing...

    accounting firm in dubai

    ReplyDelete