eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LANGUAGES

Object Details

Object Name:	FND_LANGUAGES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_LANGUAGES
Subobject Name:
Status:	VALID

FND_LANGUAGES stores information regarding languages and
dialects. Each dialect is stored as a unique language, and therefore
is referred to as a language in this description.
Each row includes the language code, such as 'en' for English,
a numerical identifier for the language,
the name of the language, such as 'American'
and the territory where the language is spoken, such as 'America'.
Each row also includes the ISO (International Standards
Organization) language code and territory code, the code set for
the language, and a flag to indicate the installation status of the language.
You need one row for each dialect.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LANGUAGES_U1	NORMAL	UNIQUE	APPS_TS_SEED	LANGUAGE_CODE ZD_EDITION_NAME
FND_LANGUAGES_U3	NORMAL	UNIQUE	APPS_TS_SEED	LANGUAGE_ID ZD_EDITION_NAME
FND_LANGUAGES_U5	NORMAL	UNIQUE	APPS_TS_SEED	NLS_LANGUAGE ZD_EDITION_NAME
FND_LANGUAGES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	INSTALLED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
LANGUAGE_CODE	VARCHAR2	(4)	Yes	Language code
LANGUAGE_ID	NUMBER		Yes	Language identifier
NLS_LANGUAGE	VARCHAR2	(30)	Yes	Language name
NLS_TERRITORY	VARCHAR2	(30)	Yes	The territory using the language
ISO_LANGUAGE	VARCHAR2	(2)		The ISO symbol for the language
ISO_TERRITORY	VARCHAR2	(2)		The ISO symbol for the territory
NLS_CODESET	VARCHAR2	(30)		The code set for the language
INSTALLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the language is installed and available for use
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LOCAL_DATE_LANGUAGE	VARCHAR2	(30)		Language name used to represent month part of date
UTF8_DATE_LANGUAGE	VARCHAR2	(30)		Language to use if running UNICODE
ISO_LANGUAGE_3	VARCHAR2	(3)		3 letter language code
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LANGUAGE_CODE
,      LANGUAGE_ID
,      NLS_LANGUAGE
,      NLS_TERRITORY
,      ISO_LANGUAGE
,      ISO_TERRITORY
,      NLS_CODESET
,      INSTALLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOCAL_DATE_LANGUAGE
,      UTF8_DATE_LANGUAGE
,      ISO_LANGUAGE_3
,      ZD_EDITION_NAME
FROM APPLSYS.FND_LANGUAGES;

Dependencies

[top of page]

APPLSYS.FND_LANGUAGES does not reference any database object

APPLSYS.FND_LANGUAGES is referenced by following:

APPLSYS: FND_LANGUAGES#