The below query can be used for the finding the languages installed in Oracle Application.

SELECT Language_code, NLS_language, Installed_flag
  FROM fnd_languages
 WHERE installed_flag IN ('I', 'B')

The Installed_Flag has 3 values

I- Installed
B- Base
D- Disabled