ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US A30B566296EA7049E0530100007F123E FND Language Code Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code US 24D00B792BF4ED3DE0630100007F3DEFY select fav.application_name application, fnm.message_name, fnm.language_code language, fnm.message_text, fnm.message_number, xxen_util.meaning(fnm.type,'MESSAGE_TYPES',0) type, fnm.max_length, fnm.description, xxen_util.meaning(fnm.category,'FND_KBF_CATEGORY',0) alert_category, xxen_util.meaning(fnm.severity,'FND_KBF_SEVERITY',0) alert_severity, xxen_util.meaning(fnm.fnd_log_severity,'FND_LOG_SEVERITY_LEVEL',0) log_severity, xxen_util.user_name(fnm.created_by) created_by, xxen_util.client_time(fnm.creation_date) creation_date, xxen_util.user_name(fnm.last_updated_by) last_updated_by, xxen_util.client_time(fnm.last_update_date) last_update_date from fnd_new_messages fnm, fnd_application_vl fav where 1=1 and fnm.application_id=fav.application_id order by fav.application_name, fnm.message_name, fnm.language_code :Message_Name_like is not null or :Application is not null or :Message_Text_contains is not null or :Language_Code is not null US FND Messages Enginatics 1=1 1 10 1=1 lower(fnm.message_text) like '%'||:message_text_contains||'%' Char US Message Text contains 2 20 1=1 upper(fnm.message_name) like upper(:message_name_like) LOV custom Y select fnm.message_name value, fav.application_name description from fnd_new_messages fnm, fnd_application_vl fav where fnm.language_code=xxen_util.base_language and fnm.application_id=fav.application_id order by fav.application_name, fnm.message_name US Message Name like 3 30 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 4 40 1=1 fnm.language_code=:language_code LOV FND Language Code A30B566296EA7049E0530100007F123E Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code userenv('lang') US Language Code