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,
0