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|
Category: OracleSaaS