VIEW: APPS.PER_ZA_FORMAL_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, qua.title, qua.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, qua.reimbursement_arrangements, qua.training_completed_units, qua.total_training_amount, qua.start_date, qua.end_date, qua.license_number, qua.expiry_date, qua.license_restrictions, qua.projected_completion_date, qua.awarding_body, qua.tuition_method, hr_general.decode_lookup('PER_TUITION_METHODS',qua.tuition_method) tuition_method_meaning, qua.group_ranking, qua.comments, qua.qualification_type_id, pqt.name, qua.attendance_id, nvl(esa.establishment,est.name) establishment, est.location, 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.last_update_date, qua.last_updated_by, qua.last_update_login, qua.created_by, qua.creation_date, prq.level_id, prq.field_of_learning, hr_general.decode_lookup('ZA_NQF_FIELDS_OF_LEARNING',prq.field_of_learning) field_of_learning_meaning, prq.sub_field, prq.registration_date, prq.registration_number from per_qualifications qua, per_qualification_types pqt, per_establishment_attendances esa, per_establishments est, per_za_formal_qualifications prq WHERE qua.qualification_type_id = pqt.qualification_type_id and qua.attendance_id = esa.attendance_id (+) and esa.establishment_id = est.establishment_id (+) and prq.qualification_id(+) = qua.qualification_id

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
, QUA.TITLE
, QUA.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
, QUA.REIMBURSEMENT_ARRANGEMENTS
, QUA.TRAINING_COMPLETED_UNITS
, QUA.TOTAL_TRAINING_AMOUNT
, QUA.START_DATE
, QUA.END_DATE
, QUA.LICENSE_NUMBER
, QUA.EXPIRY_DATE
, QUA.LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE
, QUA.AWARDING_BODY
, QUA.TUITION_METHOD
, HR_GENERAL.DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) TUITION_METHOD_MEANING
, QUA.GROUP_RANKING
, QUA.COMMENTS
, QUA.QUALIFICATION_TYPE_ID
, PQT.NAME
, QUA.ATTENDANCE_ID
, NVL(ESA.ESTABLISHMENT
, EST.NAME) ESTABLISHMENT
, EST.LOCATION
, 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.LAST_UPDATE_DATE
, QUA.LAST_UPDATED_BY
, QUA.LAST_UPDATE_LOGIN
, QUA.CREATED_BY
, QUA.CREATION_DATE
, PRQ.LEVEL_ID
, PRQ.FIELD_OF_LEARNING
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_FIELDS_OF_LEARNING'
, PRQ.FIELD_OF_LEARNING) FIELD_OF_LEARNING_MEANING
, PRQ.SUB_FIELD
, PRQ.REGISTRATION_DATE
, PRQ.REGISTRATION_NUMBER
FROM PER_QUALIFICATIONS QUA
, PER_QUALIFICATION_TYPES PQT
, PER_ESTABLISHMENT_ATTENDANCES ESA
, PER_ESTABLISHMENTS EST
, PER_ZA_FORMAL_QUALIFICATIONS PRQ
WHERE QUA.QUALIFICATION_TYPE_ID = PQT.QUALIFICATION_TYPE_ID
AND QUA.ATTENDANCE_ID = ESA.ATTENDANCE_ID (+)
AND ESA.ESTABLISHMENT_ID = EST.ESTABLISHMENT_ID (+)
AND PRQ.QUALIFICATION_ID(+) = QUA.QUALIFICATION_ID