Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

SQL Statement for AR invoice including attachment line information

edited Jul 10, 2021 12:01AM in Reporting and Analytics for ERP 5 comments

Summary

Receivables Transactions Extract

Content

Hello 

I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have reviewed the following report for the extraction :

Receivables Transactions Extract

I think I need to inquiry the following tables 

RA_CUSTOMER_TRX_ALL

FND_ATTACHMENTS

Please Advise

Thanks

 

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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