Legal Entity address table in oracle fusion

Legal Entity address table in oracle fusion

Legal Entity is the first step we do in oracle fusion for the BU’s implementation. In Legal entity we do mentioned all legal information’s about the firm and the complete address information’s too. Then we create our organization structure under that Legal entity. Legal entity addresses information’s stores in the legal entity address table in oracle fusion. Here below I will try to share the detail Legal Entity address table and the complete sql query to extract the complete legal entity information with addresses in oracle fusion.

3 Important legal entity address table in oracle fusion

1.xle_registrations

2.xle_entity_profiles

3.HZ_LOCATIONS

Usually legal entity addresses stores in the HZ_LOCATIONS table in oracle fusion.

Detail SQL query using the legal entity address table in oracle fusion

select REGISTERED_NAME,REGISTRATION_NUMBER,

ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,

CITY,STATE,PROVINCE,COUNTY,ADDRESS_STYLE,

ADDRESS_LINES_PHONETIC,COUNTRY,POSTAL_CODE

 from xle_registrations a1,

xle_entity_profiles a2,

HZ_LOCATIONS A3

where 1=1

and a2.legal_entity_id=a1.source_id

and source_table='XLE_ENTITY_PROFILES'

and a1.location_id=a3.location_id