ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 9FD1E69E877F1D9DE0530100007F19D3 DBA Database Link Y select lower(substr(ddl.db_link,1,instr(ddl.db_link,'.')-1)) value, ddl.username||'@'||ddl.host description from dba_db_links ddl order by value 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A660E0B82A82616DE0530100007F1A23 select nvl(flv.lookup_type,flv2.lookup_type) lookup_type, nvl(flv.lookup_code,flv2.lookup_code) lookup_code, nvl(flv.language,flv2.language) language, flv.source_lang, flv2.source_lang source_lang_remote, decode(nvl(flv.source_lang,'x'),nvl(flv2.source_lang,'x'),null,'Y') source_lang_different, flv.description, flv2.description description_remote, decode(nvl(flv.description,'x'),nvl(flv2.description,'x'),null,'Y') description_different, flv.meaning, flv2.meaning meaning_remote, decode(nvl(flv.meaning,'x'),nvl(flv2.meaning,'x'),null,'Y') meaning_different from (select flv.* from fnd_lookup_values flv where 1=1) flv full join (select flv.* from fnd_lookup_values@&database_link flv where 1=1) flv2 on flv.lookup_type=flv2.lookup_type and flv.lookup_code=flv2.lookup_code and flv.language=flv2.language and flv.view_application_id=flv2.view_application_id and flv.security_group_id=flv2.security_group_id where 2=2 Y AR Compare FND Lookup Values between environments يقارن قيم البحث بين بيئة قاعدة البيانات المحلية والبعيدة D Compare FND Lookup Values between environments Vergleicht Lookup-Werte zwischen der lokalen und einer entfernten Datenbankumgebung E Compare FND Lookup Values between environments Compara los valores de búsqueda entre el entorno de la base de datos local y el remoto F Compare FND Lookup Values between environments Comparer les valeurs de recherche entre l'environnement local et un environnement de base de données distant I Compare FND Lookup Values between environments Confronta i valori di ricerca tra l'ambiente del database locale e quello remoto JA Compare FND Lookup Values between environments ローカルとリモートのデータベース環境間でルックアップ値を比較します。 KO Compare FND Lookup Values between environments 로컬 및 원격 데이터베이스 환경 간의 조회 값을 비교합니다. PTB Compare FND Lookup Values between environments Compara valores de pesquisa entre o ambiente local e um ambiente de banco de dados remoto RU Compare FND Lookup Values between environments Сравнивает значения поиска между локальной и удаленной средой баз данных S Compare FND Lookup Values between environments Jämför uppslagsvärden mellan den lokala och en fjärrdatabasmiljö TR Compare FND Lookup Values between environments Yerel ve uzak veritabanı ortamı arasındaki arama değerlerini karşılaştırır US FND Lookup Values Comparison between environments Compares lookup values between the local and a remote database environment ZHS Compare FND Lookup Values between environments 比较本地和远程数据库环境之间的查找值。 Enginatics &database_link 1=1 2=2 1 10 1=1 flv.lookup_type=:lookup_type LOV custom Y select fltv.lookup_type value, fav.application_name||': '||nvl(fltv.description,fltv.meaning) description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.application_id order by fltv.lookup_type XXEN_REPORT_TRANSLATIONS US Type 2 20 1=1 upper(flv.lookup_code) like '%'||upper(:lookup_code)||'%' LOV custom select distinct flvv.lookup_code value, flvv.meaning description from fnd_lookup_values_vl flvv where flvv.security_group_id=0 order by flvv.lookup_code F Le code contient US Code contains 3 80 1=1 flv.language=:language 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 F Code de la langue US Language Code 4 90 &database_link <parameter_value> LOV DBA Database Link 9FD1E69E877F1D9DE0530100007F19D3 Y select lower(substr(ddl.db_link,1,instr(ddl.db_link,'.')-1)) value, ddl.username||'@'||ddl.host description from dba_db_links ddl order by value demo Y F Base de données distante US Remote Database 5 100 1=1 flv.language<>:exclude_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 PT F Exclure le code de langue US Exclude Language Code 6 110 2=2 nvl(flv.source_lang,'x')<>nvl(flv2.source_lang,'x') or nvl(flv.meaning,'x')<>nvl(flv2.meaning,'x') or nvl(flv.description,'x')<>nvl(flv2.description,'x') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher uniquement les différences US Show Differences only