--Oracle R12 Legal Entity details Query
SELECT xep.legal_entity_id, xep.party_id, xep.legal_entity_identifier,
xep.name legal_entity, hp.party_name legal_entity_name
FROM xle_entity_profiles xep, hz_parties hp
WHERE xep.party_id = hp.party_id
ORDER BY hp.party_name