VIEW: APPS.PER_ASSESSMENT_TYPES_V

Source

View Text - Preformatted

SELECT 1 , AST.ASSESSMENT_TYPE_ID , AST.NAME , AST.BUSINESS_GROUP_ID , AST.DESCRIPTION , AST.RATING_SCALE_ID , RTL1.NAME , AST.WEIGHTING_SCALE_ID , RTL2.NAME , AST.RATING_SCALE_COMMENT , AST.WEIGHTING_SCALE_COMMENT , AST.ASSESSMENT_CLASSIFICATION , HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION_FORM' , AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION) , (AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION) , AST.DISPLAY_ASSESSMENT_COMMENTS , AST.COMMENTS , AST.INSTRUCTIONS , AST.WEIGHTING_CLASSIFICATION , AST.LINE_SCORE_FORMULA , AST.TOTAL_SCORE_FORMULA , HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_TOTAL_FORMULA' , AST.TOTAL_SCORE_FORMULA) , AST.DATE_FROM , AST.DATE_TO , AST.OBJECT_VERSION_NUMBER , AST.ATTRIBUTE_CATEGORY , AST.ATTRIBUTE1 , AST.ATTRIBUTE2 , AST.ATTRIBUTE3 , AST.ATTRIBUTE4 , AST.ATTRIBUTE5 , AST.ATTRIBUTE6 , AST.ATTRIBUTE7 , AST.ATTRIBUTE8 , AST.ATTRIBUTE9 , AST.ATTRIBUTE10 , AST.ATTRIBUTE11 , AST.ATTRIBUTE12 , AST.ATTRIBUTE13 , AST.ATTRIBUTE14 , AST.ATTRIBUTE15 , AST.ATTRIBUTE16 , AST.ATTRIBUTE17 , AST.ATTRIBUTE18 , AST.ATTRIBUTE19 , AST.ATTRIBUTE20 , AST.LAST_UPDATE_DATE , AST.LAST_UPDATED_BY , AST.LAST_UPDATE_LOGIN , AST.CREATED_BY , AST.CREATION_DATE FROM PER_ASSESSMENT_TYPES AST, PER_RATING_SCALES RSC1, PER_RATING_SCALES RSC2, PER_RATING_SCALES_TL RTL1, PER_RATING_SCALES_TL RTL2 WHERE AST.RATING_SCALE_ID = RSC1.RATING_SCALE_ID (+) AND AST.RATING_SCALE_ID = RTL1.RATING_SCALE_ID (+) AND RTL1.LANGUAGE (+) = userenv('LANG') AND AST.WEIGHTING_SCALE_ID = RSC2.RATING_SCALE_ID (+) AND AST.WEIGHTING_SCALE_ID = RTL2.RATING_SCALE_ID (+) AND RTL2.LANGUAGE (+) = userenv('LANG')

View Text - HTML Formatted

SELECT 1
, AST.ASSESSMENT_TYPE_ID
, AST.NAME
, AST.BUSINESS_GROUP_ID
, AST.DESCRIPTION
, AST.RATING_SCALE_ID
, RTL1.NAME
, AST.WEIGHTING_SCALE_ID
, RTL2.NAME
, AST.RATING_SCALE_COMMENT
, AST.WEIGHTING_SCALE_COMMENT
, AST.ASSESSMENT_CLASSIFICATION
, HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_CLASSIFICATION_FORM'
, AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION)
, (AST.ASSESSMENT_CLASSIFICATION || AST.WEIGHTING_CLASSIFICATION)
, AST.DISPLAY_ASSESSMENT_COMMENTS
, AST.COMMENTS
, AST.INSTRUCTIONS
, AST.WEIGHTING_CLASSIFICATION
, AST.LINE_SCORE_FORMULA
, AST.TOTAL_SCORE_FORMULA
, HR_GENERAL.DECODE_LOOKUP('ASSESSMENT_TOTAL_FORMULA'
, AST.TOTAL_SCORE_FORMULA)
, AST.DATE_FROM
, AST.DATE_TO
, AST.OBJECT_VERSION_NUMBER
, AST.ATTRIBUTE_CATEGORY
, AST.ATTRIBUTE1
, AST.ATTRIBUTE2
, AST.ATTRIBUTE3
, AST.ATTRIBUTE4
, AST.ATTRIBUTE5
, AST.ATTRIBUTE6
, AST.ATTRIBUTE7
, AST.ATTRIBUTE8
, AST.ATTRIBUTE9
, AST.ATTRIBUTE10
, AST.ATTRIBUTE11
, AST.ATTRIBUTE12
, AST.ATTRIBUTE13
, AST.ATTRIBUTE14
, AST.ATTRIBUTE15
, AST.ATTRIBUTE16
, AST.ATTRIBUTE17
, AST.ATTRIBUTE18
, AST.ATTRIBUTE19
, AST.ATTRIBUTE20
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY
, AST.LAST_UPDATE_LOGIN
, AST.CREATED_BY
, AST.CREATION_DATE
FROM PER_ASSESSMENT_TYPES AST
, PER_RATING_SCALES RSC1
, PER_RATING_SCALES RSC2
, PER_RATING_SCALES_TL RTL1
, PER_RATING_SCALES_TL RTL2
WHERE AST.RATING_SCALE_ID = RSC1.RATING_SCALE_ID (+)
AND AST.RATING_SCALE_ID = RTL1.RATING_SCALE_ID (+)
AND RTL1.LANGUAGE (+) = USERENV('LANG')
AND AST.WEIGHTING_SCALE_ID = RSC2.RATING_SCALE_ID (+)
AND AST.WEIGHTING_SCALE_ID = RTL2.RATING_SCALE_ID (+)
AND RTL2.LANGUAGE (+) = USERENV('LANG')