You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

link between AP_INVOICES_ALL and gl_balances

in Payables, Payments & Cash Management 3 comments

Summary:

Hello All , 

Could anyone tell me how to join table AP_INVOICES_ALL and gl_balances ?

what is the specified join condition between them?

I have already sum of amounts from gl_balances, now I need Invoice_num or Tranaction number for that Gl_balances transactions.

Thanks in advance!

Content (please ensure you mask any confidential information):


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

 23 D

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!