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: AR.HZ_PERSON_LANGUAGE

Object Details

Object Name:	HZ_PERSON_LANGUAGE
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_PERSON_LANGUAGE
Subobject Name:
Status:	VALID

The HZ_PERSON_LANGUAGE table stores information about a language spoken by a
party of the Person type. However, other types of parties are also supported.
For example, a person may speak Spanish as her primary language. You would
create another record if she speaks French, but it is not her primary
language. Note that a separate record must exist for each language.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_PERSON_LANGUAGE_PK

LANGUAGE_USE_REFERENCE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_PERSON_LANGUAGE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LANGUAGE_USE_REFERENCE_ID
HZ_PERSON_LANGUAGE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LANGUAGE_USE_REFERENCE_ID	NUMBER	(15)	Yes	Unique identifer of the language use reference
LANGUAGE_NAME	VARCHAR2	(4)	Yes	The standard name for a language. For example, Spanish, Mandarin, or American English. Foreign key to the FND_LANGUAGES table.
PARTY_ID	NUMBER	(15)	Yes	Identifier for the party. Foreign key to the HZ_PARTIES table.
NATIVE_LANGUAGE	VARCHAR2	(1)		Indicates if this language is the person's declared native language. Y for a declared native language, N for all other languages.
PRIMARY_LANGUAGE_INDICATOR	VARCHAR2	(1)		Indicates if this is the primary language used by a person in day-to-day transactions. Y for the primary language, N for other languages.
READS_LEVEL	VARCHAR2	(30)		User-defined level number or name to indicate the ability to read a language
SPEAKS_LEVEL	VARCHAR2	(30)		User-defined level number or name to indicate the ability to speak a language
WRITES_LEVEL	VARCHAR2	(30)		User-defined level number or name to indicate the ability to write in a language
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
WH_UPDATE_DATE	DATE			Date when the record was entered or changed in a data warehouse
STATUS	VARCHAR2	(1)		Record status flag
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purpose
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column
SPOKEN_COMPREHENSION_LEVEL	VARCHAR2	(30)		Code to indicate comprehension of a spoken language

Query Text

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


SELECT LANGUAGE_USE_REFERENCE_ID
,      LANGUAGE_NAME
,      PARTY_ID
,      NATIVE_LANGUAGE
,      PRIMARY_LANGUAGE_INDICATOR
,      READS_LEVEL
,      SPEAKS_LEVEL
,      WRITES_LEVEL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      SPOKEN_COMPREHENSION_LEVEL
FROM AR.HZ_PERSON_LANGUAGE;

Dependencies

[top of page]

AR.HZ_PERSON_LANGUAGE does not reference any database object

AR.HZ_PERSON_LANGUAGE is referenced by following:

APPS: HZ_PERSON_LANGUAGE