How to get invoice withheld and applied prepayment amount in SQL?

Use the following API column in your SQL respectively:
AP_INVOICES_PKG.GET_PREPAY_AMOUNT_APPLIED(AI.INVOICE_ID) PREPAY_AMOUNT_APPLIED
and
AP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID) AMOUNT_WITHHELD

Leave a comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.