Query to get SLA accounts from AP Invoices
Summary:
I have Project AP invoices which are accounted in AP. we need the Debit and credit information from SLA. can any one provide query for the same.
Content (required):
we have AP Distribution id, for a specific distribution we want retrieve the account information. we we query based on event id it return all the SLA account for that invoice. i need SLA for a Specific distribuion. How to get the same using SQL
Version (include the version you are using, if applicable):
23C
Code Snippet (add any code snippets that support your topic, if applicable):
Select xal.*
,GLCC.ACCOUNT_TYPE