[Home] [Help]
View: WF_LANGUAGES
Product: | FND - Application Object Library |
Description: | National Dialects |
Implementation/DBA Data: |
APPS.WF_LANGUAGES
|
View Text
SELECT L.LANGUAGE_CODE 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')
Columns
Name |
CODE |
DISPLAY_NAME |
NLS_LANGUAGE |
NLS_TERRITORY |
NLS_CODESET |
INSTALLED_FLAG |