This view is based on tables hr_organization_information and hr_all_organization_units_tl. It will contain information about the Operating Units.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT ORG.ORGANIZATION_ID ID , OTL.NAME VALUE FROM HR_ALL_ORGANIZATION_UNITS ORG , HR_ORGANIZATION_INFORMATION ORGI , HR_ALL_ORGANIZATION_UNITS_TL OTL WHERE ORG.ORGANIZATION_ID = ORGI.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = OTL.ORGANIZATION_ID AND OTL.LANGUAGE = USERENV('LANG') AND ORGI.ORG_INFORMATION_CONTEXT = 'CLASS' AND ORGI.ORG_INFORMATION1 = 'OPERATING_UNIT'