Legal Entity and Operating Unit Realtionship

select
a.LEGAL_ENTITY_NAME,
c.NAME OU,
b.ORGANIZATION_CODE inv_org
from
GMF_LEGAL_ENTITIES a,
org_organization_definitions b,
hr_operating_units c
where
a.LEGAL_ENTITY_ID=b.LEGAL_ENTITY
and
b.OPERATING_UNIT=c.ORGANIZATION_ID;