AP Invoice Payment Status Code in oarcle

SELECT PAYMENT_STATUS_FLAG FROM AP_INVOICE_ALL
WHERE INVOICE_NUM = '<Invoice_number>' ;



Payment_status_flag is available at header level, Statuses will be
'Y'- Fully paid
'P'- Partially Paid
'N'- Not Paid