Need an help for SQL query

Summary:

Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL which gives the output for LE registrations.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DECODE ( xre.legal_entity_name,'','Establishment','Legal Entity') organization_type,

 xre.legal_entity_id legal_entity_id,

 xre.legal_entity_name legal_entity_name,

 xre.establishment_id establishment_id,

 xre.establishment_name establishment_name,

 xre.registration_code_le,

 xre.registration_code_etb,

 xre.registration_id,