Alert tables in oracle apps

Hi friends, we are going to discuss about the Alert tables in oracle apps. We will share the detail list of the oracle alert tables in oracle apps. These alert tables helps to store the complete alert details in oracle apps. We can get the complete alert registration informations using these tables. Using these alert tables we can develop the custom reports about the alert details. In this post , We are sharing one of the important alert tables in oracle apps. Please find below the complete detail about Alert tables in oracle apps.

Alert tables in oracle apps

7 Most Important Alert Tables in Oracle Apps

1.ALR_ALERTS

2.ALR_ALERTS

3.ALE_LOOKUPS

4.ALR_ACTION_HISTORY

5.ALR_OUTPUT_HISTORY

6.ALR_ACTIONS_V

7.ALR_ALERT_HISTORY_VIEW

Detail SQL Query using Alert tables in oracle apps

Query 1:-

SELECT ALR_ACT .name,

ALR_ACT.description,

ALR_ACT.action_type,

ALR_ACT.action_level_type,

ALR_ACT.subject ,

ALR_ACT.msg_body

FROM 

ALR_ALERTS AL ,

ALR_ACTION_HISTORY AAH ,

ALR_OUTPUT_HISTORY AOH , 

ALR_ACTIONS_V ALR_ACT, 

ALR_ALERT_HISTORY_VIEW ALR_ACT_HIS 

WHERE AL.ALERT_NAME LIKE 'XX%'

AND AAH .CHECK_ID = AOH.CHECK_ID

AND ALR_ACT .ALERT_ID = AAH.ALERT_ID 

AND ALR_ACT_HIS.ALERT_NAME = AL.ALERT_NAME

AND AL.ALERT_ID = AAH.ALERT_ID

Query 2:-

SELECT alr.alert_name,

alr.start_date_active "Alert Start Date", al.meaning "Alert Frequency Type",

DECODE (frequency_type,

'B', days_between_checks,

'W', weekly_check_day,

'M', monthly_check_day_num,

'C', days_between_checks,

NULL

) "Days",

alr_act.subject "Alert Subject" ,

alr_act.msg_body "Alert Message Body",

alr_act.to_recipients "Alert To Address",

alr_act.cc_recipients "Alert CC Address",

alr_act.bcc_recipients "Alert BCC Address"

FROM alr_actions_v alr_act,

alr_alerts alr, 

alr_lookups al

WHERE 1 = 1

AND alr_act.alert_id = alr.alert_id

AND alr.enabled_flag = 'Y'

AND alr.frequency_type = al.lookup_code

AND al.lookup_type = 'ALERT_FREQUENCY_TYPE'

Alert tables in oracle apps