Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_PE_LANGUAGES_V |
SELECT L.ROWID ROW_ID
, L.LANGUAGE_USE_REFERENCE_ID
, L.LANGUAGE_NAME
, FL.DESCRIPTION
, L.PARTY_ID
, L.NATIVE_LANGUAGE
, L.PRIMARY_LANGUAGE_INDICATOR
, L.READS_LEVEL
, L.SPEAKS_LEVEL
, L.WRITES_LEVEL
, L.CREATED_BY
, L.CREATION_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, TO_DATE(NULL) WH_UPDATE_DATE
, L.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, L.SPOKEN_COMPREHENSION_LEVEL UNDERSTANDS_LEVEL
, L1.MEANING UNDERSTANDS_LEVEL_DESC
, L2.MEANING SPEAKS_LEVEL_DESC
, L3.MEANING WRITES_LEVEL_DESC
, L4.MEANING READS_LEVEL_DESC
, L.STATUS
FROM HZ_PERSON_LANGUAGE L
, FND_LANGUAGES_VL FL
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
, FND_LOOKUP_VALUES L4
WHERE L.LANGUAGE_NAME = FL.LANGUAGE_CODE
AND L4.LOOKUP_CODE (+) = L.READS_LEVEL
AND L3.LOOKUP_CODE (+) = L.WRITES_LEVEL
AND L2.LOOKUP_CODE (+) = L.SPEAKS_LEVEL
AND L1.LOOKUP_CODE (+) = L.SPOKEN_COMPREHENSION_LEVEL
AND L1.LOOKUP_TYPE (+) = 'HZ_LANGUAGE_PROFICIENCY'
AND L1.LANGUAGE (+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID (+) = 222
AND L1.SECURITY_GROUP_ID (+) = 0
AND L2.LOOKUP_TYPE (+) = 'HZ_LANGUAGE_PROFICIENCY'
AND L2.LANGUAGE (+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID (+) = 222
AND L2.SECURITY_GROUP_ID (+) = 0
AND L3.LOOKUP_TYPE (+) = 'HZ_LANGUAGE_PROFICIENCY'
AND L3.LANGUAGE (+) = USERENV('LANG')
AND L3.VIEW_APPLICATION_ID (+) = 222
AND L3.SECURITY_GROUP_ID (+) = 0
AND L4.LOOKUP_TYPE (+) = 'HZ_LANGUAGE_PROFICIENCY'
AND L4.LANGUAGE (+) = USERENV('LANG')
AND L4.VIEW_APPLICATION_ID (+) = 222
AND L4.SECURITY_GROUP_ID (+) = 0