Query : To get the list of Custom Alerts

SELECT aa.alert_name, 
aa.creation_date, 
aa.last_update_date,
aa.alert_condition_type, 

aa.enabled_flag, 
aa.start_date_active,
aa.end_date_active, 
aa.description, 
aa.date_last_checked,
aa.maintain_history_days, 
aa.table_name, 
aa.sql_statement_text,
fa.application_name
FROM alr_alerts aa, fnd_application_tl fa
WHERE aa.alert_name LIKE 'XXA%' 
AND aa.application_id = fa.application_id