Invoice Payments query

Summary: Create New Invoice Payments Reports

Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to query invoice payment details. The query should include both prepayments and standard payments in a single dataset. The columns are:

DataSet:

Hi Expert, Could you please correct the below query.

In my query return zero value for "Discount", how to get discount amount and how to calculate "Total Payment Amount"

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

Oracle Fusion Applications Cloud is 

24B

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