SELECT ORGANIZATION_ID , NAME FROM HR_ALL_ORGANIZATION_UNITS UNION SELECT ORGANIZATION_ID , NAME VALUE FROM HR_LEGAL_ENTITIES UNION SELECT ORGANIZATION_ID , ORGANIZATION_NAME VALUE FROM ORG_ORGANIZATION_DEFINITIONS UNION SELECT OP.ORGANIZATION_ID , OP.NAME VALUE FROM HR_OPERATING_UNITS OP , HR_LEGAL_ENTITIES LE WHERE OP.LEGAL_ENTITY_ID = LE.ORGANIZATION_ID UNION SELECT ORGANIZATION_ID , NAME VALUE FROM PER_BUSINESS_GROUPS UNION SELECT ORGANIZATION_ID , NAME VALUE FROM PER_ORGANIZATION_UNITS