VIEW: APPS.HRBV_COMPETENCE_OUTCOMES_V

Source

View Text - Preformatted

SELECT CPOT.NAME, CPO.OUTCOME_NUMBER, CPO.ASSESSMENT_CRITERIA, CPO.DATE_FROM, CPO.DATE_TO, CPO.INFORMATION_CATEGORY, CPO.INFORMATION1, CPO.INFORMATION2, CPO.INFORMATION3, CPO.INFORMATION4, CPO.INFORMATION5, CPO.INFORMATION6, CPO.INFORMATION7, CPO.INFORMATION8, CPO.INFORMATION9, CPO.INFORMATION10, CPO.INFORMATION11, CPO.INFORMATION12, CPO.INFORMATION13, CPO.INFORMATION14, CPO.INFORMATION15, CPO.INFORMATION16, CPO.INFORMATION17, CPO.INFORMATION18, CPO.INFORMATION19, CPO.INFORMATION20, CPO.LAST_UPDATED_BY, '_DF:PER:PER_COMPETENCE_OUTCOMES:CPO', CPO.OUTCOME_ID, CPO.COMPETENCE_ID, CPO.LAST_UPDATE_DATE, CPO.CREATED_BY, CPO.CREATION_DATE FROM PER_COMPETENCE_OUTCOMES CPO, PER_COMPETENCE_OUTCOMES_TL CPOT WHERE CPO.OUTCOME_ID = CPOT.OUTCOME_ID AND CPOT.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CPOT.NAME
, CPO.OUTCOME_NUMBER
, CPO.ASSESSMENT_CRITERIA
, CPO.DATE_FROM
, CPO.DATE_TO
, CPO.INFORMATION_CATEGORY
, CPO.INFORMATION1
, CPO.INFORMATION2
, CPO.INFORMATION3
, CPO.INFORMATION4
, CPO.INFORMATION5
, CPO.INFORMATION6
, CPO.INFORMATION7
, CPO.INFORMATION8
, CPO.INFORMATION9
, CPO.INFORMATION10
, CPO.INFORMATION11
, CPO.INFORMATION12
, CPO.INFORMATION13
, CPO.INFORMATION14
, CPO.INFORMATION15
, CPO.INFORMATION16
, CPO.INFORMATION17
, CPO.INFORMATION18
, CPO.INFORMATION19
, CPO.INFORMATION20
, CPO.LAST_UPDATED_BY
, '_DF:PER:PER_COMPETENCE_OUTCOMES:CPO'
, CPO.OUTCOME_ID
, CPO.COMPETENCE_ID
, CPO.LAST_UPDATE_DATE
, CPO.CREATED_BY
, CPO.CREATION_DATE
FROM PER_COMPETENCE_OUTCOMES CPO
, PER_COMPETENCE_OUTCOMES_TL CPOT
WHERE CPO.OUTCOME_ID = CPOT.OUTCOME_ID
AND CPOT.LANGUAGE = USERENV('LANG') WITH READ ONLY