Query To Check FND Languages Installed in Oracle EBS

Download(fndlangs.sql)

REM +======================================================================+
REM                    
REM File Name: fndlangs.sql
REM 
REM Description:
REM   Query To Check FND Languages Installed in Oracle EBS 
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fndlangs.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
set pages 50
col LANGUAGE_CODE for a15
col NLS_LANGUAGE for a20
col ISO_LANGUAGE for a15
col INSTALLED_FLAG for a15
SELECT LANGUAGE_CODE,NLS_LANGUAGE, ISO_LANGUAGE,INSTALLED_FLAG 
FROM APPS.FND_LANGUAGES 
WHERE INSTALLED_FLAG IN ('B','I');