SELECT fa.application_id           "Application ID",
fat.application_name        "Application Name",
fa.application_short_name   "Application Short Name",
fa.basepath                 "Basepath"
FROM fnd_application     fa,
fnd_application_tl  fat
WHERE fa.application_id = fat.application_id
AND fat.language      = USERENV('LANG')
ORDER BY fat.application_name;

Deixe um comentário