Wednesday, March 27, 2013

Alert Tables



SELECT alert_name,
       description,
       start_date_active,
       DECODE (alert_condition_type,  'P', 'Periodic',  'E', 'Event')
          ALERT_TYPE,
       frequency_type,
       insert_flag,
       update_flag
  FROM APPS.alr_alerts
 WHERE     enabled_flag = 'Y'
       AND end_date_active IS NULL
       AND alert_name LIKE 'AA%'
     
SELECT *
  FROM apps.ALR_ACTIONS_V
 WHERE subject LIKE 'XX%Notification%'

5 comments:

  1. Thanks for an concept, you sparked at thought from a angle I hadn't given thoguht to yet. Now lets see if I can do one thing with it.
    Having just been searching forwell written articles for the research project Ive been working on when I happened to find yours. Thanks for this informative content!

    http://sitctraining.com/

    ReplyDelete
  2. It was fantastic posts are display in this blog and the nice services are display in this blog. I am really very happy for the great services in this blog and the providing the lot of job openings in this blog. Great posts are display in this blog that to using the amazing services in this blog. Thanks a lot for providing the fantastic info is visible in this blog.


    Oracle Apps Functional Online Training

    ReplyDelete
  3. Thank you for posting this blog i, in fact, cherished it and located up some precise blogs about oracle........go to our net internet page related to oracle fusion procurement training
    thank regards
    oracle fusion procurement online training
    oracle fusion procurement training

    ReplyDelete
  4. Oracle fusion Financials Training from CALFRE.COM gives you the best results to learn your dream course and maintains
    sufficient knowledge on oracle. It provides training by self-paced videos which are very helpful for
    the users to watch at any time according to their schedule. It is globally accepted and having many users undergoing
    training every day.



    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad

    ReplyDelete

Note: Only a member of this blog may post a comment.