ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 17D7AF6F75E41CC4E0630100007F9173Y select fav.application_name application, aa.alert_name, aa.sql_statement_text, aa.description, xxen_util.yes(aa.enabled_flag) enabled, xxen_util.meaning(aa.alert_condition_type,'ALERT_CONDITION_TYPE',0) alert_condition_type, case when aa.frequency_type='C' and aa.days_between_checks=1 then 'Every Day' when aa.frequency_type='C' and aa.days_between_checks=2 then 'Every Other Day' when aa.frequency_type='B' and aa.days_between_checks=1 then 'Every Business Day' else decode(aa.frequency_type, 'O','On Demand', 'M','On Day of the Month', 'W','On Day of the Week', 'C','Every N Calendar Days', 'B','Every N Business Days', 'B','Every N Business Days', aa.frequency_type ) end frequency, coalesce(to_char(aa.monthly_check_day_num), xxen_util.meaning(aa.weekly_check_day,'BIS_WEEK_DAYS',3), to_char(aa.days_between_checks)) days, aa.check_start_time, aa.check_end_time, aa.seconds_between_checks, fav2.application_name table_application, aa.table_name, xxen_util.meaning(aa.insert_flag,'YES_NO',0) after_insert, xxen_util.meaning(aa.update_flag,'YES_NO',0) after_update, aa.maintain_history_days keep_history_days, aa.start_date_active, aa.end_date_active, aa.date_last_checked, xxen_util.user_name(aa.created_by) created_by, xxen_util.client_time(aa.creation_date) creation_date, xxen_util.user_name(aa.last_updated_by) last_updated_by, xxen_util.client_time(aa.last_update_date) last_update_date, &action_columns aa.application_id, aa.alert_id from alr_alerts aa, fnd_application_vl fav, fnd_application_vl fav2, (select aav.* from alr_actions_v aav where '&show_actions'='Y' and sysdate<=nvl(aav.end_date_active,sysdate) and aav.enabled_flag='Y') aav where 1=1 and aa.application_id=fav.application_id and aa.table_application_id=fav2.application_id(+) and aa.application_id=aav.application_id(+) and aa.alert_id=aav.alert_id(+) order by aa.alert_name, aav.name US ALR Alerts Enginatics &action_columns &show_actions 1=1 1 10 1=1 lower(aa.alert_name) like lower(:alert_name) Char US Alert Name like 2 20 1=1 aa.alert_condition_type=:alert_condition_type LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ALERT_CONDITION_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.lookup_code US Condition Type 3 30 1=1 aa.creation_date>=:creation_date_from Date US Creation Date From 4 100 &show_actions Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Action Columns 5 &action_columns aav.name action_name, aav.description action_description, decode(aav.action_level_type,'D','Detail','N','No Exception','S','Summary') action_level, decode(aav.action_type,'C','Concurrent Program','M','Message','O','Operating System Script','S','SQL Statement Script') action_type, aav.to_recipients, aav.subject, aav.cc_recipients, decode(aav.action_type,'M',aav.msg_body,'S',aav.sql_body,'O',aav.os_body) body, aav.cnc_program_application, (select fcpv.user_concurrent_program_name from fnd_concurrent_programs_vl fcpv where aav.program_application_id=fcpv.application_id and aav.concurrent_program_id=fcpv.concurrent_program_id) program_name, aav.cnc_argument_string, xxen_util.user_name(aav.created_by) action_created_by, xxen_util.client_time(aav.creation_date) action_creation_date, xxen_util.user_name(aav.last_updated_by) action_last_updated_by, xxen_util.client_time(aav.last_update_date) action_last_update_date, US Show Action Columns