To Check Language Patches

SELECT LANGUAGE_CODE,NLS_LANGUAGE,INSTALLED_FLAG FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN('B','I');