VIEW: APPS.IGS_PE_LANGUAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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