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

VIEW: APPS.AMS_PERSON_LANG_V

Object Details
Object Name: AMS_PERSON_LANG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PERSON_LANG_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LANGUAGE_USE_REFERENCE_ID NUMBER (15) Yes Unique identifer of the language use reference
PARTY_ID NUMBER (15) Yes Identifier for the party. Foreign key to the HZ_PARTIES table.
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.
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
Query Text

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


SELECT LANGUAGE_USE_REFERENCE_ID
,      PARTY_ID
,      LANGUAGE_NAME
,      NATIVE_LANGUAGE
,      PRIMARY_LANGUAGE_INDICATOR
,      READS_LEVEL
,      SPEAKS_LEVEL
,      WRITES_LEVEL
FROM APPS.AMS_PERSON_LANG_V;

Dependencies

[top of page]

APPS.AMS_PERSON_LANG_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_LANGUAGE

APPS.AMS_PERSON_LANG_V is not referenced by any database object