VIEW: APPS.HRIBV_SUPV_HRCHY_ROLLUP_X

Source

View Text - Preformatted

SELECT bgrT.name supervisor_business_group , per.full_name supervisor_person_name , svl.sup_absolute_level supervisor_level , per.employee_number supervisor_employee_number , per2.full_name subordinate_person_name , per2.employee_number subordinate_employee_number , HR_BIS.BIS_DECODE_LOOKUP('YES_NO',svl.sub_primary_asg_flag_code) subordinate_primary_asg_flag , svl.sub_primary_asg_flag_code subord_primary_asg_flag_code , svl.sub_absolute_level subordinate_level , ssvl.sub_absolute_level sub_ro_level , svl.sup_business_group_id supervisor_business_group_id , svl.sup_person_id supervisor_person_id , svl.sup_assignment_id supervisor_assignment_id , svl.sub_business_group_id subordinate_business_group_id , svl.sub_person_id subordinate_person_id , svl.sub_assignment_id subordinate_assignment_id , ssvl.sub_business_group_id sub_ro_business_group_id , ssvl.sub_person_id sub_ro_person_id , ssvl.sub_assignment_id sub_ro_assignment_id FROM hri_cs_suph_x_v svl , hri_cs_suph_x_v ssvl , hr_all_organization_units_tl bgrT , per_people_x per , per_people_x per2 WHERE svl.sub_assignment_id = ssvl.sup_assignment_id AND svl.sup_business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND svl.sup_person_id = per.person_id AND svl.sub_person_id = per2.person_id WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME SUPERVISOR_BUSINESS_GROUP
, PER.FULL_NAME SUPERVISOR_PERSON_NAME
, SVL.SUP_ABSOLUTE_LEVEL SUPERVISOR_LEVEL
, PER.EMPLOYEE_NUMBER SUPERVISOR_EMPLOYEE_NUMBER
, PER2.FULL_NAME SUBORDINATE_PERSON_NAME
, PER2.EMPLOYEE_NUMBER SUBORDINATE_EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SVL.SUB_PRIMARY_ASG_FLAG_CODE) SUBORDINATE_PRIMARY_ASG_FLAG
, SVL.SUB_PRIMARY_ASG_FLAG_CODE SUBORD_PRIMARY_ASG_FLAG_CODE
, SVL.SUB_ABSOLUTE_LEVEL SUBORDINATE_LEVEL
, SSVL.SUB_ABSOLUTE_LEVEL SUB_RO_LEVEL
, SVL.SUP_BUSINESS_GROUP_ID SUPERVISOR_BUSINESS_GROUP_ID
, SVL.SUP_PERSON_ID SUPERVISOR_PERSON_ID
, SVL.SUP_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, SVL.SUB_BUSINESS_GROUP_ID SUBORDINATE_BUSINESS_GROUP_ID
, SVL.SUB_PERSON_ID SUBORDINATE_PERSON_ID
, SVL.SUB_ASSIGNMENT_ID SUBORDINATE_ASSIGNMENT_ID
, SSVL.SUB_BUSINESS_GROUP_ID SUB_RO_BUSINESS_GROUP_ID
, SSVL.SUB_PERSON_ID SUB_RO_PERSON_ID
, SSVL.SUB_ASSIGNMENT_ID SUB_RO_ASSIGNMENT_ID
FROM HRI_CS_SUPH_X_V SVL
, HRI_CS_SUPH_X_V SSVL
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PER
, PER_PEOPLE_X PER2
WHERE SVL.SUB_ASSIGNMENT_ID = SSVL.SUP_ASSIGNMENT_ID
AND SVL.SUP_BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND SVL.SUP_PERSON_ID = PER.PERSON_ID
AND SVL.SUB_PERSON_ID = PER2.PERSON_ID WITH READ ONLY