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;