View: HRFV_QUALIFICATIONS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, QUA.TITLE QUALIFICATION_TITLE
, QUA.GRADE_ATTAINED GRADE_ATTAINED
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, QUA.STATUS) QUALIFICATION_STATUS
, QUA.AWARDED_DATE AWARDED_DATE
, QUA.FEE FEE
, QUA.FEE_CURRENCY FEE_CURRENCY
, QUA.TRAINING_COMPLETED_AMOUNT TRAINING_COMPLETED_AMOUNT
, QUA.REIMBURSEMENT_ARRANGEMENTS REIMBURSEMENT_ARRANGEMENTS
, QUA.TOTAL_TRAINING_AMOUNT TOTAL_TRAINING_AMOUNT
, QUA.TRAINING_COMPLETED_UNITS TRAINING_COMPLETED_UNITS
, QUA.START_DATE QUALIFICATION_START_DATE
, QUA.END_DATE QUALIFICATION_END_DATE
, QUA.LICENSE_NUMBER LICENSE_NUMBER
, QUA.EXPIRY_DATE LICENSE_EXPIRY_DATE
, QUA.LICENSE_RESTRICTIONS LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE PROJECTED_COMPLETION_DATE
, QUA.AWARDING_BODY AWARDING_BODY
, HR_BIS.BIS_DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) METHOD_OF_REIMBURSEMENT
, QUA.GROUP_RANKING GROUP_RANKING
, QUA.COMMENTS COMMENTS
, NVL(EST.NAME
, ATT.ESTABLISHMENT) SCHOOL_OR_COLLEGE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES'
, QUT.CATEGORY) QUALIFICATION_CATEGORY
, QUT.NAME QUALIFICATION_TYPE_NAME
, '_DF:PER:PER_QUALIFICATIONS:QUA'
, QUA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
, EST.ESTABLISHMENT_ID SCHOOL_OR_COLLEGE_ID
, QUA.QUALIFICATION_ID QUALIFICATION_ID
FROM PER_QUALIFICATION_TYPES QUT
, PER_PEOPLE_X PEO
, PER_ESTABLISHMENT_ATTENDANCES ATT
, PER_ESTABLISHMENTS EST
, PER_QUALIFICATIONS QUA
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE 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) UNION ALL SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, QUA.TITLE QUALIFICATION_TITLE
, QUA.GRADE_ATTAINED GRADE_ATTAINED
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, QUA.STATUS) QUALIFICATION_STATUS
, QUA.AWARDED_DATE AWARDED_DATE
, QUA.FEE FEE
, QUA.FEE_CURRENCY FEE_CURRENCY
, QUA.TRAINING_COMPLETED_AMOUNT TRAINING_COMPLETED_AMOUNT
, QUA.REIMBURSEMENT_ARRANGEMENTS REIMBURSEMENT_ARRANGEMENTS
, QUA.TOTAL_TRAINING_AMOUNT TOTAL_TRAINING_AMOUNT
, QUA.TRAINING_COMPLETED_UNITS TRAINING_COMPLETED_UNITS
, QUA.START_DATE QUALIFICATION_START_DATE
, QUA.END_DATE QUALIFICATION_END_DATE
, QUA.LICENSE_NUMBER LICENSE_NUMBER
, QUA.EXPIRY_DATE LICENSE_EXPIRY_DATE
, QUA.LICENSE_RESTRICTIONS LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE PROJECTED_COMPLETION_DATE
, QUA.AWARDING_BODY AWARDING_BODY
, HR_BIS.BIS_DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) METHOD_OF_REIMBURSEMENT
, QUA.GROUP_RANKING GROUP_RANKING
, QUA.COMMENTS COMMENTS
, NULL SCHOOL_OR_COLLEGE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES'
, QUT.CATEGORY) QUALIFICATION_CATEGORY
, QUT.NAME QUALIFICATION_TYPE_NAME
, '_DF:PER:PER_QUALIFICATIONS:QUA'
, QUA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
, TO_NUMBER(NULL) SCHOOL_OR_COLLEGE_ID
, QUA.QUALIFICATION_ID QUALIFICATION_ID
FROM PER_QUALIFICATION_TYPES QUT
, PER_PEOPLE_X PEO
, PER_QUALIFICATIONS QUA
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE QUA.QUALIFICATION_TYPE_ID = QUT.QUALIFICATION_TYPE_ID
AND QUA.PERSON_ID = PEO.PERSON_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