VIEW: APPS.OTA_COMPETENCE_LANGUAGES_V

Source

View Text - Preformatted

SELECT OCL.ROWID ,OCL.COMPETENCE_LANGUAGE_ID , OCL.COMPETENCE_ID , CPN.NAME , OCL.LANGUAGE_CODE ,ota_utility.get_lang_name(ocl.language_code) language_description ,OCL.MIN_PROFICIENCY_LEVEL_ID , RATL.STEP_VALUE || DECODE(RATL.NAME,'','', ' - ' || RATL.NAME) MIN_PROFICIENCY_LEVEL_NAME ,OCL.BUSINESS_GROUP_ID ,OCL.OBJECT_VERSION_NUMBER , OCL.LAST_UPDATE_DATE , OCL.LAST_UPDATED_BY , OCL.LAST_UPDATE_LOGIN , OCL.CREATED_BY , OCL.CREATION_DATE , OCL.OCL_INFORMATION_CATEGORY , OCL.OCL_INFORMATION1 , OCL.OCL_INFORMATION2 , OCL.OCL_INFORMATION3 , OCL.OCL_INFORMATION4 , OCL.OCL_INFORMATION5 , OCL.OCL_INFORMATION6 , OCL.OCL_INFORMATION7 , OCL.OCL_INFORMATION8 , OCL.OCL_INFORMATION9 , OCL.OCL_INFORMATION10 , OCL.OCL_INFORMATION11 , OCL.OCL_INFORMATION12 , OCL.OCL_INFORMATION13 , OCL.OCL_INFORMATION14 , OCL.OCL_INFORMATION15 , OCL.OCL_INFORMATION16 , OCL.OCL_INFORMATION17 , OCL.OCL_INFORMATION18 , OCL.OCL_INFORMATION19 , OCL.OCL_INFORMATION20 FROM OTA_COMPETENCE_LANGUAGES OCL, PER_RATING_LEVELS RATL, PER_COMPETENCES CPN, FND_SESSIONS FND WHERE OCL.COMPETENCE_ID = CPN.COMPETENCE_ID AND OCL.MIN_PROFICIENCY_LEVEL_ID = RATL.RATING_LEVEL_ID(+) AND FND.SESSION_ID = USERENV('SESSIONID')

View Text - HTML Formatted

SELECT OCL.ROWID
, OCL.COMPETENCE_LANGUAGE_ID
, OCL.COMPETENCE_ID
, CPN.NAME
, OCL.LANGUAGE_CODE
, OTA_UTILITY.GET_LANG_NAME(OCL.LANGUAGE_CODE) LANGUAGE_DESCRIPTION
, OCL.MIN_PROFICIENCY_LEVEL_ID
, RATL.STEP_VALUE || DECODE(RATL.NAME
, ''
, ''
, ' - ' || RATL.NAME) MIN_PROFICIENCY_LEVEL_NAME
, OCL.BUSINESS_GROUP_ID
, OCL.OBJECT_VERSION_NUMBER
, OCL.LAST_UPDATE_DATE
, OCL.LAST_UPDATED_BY
, OCL.LAST_UPDATE_LOGIN
, OCL.CREATED_BY
, OCL.CREATION_DATE
, OCL.OCL_INFORMATION_CATEGORY
, OCL.OCL_INFORMATION1
, OCL.OCL_INFORMATION2
, OCL.OCL_INFORMATION3
, OCL.OCL_INFORMATION4
, OCL.OCL_INFORMATION5
, OCL.OCL_INFORMATION6
, OCL.OCL_INFORMATION7
, OCL.OCL_INFORMATION8
, OCL.OCL_INFORMATION9
, OCL.OCL_INFORMATION10
, OCL.OCL_INFORMATION11
, OCL.OCL_INFORMATION12
, OCL.OCL_INFORMATION13
, OCL.OCL_INFORMATION14
, OCL.OCL_INFORMATION15
, OCL.OCL_INFORMATION16
, OCL.OCL_INFORMATION17
, OCL.OCL_INFORMATION18
, OCL.OCL_INFORMATION19
, OCL.OCL_INFORMATION20
FROM OTA_COMPETENCE_LANGUAGES OCL
, PER_RATING_LEVELS RATL
, PER_COMPETENCES CPN
, FND_SESSIONS FND
WHERE OCL.COMPETENCE_ID = CPN.COMPETENCE_ID
AND OCL.MIN_PROFICIENCY_LEVEL_ID = RATL.RATING_LEVEL_ID(+)
AND FND.SESSION_ID = USERENV('SESSIONID')