Skip to Main Content

SQL Developer Web

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

SQL query for finding customer invoice paid status

NithinAMar 11 2024 — edited Mar 11 2024

Hi Team,

I wrote a sql query to extracting customer invoices data here I am facing issue unable to find the Invoice paid status like(Fully Paid, partially Paid or Unpaid) in the table ra_customer_trx_all directly.

Kindly help me the sql query to find the Invoice paid status.

Thank you in advance.

Best Regards,

Srinivas.

AR Invoice Paid Status.docx

Comments
Post Details
Added on Mar 11 2024
0 comments
86 views