Tuesday, December 10, 2013

AP Payable Invoice Status function in Oracle Applications

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