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

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaS