FND_LANGUAGES

Details

Schema: REFDATA
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID LANGUAGE_CODE LANGUAGE_ID BCP47_TAG NLS_LANGUAGE NLS_TERRITORY ISO_LANGUAGE ISO_TERRITORY NLS_CODESET INSTALLED_FLAG ACTIVATION_STATUS LANGUAGE_TAG ISO_LANGUAGE_3 LANG_SQLSERVER LANG_DB2 DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

ROW_ID

LANGUAGE_CODE

LANGUAGE_ID

BCP47_TAG

NLS_LANGUAGE

NLS_TERRITORY

ISO_LANGUAGE

ISO_TERRITORY

NLS_CODESET

INSTALLED_FLAG

ACTIVATION_STATUS

LANGUAGE_TAG

ISO_LANGUAGE_3

LANG_SQLSERVER

LANG_DB2

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.LANGUAGE_CODE, B.LANGUAGE_ID, B.BCP47_TAG, B.NLS_LANGUAGE, B.NLS_TERRITORY, B.ISO_LANGUAGE, B.ISO_TERRITORY, B.NLS_CODESET, B.INSTALLED_FLAG, B.ACTIVATION_STATUS, B.LANGUAGE_TAG, B.ISO_LANGUAGE_3, B.LANG_SQLSERVER, B.LANG_DB2, T.DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM FND_LANGUAGES_TL T, FND_LANGUAGES_B B WHERE B.LANGUAGE_CODE = T.LANGUAGE_CODE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.LANGUAGE_CODE,

B.LANGUAGE_ID,

B.BCP47_TAG,

B.NLS_LANGUAGE,

B.NLS_TERRITORY,

B.ISO_LANGUAGE,

B.ISO_TERRITORY,

B.NLS_CODESET,

B.INSTALLED_FLAG,

B.ACTIVATION_STATUS,

B.LANGUAGE_TAG,

B.ISO_LANGUAGE_3,

B.LANG_SQLSERVER,

B.LANG_DB2,

T.DESCRIPTION,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

FND_LANGUAGES_TL T,

FND_LANGUAGES_B B

WHERE

B.LANGUAGE_CODE = T.LANGUAGE_CODE AND T.LANGUAGE = USERENV('LANG')