VIEW: APPS.PER_COMP_ELEMENT_OUTCOMES_VL

Source

View Text - Preformatted

SELECT CEO.COMP_ELEMENT_OUTCOME_ID ,CEO.COMPETENCE_ELEMENT_ID ,CEO.OUTCOME_ID ,CEO.DATE_FROM ,CEO.DATE_TO ,CEO.OBJECT_VERSION_NUMBER ,CEO.ATTRIBUTE_CATEGORY ,CEO.ATTRIBUTE1 ,CEO.ATTRIBUTE2 ,CEO.ATTRIBUTE3 ,CEO.ATTRIBUTE4 ,CEO.ATTRIBUTE5 ,CEO.ATTRIBUTE6 ,CEO.ATTRIBUTE7 ,CEO.ATTRIBUTE8 ,CEO.ATTRIBUTE9 ,CEO.ATTRIBUTE10 ,CEO.ATTRIBUTE11 ,CEO.ATTRIBUTE12 ,CEO.ATTRIBUTE13 ,CEO.ATTRIBUTE14 ,CEO.ATTRIBUTE15 ,CEO.ATTRIBUTE16 ,CEO.ATTRIBUTE17 ,CEO.ATTRIBUTE18 ,CEO.ATTRIBUTE19 ,CEO.ATTRIBUTE20 ,CEO.INFORMATION_CATEGORY ,CEO.INFORMATION1 ,CEO.INFORMATION2 ,CEO.INFORMATION3 ,CEO.INFORMATION4 ,CEO.INFORMATION5 ,CEO.INFORMATION6 ,CEO.INFORMATION7 ,CEO.INFORMATION8 ,CEO.INFORMATION9 ,CEO.INFORMATION10 ,CEO.INFORMATION11 ,CEO.INFORMATION12 ,CEO.INFORMATION13 ,CEO.INFORMATION14 ,CEO.INFORMATION15 ,CEO.INFORMATION16 ,CEO.INFORMATION17 ,CEO.INFORMATION18 ,CEO.INFORMATION19 ,CEO.INFORMATION20 ,CO.OUTCOME_NUMBER ,COT.NAME ,COT.ASSESSMENT_CRITERIA FROM PER_COMP_ELEMENT_OUTCOMES CEO ,PER_COMPETENCE_OUTCOMES_TL COT ,PER_COMPETENCE_OUTCOMES CO WHERE CEO.OUTCOME_ID = CO.OUTCOME_ID AND CO.OUTCOME_ID = COT.OUTCOME_ID AND COT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT CEO.COMP_ELEMENT_OUTCOME_ID
, CEO.COMPETENCE_ELEMENT_ID
, CEO.OUTCOME_ID
, CEO.DATE_FROM
, CEO.DATE_TO
, CEO.OBJECT_VERSION_NUMBER
, CEO.ATTRIBUTE_CATEGORY
, CEO.ATTRIBUTE1
, CEO.ATTRIBUTE2
, CEO.ATTRIBUTE3
, CEO.ATTRIBUTE4
, CEO.ATTRIBUTE5
, CEO.ATTRIBUTE6
, CEO.ATTRIBUTE7
, CEO.ATTRIBUTE8
, CEO.ATTRIBUTE9
, CEO.ATTRIBUTE10
, CEO.ATTRIBUTE11
, CEO.ATTRIBUTE12
, CEO.ATTRIBUTE13
, CEO.ATTRIBUTE14
, CEO.ATTRIBUTE15
, CEO.ATTRIBUTE16
, CEO.ATTRIBUTE17
, CEO.ATTRIBUTE18
, CEO.ATTRIBUTE19
, CEO.ATTRIBUTE20
, CEO.INFORMATION_CATEGORY
, CEO.INFORMATION1
, CEO.INFORMATION2
, CEO.INFORMATION3
, CEO.INFORMATION4
, CEO.INFORMATION5
, CEO.INFORMATION6
, CEO.INFORMATION7
, CEO.INFORMATION8
, CEO.INFORMATION9
, CEO.INFORMATION10
, CEO.INFORMATION11
, CEO.INFORMATION12
, CEO.INFORMATION13
, CEO.INFORMATION14
, CEO.INFORMATION15
, CEO.INFORMATION16
, CEO.INFORMATION17
, CEO.INFORMATION18
, CEO.INFORMATION19
, CEO.INFORMATION20
, CO.OUTCOME_NUMBER
, COT.NAME
, COT.ASSESSMENT_CRITERIA
FROM PER_COMP_ELEMENT_OUTCOMES CEO
, PER_COMPETENCE_OUTCOMES_TL COT
, PER_COMPETENCE_OUTCOMES CO
WHERE CEO.OUTCOME_ID = CO.OUTCOME_ID
AND CO.OUTCOME_ID = COT.OUTCOME_ID
AND COT.LANGUAGE = USERENV('LANG')