http://aporaclepayables.blogspot.com/2017/02/to-see-partial-payments.html
select distinct c.DOC_SEQUENCE_VALUE APV,
b.DOC_SEQUENCE_VALUE APN,
c.CHECK_DATE,
d.USER_NAME,
decode(b.PAYMENT_STATUS_FLAG,
'P',
'Partially Paid',
b.PAYMENT_STATUS_FLAG) status,
a.ORG_ID
from ap_invoice_payments_all a,
ap.ap_invoices_all# b,
ap_checks_all c,
fnd_user d
where a.INVOICE_ID = b.INVOICE_ID
and a.CHECK_ID = c.CHECK_id
and d.USER_ID = c.CREATED_BY
and a.ORG_ID = c.ORG_ID
and a.ORG_ID = b.ORG_ID
and b.payment_status_flag = 'P'
and c.CHECK_DATE > '01-JAN-2016'
