VIEW: APPS.HRFV_SUBJECTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,hr_bis.bis_decode_lookup('PER_SUBJECTS',sub.subject) subject ,hr_bis.bis_decode_lookup('YES_NO',sub.major) major ,hr_bis.bis_decode_lookup('PER_SUBJECT_STATUSES',sub.subject_status) subject_status ,sbt.grade_attained subject_grade_attained ,sub.start_date subject_start_date ,sub.end_date subject_end_date ,qtt.name qualification_type ,qat.title qualification_title ,est.name school_or_college_name ,qua.start_date qualification_start_date ,qua.end_date qualification_end_date ,qua.business_group_id business_group_id ,peo.person_id person_id ,sub.qualification_id qualification_id FROM per_qualification_types_tl qtt ,hr_all_organization_units_tl bgrT ,per_people_x peo ,per_establishment_attendances att ,per_establishments est ,per_qualifications qua ,per_qualifications_tl qat ,per_subjects_taken sub ,per_subjects_taken_tl sbt WHERE sub.qualification_id = qua.qualification_id AND sub.qualification_id = qat.qualification_id AND qat.language = userenv('LANG') AND qua.qualification_type_id = qtt.qualification_type_id AND qtt.language = userenv('LANG') AND qua.attendance_id = att.attendance_id AND att.person_id = peo.person_id (+) AND att.establishment_id = est.establishment_id(+) AND qua.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND qua.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, qua.business_group_id) AND sub.subjects_taken_id = sbt.subjects_taken_id AND sbt.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECTS'
, SUB.SUBJECT) SUBJECT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SUB.MAJOR) MAJOR
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, SUB.SUBJECT_STATUS) SUBJECT_STATUS
, SBT.GRADE_ATTAINED SUBJECT_GRADE_ATTAINED
, SUB.START_DATE SUBJECT_START_DATE
, SUB.END_DATE SUBJECT_END_DATE
, QTT.NAME QUALIFICATION_TYPE
, QAT.TITLE QUALIFICATION_TITLE
, EST.NAME SCHOOL_OR_COLLEGE_NAME
, QUA.START_DATE QUALIFICATION_START_DATE
, QUA.END_DATE QUALIFICATION_END_DATE
, QUA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
, SUB.QUALIFICATION_ID QUALIFICATION_ID
FROM PER_QUALIFICATION_TYPES_TL QTT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ESTABLISHMENT_ATTENDANCES ATT
, PER_ESTABLISHMENTS EST
, PER_QUALIFICATIONS QUA
, PER_QUALIFICATIONS_TL QAT
, PER_SUBJECTS_TAKEN SUB
, PER_SUBJECTS_TAKEN_TL SBT
WHERE SUB.QUALIFICATION_ID = QUA.QUALIFICATION_ID
AND SUB.QUALIFICATION_ID = QAT.QUALIFICATION_ID
AND QAT.LANGUAGE = USERENV('LANG')
AND QUA.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')
AND QUA.ATTENDANCE_ID = ATT.ATTENDANCE_ID
AND ATT.PERSON_ID = PEO.PERSON_ID (+)
AND ATT.ESTABLISHMENT_ID = EST.ESTABLISHMENT_ID(+)
AND QUA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND QUA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, QUA.BUSINESS_GROUP_ID)
AND SUB.SUBJECTS_TAKEN_ID = SBT.SUBJECTS_TAKEN_ID
AND SBT.LANGUAGE = USERENV('LANG') WITH READ ONLY