SQL Query to get Oracle HR Organization Hierarchy
SQL Query 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 porg.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
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 porg.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
1 comment:
[url=http://is.gd/co5g6s][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://archive.org/details/dunmofohan]Rastrear Celular Pelo Gps Online Gratis[/url] [url=http://youthofknowledge.webs.com/apps/profile/109034678/]Numeros De Telefone De Rastreamento Reverso Gratis [/url] http://archive.org/details/pechichoudre mobile spy software iphone free mobiltelefon spy gratis iphone Spion auf Text Nachrichten freie app iphone telefono celular espia software funciona
Celular Espiao Software Cnet
http://thankheavenforbeer.com/2009/03/30/guest-post-rogue-imperial-ipa-review-by-big-tex/#comment-550629 http://www.cebupacificfares.com/amazing-thailand-grand-sale-bangkok-promo/comment-page-1/#comment-30320 LEGO coches espia jet free mobile phone locator software pc camera do espiao caneta hd
[url=http://archive.org/details/oroslirol] Cell Phone Spionera Ingen Programvara Installera Mottagartelefonen [/url] [url=http://archive.org/details/pedigjacklet]Titta Pa Himym Sasong 8 Online Cucirca[/url] http://archive.org/details/taiblufsupa Spy kids wiki juni text message spy software blackberry free mobile phone tapping software download latt att installera mobiltelefon spionprogram
Post a Comment