How to get invoice withheld and applied prepayment amount in SQL?
Thursday, 27 December 2007
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
The entry 'How to get invoice withheld and applied prepayment amount in SQL?' was posted
on December 27th, 2007 at 4:47 am
and last modified on December 27th, 2007 at 4:51 am, and is filed under Oracle Application.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.