The following query finds all enabled custom alerts. You can comment out the very last two lines (alr.enabled_flag and alr.created_by) to display all both enabled and disabled alerts.
-------------------------------------------------------------------------------
-- Query to find Custom Oracle Alert
-------------------------------------------------------------------------------
SELECT alr.application_id,
alr.alert_id,
alr.alert_name,
alr.start_date_active,
alr.description,
alr.sql_statement_text
FROM alr.alr_alerts alr
WHERE 1=1
AND alr.created_by <> 1 -- show only custom alerts
AND alr.enabled_flag = 'Y'; -- show only enabled alerts
Ur's
AmarAlam
-------------------------------------------------------------------------------
-- Query to find Custom Oracle Alert
-------------------------------------------------------------------------------
SELECT alr.application_id,
alr.alert_id,
alr.alert_name,
alr.start_date_active,
alr.description,
alr.sql_statement_text
FROM alr.alr_alerts alr
WHERE 1=1
AND alr.created_by <> 1 -- show only custom alerts
AND alr.enabled_flag = 'Y'; -- show only enabled alerts
Ur's
AmarAlam
3 comments:
www.oracleonlinetraining.com is providing Oracle APPS Functional and Technical
training contact us:+91-9533456356, by real time experts in USA,UK,Canada,
Australia.Oracle apps finance online training,oracle Apps SCM online
training,Oracle apps technical online training,oracle Apps 11g online
training,Oracle apps manufacturing training,Oracle Apps Supply Chain Management training
full course details please visit our website http://oracleonlinetraining.com/
Information was good,i like your post.Looking forward for more on this topic.
Oracle Apps Finance training in bangalore
Post a Comment