View: PER_APPRAISAL_TEMPLATES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_APPRAISAL_TEMPLATES_V

View Text

SELECT /* $HEADER: PERZZVEWDIC00026.LDT 115.4 2004/01/22 21:30:32 RAMASUKR NOSHIP $ */ 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
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(+)

Columns