VIEW: APPS.HRIBV_SUPV_HRCHY_V

Source

View Text - Preformatted

SELECT per.full_name supervisor_name , svl.sup_level supervisor_level , per.employee_number supervisor_employee_number , per2.full_name subordinate_name , svl.sub_level subordinate_level , per2.employee_number subordinate_employee_number , svl.effective_start_date effective_start_date , svl.effective_end_date effective_end_date , svl.sub_relative_level subordinate_relative_level , svl.sup_invalid_flag_code supervisor_invalid_flag_code , svl.sub_invalid_flag_code subordinate_invalid_flag_code , svl.sup_person_id supervisor_id , svl.sup_assignment_id supervisor_assignment_id , svl.sub_person_id subordinate_id , svl.sub_assignment_id subordinate_assignment_id FROM hri_cs_suph svl , per_all_people_f per , per_all_people_f per2 WHERE svl.sup_person_id = per.person_id AND svl.sub_person_id = per2.person_id AND trunc(sysdate) between per.effective_start_date and per.effective_end_date AND trunc(sysdate) between per2.effective_start_date and per2.effective_end_date AND svl.sub_primary_asg_flag_code = 'Y' WITH READ ONLY

View Text - HTML Formatted

SELECT PER.FULL_NAME SUPERVISOR_NAME
, SVL.SUP_LEVEL SUPERVISOR_LEVEL
, PER.EMPLOYEE_NUMBER SUPERVISOR_EMPLOYEE_NUMBER
, PER2.FULL_NAME SUBORDINATE_NAME
, SVL.SUB_LEVEL SUBORDINATE_LEVEL
, PER2.EMPLOYEE_NUMBER SUBORDINATE_EMPLOYEE_NUMBER
, SVL.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SVL.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, SVL.SUB_RELATIVE_LEVEL SUBORDINATE_RELATIVE_LEVEL
, SVL.SUP_INVALID_FLAG_CODE SUPERVISOR_INVALID_FLAG_CODE
, SVL.SUB_INVALID_FLAG_CODE SUBORDINATE_INVALID_FLAG_CODE
, SVL.SUP_PERSON_ID SUPERVISOR_ID
, SVL.SUP_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, SVL.SUB_PERSON_ID SUBORDINATE_ID
, SVL.SUB_ASSIGNMENT_ID SUBORDINATE_ASSIGNMENT_ID
FROM HRI_CS_SUPH SVL
, PER_ALL_PEOPLE_F PER
, PER_ALL_PEOPLE_F PER2
WHERE SVL.SUP_PERSON_ID = PER.PERSON_ID
AND SVL.SUB_PERSON_ID = PER2.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PER2.EFFECTIVE_START_DATE
AND PER2.EFFECTIVE_END_DATE
AND SVL.SUB_PRIMARY_ASG_FLAG_CODE = 'Y' WITH READ ONLY