In this article, we will look into fetching the Recruiting Location Hierarchy for ORC.
Recruiting Locations are different from the Core HR Locations and we need to configure the Recruiting Locations and then add them to Recruiting Tree Geography Hierarchy.
SELECT
hg_parent.geography_element1 parent_geography_element1
,hg_parent.geography_element2 parent_geography_element2
,hg_parent.geography_element3 parent_geography_element3
,hg_parent.geography_element4 parent_geography_element4
,hg.geography_element1
,hg.geography_element2
,hg.geography_element3
,hg.geography_element4
FROM IRC_GEO_HIER_NODES ighn,
HZ_GEOGRAPHIES hg,
IRC_GEO_HIER_NODES ighn_parent,
HZ_GEOGRAPHIES hg_parent
WHERE hg.geography_id = ighn.geography_id
AND ighn.parent_geo_node_id = ighn_parent.geography_node_id
AND hg_parent.geography_id = ighn_parent.geography_id
GROUP BY hg_parent.geography_element1
,hg_parent.geography_element2
,hg_parent.geography_element3
,hg_parent.geography_element4
,hg.geography_element1
,hg.geography_element2
,hg.geography_element3
,hg.geography_element4Output will look like:
