query to get a tax registration number for legal entity

Summary:

query to get the tax registration number for legal entity

Content (please ensure you mask any confidential information):

I want to create a SQL to retrieve a tax registration number based on a legal entity.
I have looked at tables such as ‘XLE_REGISTRATIONS’ to try it out,
but it does not contain the expected number.

The expected tax registration number is visible in the following screen navigation.
Setup and Maintenance > Transaction Tax > Manage Tax Registrations