View: PER_QUALIFICATIONS_V

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

View Text

SELECT QUA.ROWID ROW_ID
, QUA.QUALIFICATION_ID
, QUA.BUSINESS_GROUP_ID
, QUA.OBJECT_VERSION_NUMBER
, DECODE(QUA.PERSON_ID
, NULL
, ESA.PERSON_ID
, QUA.PERSON_ID) PERSON_ID
, QT.TITLE
, QT.GRADE_ATTAINED
, QUA.STATUS
, HR_GENERAL.DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, QUA.STATUS) STATUS_MEANING
, QUA.AWARDED_DATE
, QUA.FEE
, QUA.FEE_CURRENCY
, QUA.TRAINING_COMPLETED_AMOUNT
, QT.REIMBURSEMENT_ARRANGEMENTS
, QT.TRAINING_COMPLETED_UNITS
, QUA.TOTAL_TRAINING_AMOUNT
, QUA.START_DATE
, QUA.END_DATE
, QUA.LICENSE_NUMBER
, QUA.EXPIRY_DATE
, QT.LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE
, QT.AWARDING_BODY
, QUA.TUITION_METHOD
, HR_GENERAL.DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) TUITION_METHOD_MEANING
, QT.GROUP_RANKING
, QUA.COMMENTS
, QUA.QUALIFICATION_TYPE_ID
, QTT.NAME
, QUA.ATTENDANCE_ID
, NVL(ESA.ESTABLISHMENT
, EST.NAME) ESTABLISHMENT
, EST.LOCATION
, QUA.PROFESSIONAL_BODY_NAME
, QUA.MEMBERSHIP_NUMBER
, QT.MEMBERSHIP_CATEGORY
, QUA.SUBSCRIPTION_PAYMENT_METHOD
, QUA.ATTRIBUTE_CATEGORY
, QUA.ATTRIBUTE1
, QUA.ATTRIBUTE2
, QUA.ATTRIBUTE3
, QUA.ATTRIBUTE4
, QUA.ATTRIBUTE5
, QUA.ATTRIBUTE6
, QUA.ATTRIBUTE7
, QUA.ATTRIBUTE8
, QUA.ATTRIBUTE9
, QUA.ATTRIBUTE10
, QUA.ATTRIBUTE11
, QUA.ATTRIBUTE12
, QUA.ATTRIBUTE13
, QUA.ATTRIBUTE14
, QUA.ATTRIBUTE15
, QUA.ATTRIBUTE16
, QUA.ATTRIBUTE17
, QUA.ATTRIBUTE18
, QUA.ATTRIBUTE19
, QUA.ATTRIBUTE20
, QUA.QUA_INFORMATION_CATEGORY
, QUA.QUA_INFORMATION1
, QUA.QUA_INFORMATION2
, QUA.QUA_INFORMATION3
, QUA.QUA_INFORMATION4
, QUA.QUA_INFORMATION5
, QUA.QUA_INFORMATION6
, QUA.QUA_INFORMATION7
, QUA.QUA_INFORMATION8
, QUA.QUA_INFORMATION9
, QUA.QUA_INFORMATION10
, QUA.QUA_INFORMATION11
, QUA.QUA_INFORMATION12
, QUA.QUA_INFORMATION13
, QUA.QUA_INFORMATION14
, QUA.QUA_INFORMATION15
, QUA.QUA_INFORMATION16
, QUA.QUA_INFORMATION17
, QUA.QUA_INFORMATION18
, QUA.QUA_INFORMATION19
, QUA.QUA_INFORMATION20
, QUA.LAST_UPDATE_DATE
, QUA.LAST_UPDATED_BY
, QUA.LAST_UPDATE_LOGIN
, QUA.CREATED_BY
, QUA.CREATION_DATE
, QUA.PARTY_ID
FROM PER_QUALIFICATIONS QUA
, PER_QUALIFICATIONS_TL QT
, PER_QUALIFICATION_TYPES_TL QTT
, PER_ESTABLISHMENT_ATTENDANCES ESA
, PER_ESTABLISHMENTS EST
WHERE QUA.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')
AND QUA.ATTENDANCE_ID = ESA.ATTENDANCE_ID (+)
AND ESA.ESTABLISHMENT_ID = EST.ESTABLISHMENT_ID (+)
AND QT.QUALIFICATION_ID = QUA.QUALIFICATION_ID
AND QT.LANGUAGE = USERENV('LANG')

Columns