Helpful Scripts in R12

Query to find the Languages Installed in Oracle Apps 11i and R12

Select distinct NLS_LANGUAGE,
LANGUAGE_CODE,
NLS_TERRITORY
from fnd_languages
where INSTALLED_FLAG = 'I' or INSTALLED_FLAG = 'B'
ORDER BY NLS_LANGUAGE