Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_PERSON_LANGUAGE_V |
SELECT LANG.ROWID
, LANG.LANGUAGE_USE_REFERENCE_ID
, LANG.LANGUAGE_NAME
, LANG.PARTY_ID
, LANG.NATIVE_LANGUAGE
, LANG.PRIMARY_LANGUAGE_INDICATOR
, LANG.READS_LEVEL
, LANG.SPEAKS_LEVEL
, LANG.WRITES_LEVEL
, LANG.LAST_UPDATE_DATE
, LANG.LAST_UPDATED_BY
, LANG.CREATED_BY
, LANG.CREATION_DATE
, LANG.LAST_UPDATE_LOGIN
, LANG.STATUS
, LANG.OBJECT_VERSION_NUMBER
, LANG.CREATED_BY_MODULE
, LANG.APPLICATION_ID
, FND.DESCRIPTION
, LKUP.MEANING
FROM HZ_PERSON_LANGUAGE LANG
, FND_LANGUAGES_VL FND
, AR_LOOKUPS LKUP
WHERE LANG.LANGUAGE_NAME = FND.LANGUAGE_CODE
AND LKUP.LOOKUP_TYPE(+) = 'REGISTRY_STATUS'
AND LKUP.LOOKUP_CODE(+) = LANG.STATUS
AND LANG.STATUS IN ('A'
, 'I')