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'
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'
|
|
|