View: HRFV_SUBJECTS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_SUBJECTS

View Text

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
, SUB.GRADE_ATTAINED SUBJECT_GRADE_ATTAINED
, SUB.START_DATE SUBJECT_START_DATE
, SUB.END_DATE SUBJECT_END_DATE
, QUT.NAME QUALIFICATION_TYPE
, QUA.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 QUT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ESTABLISHMENT_ATTENDANCES ATT
, PER_ESTABLISHMENTS EST
, PER_QUALIFICATIONS QUA
, PER_SUBJECTS_TAKEN SUB
WHERE SUB.QUALIFICATION_ID = QUA.QUALIFICATION_ID
AND QUA.QUALIFICATION_TYPE_ID = QUT.QUALIFICATION_TYPE_ID
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) WITH READ ONLY

Columns