VIEW: APPS.PER_QUALIFICATIONS_V

Source

View Text - Preformatted

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 , NVL(QT.AWARDING_BODY ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER',QUT.PROVIDER)) , 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 , DECODE(QUA.ATTENDANCE_ID, NULL, QUA.PARTY_ID, ESA.PARTY_ID) PARTY_ID ,QUT.QUAL_FRAMEWORK_ID,QUT.QUALIFICATION_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QUAL_TYPE',QUT.QUALIFICATION_TYPE) ,QUT.CREDIT_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE',QUT.CREDIT_TYPE) ,QUT.CREDITS,QUT.LEVEL_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE',QUT.LEVEL_TYPE) ,QUT.LEVEL_NUMBER ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL',QUT.LEVEL_NUMBER) ,QUT.FIELD ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_FIELD',QUT.FIELD) ,QUT.SUB_FIELD ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD',QUT.SUB_FIELD) FROM PER_QUALIFICATIONS QUA, PER_QUALIFICATIONS_TL QT, PER_QUALIFICATION_TYPES_TL QTT, PER_ESTABLISHMENT_ATTENDANCES ESA, PER_ESTABLISHMENTS EST ,PER_QUALIFICATION_TYPES QUT WHERE QUA.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID AND QTT.LANGUAGE = userenv('LANG') AND QUT.QUALIFICATION_TYPE_ID = QUA.QUALIFICATION_TYPE_ID 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')

View Text - HTML Formatted

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
, NVL(QT.AWARDING_BODY
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER'
, QUT.PROVIDER))
, 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
, DECODE(QUA.ATTENDANCE_ID
, NULL
, QUA.PARTY_ID
, ESA.PARTY_ID) PARTY_ID
, QUT.QUAL_FRAMEWORK_ID
, QUT.QUALIFICATION_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QUAL_TYPE'
, QUT.QUALIFICATION_TYPE)
, QUT.CREDIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE'
, QUT.CREDIT_TYPE)
, QUT.CREDITS
, QUT.LEVEL_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE'
, QUT.LEVEL_TYPE)
, QUT.LEVEL_NUMBER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL'
, QUT.LEVEL_NUMBER)
, QUT.FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_FIELD'
, QUT.FIELD)
, QUT.SUB_FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD'
, QUT.SUB_FIELD)
FROM PER_QUALIFICATIONS QUA
, PER_QUALIFICATIONS_TL QT
, PER_QUALIFICATION_TYPES_TL QTT
, PER_ESTABLISHMENT_ATTENDANCES ESA
, PER_ESTABLISHMENTS EST
, PER_QUALIFICATION_TYPES QUT
WHERE QUA.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')
AND QUT.QUALIFICATION_TYPE_ID = QUA.QUALIFICATION_TYPE_ID
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')