Invoice Status in Oracle Applications R12

Hi all,

We don't have status column in Invoice tables. So through below query you will get AP Invoice status in Oracle Apps R12.

select APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS
            (
             aia.INVOICE_ID
            ,aia.INVOICE_AMOUNT
            ,aia.PAYMENT_STATUS_FLAG
            ,aia.INVOICE_TYPE_LOOKUP_CODE
            ) Invoice_Status

from ap_invoices_all aia
where 1=1
and aia.invoice_num=nvl(:P_INVOICE_NUM,aia.invoice_num)

Hope this will help you.

Thanks,
Rajashekar Reddy.