VIEW: APPS.PER_APPRAISAL_TEMPLATES_V

Source

View Text - Preformatted

SELECT /* $Header: permlwa.odf 120.10.12020000.8 2013/04/10 07:32:13 sidsaxen ship $ */ APT.APPRAISAL_TEMPLATE_ID , APT.BUSINESS_GROUP_ID , APT.OBJECT_VERSION_NUMBER , APT.NAME , APT.DESCRIPTION , APT.INSTRUCTIONS , APT.DATE_FROM , APT.DATE_TO , APT.ASSESSMENT_TYPE_ID , AST.NAME , AST.DATE_FROM , AST.DATE_TO , APT.RATING_SCALE_ID , RTL.NAME , APT.QUESTIONNAIRE_TEMPLATE_ID , APT.QUESTIONNAIRE_LANGUAGE , QUN.NAME QUESTIONNAIRE_NAME , APT.ATTRIBUTE_CATEGORY , APT.ATTRIBUTE1 , APT.ATTRIBUTE2 , APT.ATTRIBUTE3 , APT.ATTRIBUTE4 , APT.ATTRIBUTE5 , APT.ATTRIBUTE6 , APT.ATTRIBUTE7 , APT.ATTRIBUTE8 , APT.ATTRIBUTE9 , APT.ATTRIBUTE10 , APT.ATTRIBUTE11 , APT.ATTRIBUTE12 , APT.ATTRIBUTE13 , APT.ATTRIBUTE14 , APT.ATTRIBUTE15 , APT.ATTRIBUTE16 , APT.ATTRIBUTE17 , APT.ATTRIBUTE18 , APT.ATTRIBUTE19 , APT.ATTRIBUTE20 , APT.LAST_UPDATE_DATE , APT.LAST_UPDATED_BY , APT.LAST_UPDATE_LOGIN , APT.OBJECTIVE_ASMNT_TYPE_ID , APT.MA_QUEST_TEMPLATE_ID , APT.LINK_APPR_TO_LEARNING_PATH , APT.FINAL_SCORE_FORMULA_ID , APT.UPDATE_PERSONAL_COMP_PROFILE , APT.COMP_PROFILE_SOURCE_TYPE , APT.SHOW_COMPETENCY_RATINGS , APT.SHOW_OBJECTIVE_RATINGS , APT.SHOW_OVERALL_RATINGS , APT.SHOW_OVERALL_COMMENTS , APT.PROVIDE_OVERALL_FEEDBACK , APT.SHOW_PARTICIPANT_DETAILS , APT.ALLOW_ADD_PARTICIPANT , APT.SHOW_ADDITIONAL_DETAILS , APT.SHOW_PARTICIPANT_NAMES , APT.SHOW_PARTICIPANT_RATINGS , APT.AVAILABLE_FLAG , APT.SHOW_QUESTIONNAIRE_INFO FROM PER_APPRAISAL_TEMPLATES APT , HR_QUESTIONNAIRES QUN , PER_RATING_SCALES RAT , PER_RATING_SCALES_TL RTL , PER_ASSESSMENT_TYPES AST WHERE APT.QUESTIONNAIRE_TEMPLATE_ID = QUN.QUESTIONNAIRE_TEMPLATE_ID(+) AND APT.RATING_SCALE_ID = RAT.RATING_SCALE_ID(+) AND APT.RATING_SCALE_ID = RTL.RATING_SCALE_ID(+) AND RTL.LANGUAGE(+) = userenv('LANG') AND APT.ASSESSMENT_TYPE_ID = AST.ASSESSMENT_TYPE_ID(+)

View Text - HTML Formatted

SELECT /* $HEADER: PERMLWA.ODF 120.10.12020000.8 2013/04/10 07:32:13 SIDSAXEN SHIP $ */ APT.APPRAISAL_TEMPLATE_ID
, APT.BUSINESS_GROUP_ID
, APT.OBJECT_VERSION_NUMBER
, APT.NAME
, APT.DESCRIPTION
, APT.INSTRUCTIONS
, APT.DATE_FROM
, APT.DATE_TO
, APT.ASSESSMENT_TYPE_ID
, AST.NAME
, AST.DATE_FROM
, AST.DATE_TO
, APT.RATING_SCALE_ID
, RTL.NAME
, APT.QUESTIONNAIRE_TEMPLATE_ID
, APT.QUESTIONNAIRE_LANGUAGE
, QUN.NAME QUESTIONNAIRE_NAME
, APT.ATTRIBUTE_CATEGORY
, APT.ATTRIBUTE1
, APT.ATTRIBUTE2
, APT.ATTRIBUTE3
, APT.ATTRIBUTE4
, APT.ATTRIBUTE5
, APT.ATTRIBUTE6
, APT.ATTRIBUTE7
, APT.ATTRIBUTE8
, APT.ATTRIBUTE9
, APT.ATTRIBUTE10
, APT.ATTRIBUTE11
, APT.ATTRIBUTE12
, APT.ATTRIBUTE13
, APT.ATTRIBUTE14
, APT.ATTRIBUTE15
, APT.ATTRIBUTE16
, APT.ATTRIBUTE17
, APT.ATTRIBUTE18
, APT.ATTRIBUTE19
, APT.ATTRIBUTE20
, APT.LAST_UPDATE_DATE
, APT.LAST_UPDATED_BY
, APT.LAST_UPDATE_LOGIN
, APT.OBJECTIVE_ASMNT_TYPE_ID
, APT.MA_QUEST_TEMPLATE_ID
, APT.LINK_APPR_TO_LEARNING_PATH
, APT.FINAL_SCORE_FORMULA_ID
, APT.UPDATE_PERSONAL_COMP_PROFILE
, APT.COMP_PROFILE_SOURCE_TYPE
, APT.SHOW_COMPETENCY_RATINGS
, APT.SHOW_OBJECTIVE_RATINGS
, APT.SHOW_OVERALL_RATINGS
, APT.SHOW_OVERALL_COMMENTS
, APT.PROVIDE_OVERALL_FEEDBACK
, APT.SHOW_PARTICIPANT_DETAILS
, APT.ALLOW_ADD_PARTICIPANT
, APT.SHOW_ADDITIONAL_DETAILS
, APT.SHOW_PARTICIPANT_NAMES
, APT.SHOW_PARTICIPANT_RATINGS
, APT.AVAILABLE_FLAG
, APT.SHOW_QUESTIONNAIRE_INFO
FROM PER_APPRAISAL_TEMPLATES APT
, HR_QUESTIONNAIRES QUN
, PER_RATING_SCALES RAT
, PER_RATING_SCALES_TL RTL
, PER_ASSESSMENT_TYPES AST
WHERE APT.QUESTIONNAIRE_TEMPLATE_ID = QUN.QUESTIONNAIRE_TEMPLATE_ID(+)
AND APT.RATING_SCALE_ID = RAT.RATING_SCALE_ID(+)
AND APT.RATING_SCALE_ID = RTL.RATING_SCALE_ID(+)
AND RTL.LANGUAGE(+) = USERENV('LANG')
AND APT.ASSESSMENT_TYPE_ID = AST.ASSESSMENT_TYPE_ID(+)