SELECT a.application_id as app_id, a.application_short_name as app_code, aru.application_name as ru_app_name, aus.application_name as en_app_name, fpi.patch_level FROM applsys.fnd_application a, (SELECT * FROM applsys.fnd_application_tl au WHERE au.LANGUAGE = 'US') aus, (SELECT * FROM applsys.fnd_application_tl ar WHERE ar.LANGUAGE = 'RU') aru, fnd_product_installations fpi WHERE a.application_id = aus.application_id and a.application_id = aru.application_id and fpi.application_id(+) = a.application_id ORDER BY a.application_id, a.application_short_name, aru.application_name
Пример данных
SQL> column app_code format a10;
SQL> column ru_app_name format a20;
SQL> column en_app_name format a21;
SQL> column patch_level format a13;
...
APP_ID APP_CODE RU_APP_NAME EN_APP_NAME PATCH_LEVEL
---------- ---------- -------------------- --------------------- -------------
0 FND Библиотека объектов Application Object Li R12.FND.A.6
приложений brary
1 SYSADMIN Системное администри System Administration
рование
3 AU Служебные программы Application Utilities
Oracle Applications
50 AD АБД приложений Applications DBA R12.AD.A.6
60 SHT Общие технологии при Applications Shared T R12.SHT.A.6
ложений echnology
101 SQLGL Главная книга General Ledger R12.GL.A.6
140 OFA Активы Assets R12.FA.A.6
160 ALR Сигналы Alert R12.ALR.A.6
168 RG Генератор отчетов пр Application Report Ge R12.RG.A.6
иложения nerator
278 IZU Oracle E-Business Su Oracle E-Business Sui R12.IZU.A.6
ite Diagnostics te Diagnostics
10 rows selected
Последние комментарии