Request for SQL Query to Retrieve Cash Balances with Specific Columns

Summary:

Provide a SQL query for Cash Balances to include columns with Legal Entity Name, Entity ID, Bank Account Number, Bank Account Name, Bank Account Type, Currency, Account Ending Balance, and Account Ending Balance (USD) in cash management.

Content (please ensure you mask any confidential information):

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

24C

Code Snippet (add any code snippets that support your topic, if applicable): select
distinct xep.name legal_entity_name,
gcc.segment1 Entity_ID,
CE_BANK_AND_ACCOUNT_UTIL.get_masked_bank_acct_num(ba.BANK_ACCOUNT_ID) bank_account_num1,
ba.bank_account_name bank_account_name,