how to query accounting details of project billing event by using sql query

Summary:

Hi Team,

we have created a Project billing event and generated revenue for this event and in manage revenue distributions screen we have executed create accounting and posted to GL. by using below code I'm able to get event details, but i want your help in bringing both credit and debit accounting strings , please provide the tables and joins to be used bring the accounting entries of this event.

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 DISTINCT OCT.name contract_type ,OCH.contract_number