[Home] [Help]
View: PO_EMPLOYEE_HIERARCHIES_ALL_V
View Text
SELECT DISTINCT HRE.FULL_NAME
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, PPS.POSITION_ID
, PEH.ORG_ID
FROM HR_EMPLOYEES_ALL_V HRE
, PER_POSITION_STRUCTURES_ALL_V PPS
, PO_EMPLOYEE_HIERARCHIES PEH
WHERE PEH.POSITION_STRUCTURE_ID = PPS.POSITION_ID
AND PEH.SUPERIOR_ID = HRE.EMPLOYEE_ID
Columns
Name |
FULL_NAME |
EMPLOYEE_NUM |
EMPLOYEE_ID |
POSITION_ID |
ORG_ID |