Query to pull Legal Entity Registration Number

 SELECT XREG.registered_name,XJUR.name,XREG.REGISTRATION_NUMBER
     FROM XLE_JURISDICTIONS_TL XJUR , XLE_REGISTRATIONS XREG 
where 1=1
and XJUR.jurisdiction_id = XREG.jurisdiction_id
and XJUR.language='US'
and XJUR.name='Quebec Provincial Tax'--Jurisdiction Name, which you will find on Manage Legal Entity Registrations Page    
and XREG.source_table='XLE_ENTITY_PROFILES'
and XREG.registered_name='XYZ'--LE Name