Wednesday, March 27, 2013

Alert Tables

Your Ad Here



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%'
Your Ad Here

5 comments:

  1. very useful really good information thanks for posting such a good information it will hepls the people a lot keep it up , Regards, obiee training in hyderabad

    ReplyDelete
  2. 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
  3. 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