Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Language that person speaks , read and write |
Implementation/DBA Data: | Not implemented in this database |
SELECT HPL.LANGUAGE_USE_REFERENCE_ID
, HPL.PARTY_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, HPL.LANGUAGE_NAME
, '_LA:HPL.NATIVE_LANGUAGE:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:HPL.PRIMARY_LANGUAGE_INDICATOR:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HPL.READS_LEVEL
, HPL.SPEAKS_LEVEL
, HPL.WRITES_LEVEL
, FL.NLS_LANGUAGE
, HPL.LAST_UPDATE_DATE
, HPL.LAST_UPDATED_BY
, HPL.CREATED_BY
, HPL.CREATION_DATE
, HPL.LAST_UPDATE_LOGIN
FROM HZ_PERSON_LANGUAGE HPL
, FND_LANGUAGES FL
, HZ_PARTIES HP
WHERE HPL.LANGUAGE_NAME = FL.LANGUAGE_CODE
AND HPL.PARTY_ID = HP.PARTY_ID WITH READ ONLY