In R12 use below query to fetch Legal entity details for Operating Unit
Select a.organization_id,
a.organization_code,
a.organization_name,
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,
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.organizatio n_id
and C.LEGAL_ENTITY_ID=a.LEGAL_ENTI TY
AND d.ledger_id=a.set_of_books_id;
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.organizatio
and C.LEGAL_ENTITY_ID=a.LEGAL_ENTI
AND d.ledger_id=a.set_of_books_id;