Need a query to get the GL ACCOUNT details from manage project costs page

Summary:

Hi All,

I need a query to get the GL ACCOUNT details from the manage project costs → View accounting page.

below is the screenshot of where I need the data.

Content (please ensure you mask any confidential information):

I already prepared a query and attached it below. Please check and provide your inputs or if you have any sample queries, you can also give me that.

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

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

(SELECT DISTINCT (gcc.segment3

             || '-'

             || gcc.segment4

             || '-'

             || gcc.segment5) AS accounts
             FROM            gl_code_combinations gcc,