View: OTA_COMPETENCE_LANGUAGES_V

Product:	OTA - Learning Management
Description:
Implementation/DBA Data:	APPS.OTA_COMPETENCE_LANGUAGES_V

View Text

SELECT OCL.ROWID
, OCL.COMPETENCE_LANGUAGE_ID
, OCL.COMPETENCE_ID
, CPN.NAME
, OCL.LANGUAGE_ID
, OTA_GENERAL.FND_LANG_DESC(OCL.LANGUAGE_ID) 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')

Columns