[Home] [Help]
View: AMS_PERSON_LANG_V
Product: | AMS - Marketing |
Description: | Languages that a person speaks, reads, or writes |
Implementation/DBA Data: |
APPS.AMS_PERSON_LANG_V
|
View Text
SELECT HPL.LANGUAGE_USE_REFERENCE_ID
, HPL.PARTY_ID
, HPL.LANGUAGE_NAME
, HPL.NATIVE_LANGUAGE
, HPL.PRIMARY_LANGUAGE_INDICATOR
, HPL.READS_LEVEL
, HPL.SPEAKS_LEVEL
, HPL.WRITES_LEVEL
FROM HZ_PERSON_LANGUAGE HPL
, HZ_PARTIES HP
WHERE HPL.PARTY_ID = HP.PARTY_ID
AND PRIMARY_LANGUAGE_INDICATOR = 'Y'
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'
Columns
Name |
LANGUAGE_USE_REFERENCE_ID |
PARTY_ID |
LANGUAGE_NAME |
NATIVE_LANGUAGE |
PRIMARY_LANGUAGE_INDICATOR |
READS_LEVEL |
SPEAKS_LEVEL |
WRITES_LEVEL |