Which utility is called in get_approval_status

Which utility is called in get_approval_status

In this post , we will be discuss about the utility which is called for get_approval_status. One AP Invoice have multiple Status but that doesn't stores in the Database tables. We cannot get the invoice approval status direct from the AP Invoices table. To get the Invoice status , Oracle has given the Standard utility called AP_INVOICES_PKG.GET_APPROVAL_STATUS to get the status for the AP invoices. This utility , drive the invoice status from multiple parameters in oracle apps. Here below i will describe about this utility is called in get_approval_status.

 Which utility is called in get_approval_status

How to get the Payables Invoice status from utility is called in get_approval_status

AP_INVOICES_PKG.GET_APPROVAL_STATUS :- This is the standard utility which helps to get the invoice status for AP Invoices. This is the standard API to get the Invoice approval status in oracle apps. 

These are the 4 AP Invoice Status.

1. Never Validated

2.Validated

3.Cancelled

4.Needs Re-validation

Working of utility is called in get_approval_status

Here below is the Sample of sql using utility is called in get_approval_status

SELECT invoice_num,invoice_date,APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS

            (

             AIA.INVOICE_ID

            ,AIA.INVOICE_AMOUNT

            ,AIA.PAYMENT_STATUS_FLAG

            ,AIA.INVOICE_TYPE_LOOKUP_CODE

            ) INVOICE_Approval_Status

    

FROM   APPS.AP_INVOICES_ALL AIA