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