Legal entity table in Oracle Apps r12

Legal entity table in r12

In this post , We will be discussing about legal entity table in r12. Legal entity we do create in oracle apps while defining the organization structure. Legal entity represents the government registered entity of the organization having registration details. Legal entity tables help to store the registration details for the legal entity in oracle r12. We do get the information about registrations with complete registered address to government in r12. Here below I will try to share the legal entity table and complete sql query using legal entity table to extract the legal entity information’s.

Legal entity table in Oracle Apps r12

Important legal entity table in r12

1. xle_firstparty_information_v

Click To Know More

SQL query using legal entity table in r12 to extract the legal entity information’s in r12

Here below is the sql query to extract the legal entity information in r12

SELECT xle_firstpty.NAME,

       xle_firstpty.registration_number,

       xle_firstpty.effective_from,

       xle_firstpty.location_id,

       xle_firstpty.address_line_1,

       xle_firstpty.address_line_2,

       xle_firstpty.address_line_3,

       xle_firstpty.town_or_city,

       xle_firstpty.region_1,

       xle_firstpty.region_2,

       xle_firstpty.region_3,

       xle_firstpty.postal_code,

       xle_firstpty.country,

       xle_firstpty.address_style

  FROM apps.xle_firstparty_information_v xle_firstpty

 WHERE 1 = 1