View: BIS_ALL_ORGANIZATIONS_V

View Text

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

Columns