APPS-ORACLE.RU

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

Читать дальше про “Информация о модулях OEBS + номер версии” »