Oracle Apps HRMS Organization Stucture

Find out the Hierarchy of the Organization Information


SELECT HAOU.NAME ,HAOU1.NAME,HAOU1.TYPE,HOI.ORG_INFORMATION_CONTEXT ,HAOU1.INTERNAL_ADDRESS_LINE,HAOU1.INTERNAL_EXTERNAL_FLAG,
HL.DESCRIPTION,HL.ADDRESS_LINE_1,HOIT.ORG_INFORMATION_TYPE,HOIT.DESCRIPTION,HOIT.DISPLAYED_ORG_INFORMATION_TYPE,HL.POSTAL_CODE,HL.COUNTRY
FROM HR_ALL_ORGANIZATION_UNITS HAOU,HR_ALL_ORGANIZATION_UNITS HAOU1,HR_LOCATIONS HL,HR_ORGANIZATION_INFORMATION HOI,
HR_ORG_INFORMATION_TYPES HOIT
WHERE HAOU.ORGANIZATION_ID = HAOU1.BUSINESS_GROUP_ID
AND HL.LOCATION_ID = HAOU1.LOCATION_ID
AND HAOU1.ORGANIZATION_ID = HOI.ORG_INFORMATION_ID
AND HOIT.ORG_INFORMATION_TYPE = HOI.ORG_INFORMATION_CONTEXT
AND HAOU1.INTERNAL_EXTERNAL_FLAG IN ('INT', 'EXT')
ORDER BY 1