Following SQL Query can be used to get Oracle HR Organization Hierarchy:
SELECT
LPAD(' ',10*(LEVEL-1)) || org.name hierarchy, org.organization_id
FROM
hr_all_organization_units org,
per_org_structure_elements pose
WHERE 1=1
AND org.organization_id = pose.organization_id_child
AND pose.org_structure_version_id = 61
--and org.name like '201.Financiale Services'
START WITH
SELECT
LPAD(' ',10*(LEVEL-1)) || org.name hierarchy, org.organization_id
FROM
hr_all_organization_units org,
per_org_structure_elements pose
WHERE 1=1
AND org.organization_id = pose.organization_id_child
AND pose.org_structure_version_id = 61
--and org.name like '201.Financiale Services'
START WITH
pose.organization_id_parent = 115 -- Orgnization of parent id -- provide the id from which level the downward hierarchy should be displaed
CONNECT BY PRIOR
pose.organization_id_child = pose.organization_id_parent
ORDER SIBLINGS BY
org.location_id,
pose.organization_id_child;
Other Articles Related To Oracle HRMS Module
CONNECT BY PRIOR
pose.organization_id_child = pose.organization_id_parent
ORDER SIBLINGS BY
org.location_id,
pose.organization_id_child;
Other Articles Related To Oracle HRMS Module
- Create Employee Address Using Oracle HRMS API
- Create Employee Contact Using Oracle HRMS API
- Create Employee Element Entry Using Oracle HRMS API
- Create Employee In Oracle Apps Using Oracle HRMS API
- Create or Update Employee Phone Using Oracle HRMS API
- Delete Employee Element Entry Using Oracle HRMS API
- Script To Rehire An Employee Using Oracle HRMS API
- Update An Employee In Oracle Apps Using Oracle HRMS API
- Update Employee Address Using Oracle HRMS API
Can you give the script to display the Approval hierarchy
ReplyDelete