VIEW: APPS.AST_PERSON_LANGUAGE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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