Query to find out GL code combinations used in a bank account (LE and Org access Level)

Summary:

I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle documentation but its not working for me.

Content (please ensure you mask any confidential information):

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

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

select ba.bank_account_id, bank_account_name, bank_account_num,

glccba_c.segment1||'.'||glccba_c.segment2||'.'||glccba_c.segment3||'.'||glccba_c.segment4||'.'||glccba_c.segment5 bankaccountLE_cash_acct,