VIEW: APPS.WF_LANGUAGES

Source

View Text - Preformatted

SELECT nvl(B.LANGUAGE_CODE, C.CODE) CODE, DISPLAY_NAME, NLS_LANGUAGE, NLS_TERRITORY, NLS_CODESET, INSTALLED_FLAG, OVERRIDE_EMAIL_CHARSET FROM ( SELECT L.LANGUAGE_CODE, LTL.DESCRIPTION DISPLAY_NAME, L.NLS_LANGUAGE NLS_LANGUAGE, L.NLS_TERRITORY NLS_TERRITORY, L.NLS_CODESET NLS_CODESET, decode(INSTALLED_FLAG, 'B', 'Y', 'I', 'Y', 'N') INSTALLED_FLAG FROM FND_LANGUAGES L, FND_LANGUAGES_TL LTL WHERE LTL.LANGUAGE_CODE = L.LANGUAGE_CODE AND LTL.LANGUAGE = userenv('LANG') ) B FULL OUTER JOIN WF_OVERRIDE_CHARSETS C ON B.LANGUAGE_CODE = C.CODE

View Text - HTML Formatted

SELECT NVL(B.LANGUAGE_CODE
, C.CODE) CODE
, DISPLAY_NAME
, NLS_LANGUAGE
, NLS_TERRITORY
, NLS_CODESET
, INSTALLED_FLAG
, OVERRIDE_EMAIL_CHARSET
FROM ( SELECT L.LANGUAGE_CODE
, LTL.DESCRIPTION DISPLAY_NAME
, L.NLS_LANGUAGE NLS_LANGUAGE
, L.NLS_TERRITORY NLS_TERRITORY
, L.NLS_CODESET NLS_CODESET
, DECODE(INSTALLED_FLAG
, 'B'
, 'Y'
, 'I'
, 'Y'
, 'N') INSTALLED_FLAG
FROM FND_LANGUAGES L
, FND_LANGUAGES_TL LTL
WHERE LTL.LANGUAGE_CODE = L.LANGUAGE_CODE
AND LTL.LANGUAGE = USERENV('LANG') ) B FULL OUTER JOIN WF_OVERRIDE_CHARSETS C ON B.LANGUAGE_CODE = C.CODE