AP Payable Invoice Status function in Oracle Applications
SELECT APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS
(
I.INVOICE_ID
,I.INVOICE_AMOUNT
,I.PAYMENT_STATUS_FLAG
,I.INVOICE_TYPE_LOOKUP_CODE
) Approval_Status
,invoice_num
FROM AP_INVOICES I
WHERE invoice_num = '123456';
No comments:
Post a Comment