This query Gets all the active Business units and associated Legal entities in Oracle Cloud ERP. The query is shared below:
SELECT ffbuv.bu_name BU_NAME
,xep.name LEGAL_ENTITY_NAME
FROM
fun_fin_business_units_v ffbuv
,xle_entity_profiles xep
WHERE ffbuv.legal_entity_id=xep.legal_entity_id
The Query can be directly pasted in Oracle cloud Report Data model to get the output.