SQL Query to find Legal Entity, Org ID

Select a.organization_id, a.organization_code, a.organization_name, 
a.operating_unit, b.name OU, a.set_of_books_id,d.name LEDGER,
a.legal_entity,c.name LE_NAME
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
apps. xle_entity_profiles c,
apps. gl_ledgers d
Where a.operating_unit=b.organization_id
and C.LEGAL_ENTITY_ID=a.LEGAL_ENTITY
AND d.ledger_id=a.set_of_books_id;