What is the query to be able to obtain the value of unpaid amount?

Summary:

A report is being designed, and it is necessary to identify if the invoice is paid in full, the field payment_satu_flag is not working properly.

We have multiple invoices fully paid, but the payment_status_flag field is not syncing correctly

Content (please ensure you mask any confidential information):

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

oracle fussion ERP 23D

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