Oracle Cloud ERP – Query to get Legal Entity Details

SELECT
    le.legal_entity_id,
    le_party.party_name,
    le_reg.registration_number,
    le_party.party_id,
    le_party.address1,
    le_party.city,
    le_party.country,
    le_party.postal_code,
    le_party.primary_phone_number,
    le_party.email_address,
    le_party.url
FROM
    xle_entity_profiles    le,
    hz_parties             le_party,
    xle_registrations      le_reg
WHERE
        le_reg.source_table = 'XLE_ENTITY_PROFILES'
    AND le_reg.source_id = le.legal_entity_id
    AND le_party.party_id = le.party_id