DBA Data[Home] [Help]

VIEW: APPS.FND_LANGUAGES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.LANGUAGE_CODE , B.LANGUAGE_ID , B.NLS_LANGUAGE , B.NLS_TERRITORY, B.ISO_LANGUAGE , B.ISO_TERRITORY , B.NLS_CODESET , B.INSTALLED_FLAG , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN , B.LOCAL_DATE_LANGUAGE, B.UTF8_DATE_LANGUAGE, B.ISO_LANGUAGE_3, T.DESCRIPTION FROM FND_LANGUAGES_TL T, FND_LANGUAGES B WHERE B.LANGUAGE_CODE = T.LANGUAGE_CODE AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.LANGUAGE_CODE
, B.LANGUAGE_ID
, B.NLS_LANGUAGE
, B.NLS_TERRITORY
, B.ISO_LANGUAGE
, B.ISO_TERRITORY
, B.NLS_CODESET
, B.INSTALLED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.LOCAL_DATE_LANGUAGE
, B.UTF8_DATE_LANGUAGE
, B.ISO_LANGUAGE_3
, T.DESCRIPTION
FROM FND_LANGUAGES_TL T
, FND_LANGUAGES B
WHERE B.LANGUAGE_CODE = T.LANGUAGE_CODE
AND T.LANGUAGE = USERENV('LANG')