Sunday, 28 August 2016

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;

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




28 comments:

  1. Thanks, this is very useful!

    ReplyDelete
  2. “I could not have closed on my first home without Mr, Benjamin Lee ! Benjamin and his team went above and beyond for me on this transaction. He handled my very tight turn around time with ease and was always available for me when I had questions (and I had plenty), even when he was away from the office, which I greatly appreciated! He and his team handled many last-minute scrambles with the seller and worked tirelessly to make sure that I could close before my lease (and my down payment assistance, for that matter) expired. Mr Benjamin is incredibly knowledgeable Loan Officer, courteous, and patient. I went through a couple offers on properties before my final purchase and Benjamin was there to help with each one, often coordinating with my agent behind the scenes. I felt supported throughout the entire process. Thanks to Benjamin and the tireless efforts of his team, I am now a proud home owner! I would encourage you to consider Benjamin Briel Lee for any kind of loan.Mr, Benjamin Lee Contact informaions.via WhatsApp +1-989-394-3740  Email- 247officedept@gmail.com.

    ReplyDelete
  3. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. visit the website

    ReplyDelete
  4. Need a Debt Loan To Pay Off Bills?
    Take control of your debt today
    Available Now Business Expansion Loan Offer?
    Do you need a loan to pay off Bills?
    Do you need a loan?
    Do you need Personal Loan?
    Business Expansion Loan?
    Business Start-up, Education,
    Debt Consolidation Loan
    Hard Money Loans
    Loan for any thing ?
    We offer loan at low interest rate of 3%
    Loan with no credit check,
    Email us: financialserviceoffer876@gmail.com
    Call or add us on what's app +918929509036

    ReplyDelete
  5. Below you will understand what is important, the idea provides one of the links with an exciting site: check this website

    ReplyDelete
  6. Cool you inscribe, the info is really salubrious further fascinating, I'll give you a connect to my scene. CBT Mass Email Sender for Bulk Email Blasts

    ReplyDelete
  7. If more people that write articles really concerned themselves with writing great content like you, more readers would be interested in their writings. Thank you for caring about your content. Boutique Locale

    ReplyDelete
  8. This is a great article thanks for sharing this informative information. I will visit your blog regularly for some latest post. I will visit your blog regularly for Some latest post. store name ideas

    ReplyDelete
  9. An interesting dialogue is price comment. I feel that it is best to write more on this matter, it may not be a taboo topic however usually individuals are not enough to talk on such topics. To the next. Cheers. organization name

    ReplyDelete
  10. check and book a business event with only the best check activities of your Spouse while away

    ReplyDelete
  11. The world is full of businesses but do you know how important they are? You know there are very big ones like Apple, BP and Amazon and very small ones like your local shop or window-cleaner. Grandad explains how all these businesses contribute to our daily life as importantly as the air we breathe and the food we eat. Without businesses he believes we would still be living in caves or mud huts, we would spend all our time searching for food and water. There would be no schools, no doctors, no police, no government,no cars, no television, nearly nothing, This is one of a series of articles aimed by Grandad at grandchildren everywhere. Grandad has learned many things over his lifetime in work from home business. These articles can give you a flying start in life.

    ReplyDelete
  12. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. website

    ReplyDelete
  13. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!THANKS!!!!!! cool companies names

    ReplyDelete
  14. It's late finding this act. At least, it's a thing to be familiar with that there are such events exist. I agree with your Blog and I will be back to inspect it more in the future so please keep up your act. business insider

    ReplyDelete
  15. I am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you. domain name for a company

    ReplyDelete
  16. I like this piece. I handle You put a strong heap of fight to attract this story. I respect your cycle. check this

    ReplyDelete
  17. You delivered such an impressive piece to read, giving every subject enlightenment for us to gain information. Thanks for sharing such information with us due to which my several concepts have been cleared. name for my company

    ReplyDelete
  18. I am incapable of reading articles online very often, but I’m happy I did today. It is very well written, and your points are well-expressed. I request you warmly, please, don’t ever stop writing. shoes brand names

    ReplyDelete
  19. I really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot! UAE Company Formation

    ReplyDelete
  20. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Baraka Nuclear

    ReplyDelete
  21. i was just browsing along and came upon your blog. just wanted to say good blog and this article really helped me. unique business names

    ReplyDelete
  22. i was just browsing along and came upon your blog. just wanted to say good blog and this article really helped me. creative business name

    ReplyDelete
  23. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends. short business names

    ReplyDelete
  24. Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. company name ideas

    ReplyDelete
  25. Worldwide Bad csgo skins is one of typically the most popular esports titles, captivating countless people and fans worldwide. As well as the extreme aggressive gameplay, CS:GO has given increase to a growing betting scene. Numerous CS:GO betting internet sites have appeared, giving fans the ability to wager on their favorite clubs and players. This article explores the planet of CS:GO betting internet sites, discussing their functions, regulations, and the significance of responsible gambling.

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...