Thursday, June 9, 2022

Query to get list of Custom Alerts in Oracle APPS

SELECT aa.alert_name, aa.creation_date, aa.last_update_date, aa.alert_condition_type, fl.meaning alert_type, aa.enabled_flag, aa.start_date_active, aa.end_date_active, aa.description alert_desc, aa.date_last_checked, aa.maintain_history_days, aa.table_name, aa.sql_statement_text, fat.application_name FROM alr_alerts aa ,fnd_lookups fl ,fnd_application_tl fat WHERE aa.alert_name LIKE 'XX%' AND aa.alert_condition_type = fl.lookup_code AND fl.lookup_type = 'ALERT_CONDITION_TYPE' AND aa.application_id = fat.application_id AND fat.language = USERENV('LANG')

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...