Oracle Reports (MOSC)

MOSC Banner

null output ap_invoices_pkg.get_approval_status 11i

edited Jan 30, 2013 3:06PM in Oracle Reports (MOSC) 3 commentsAnswered
Good afternoon everyone,
I need your help regarding this function to get the invoice status.

ap_invoices_pkg.get_approval_status.

I tried to used this function in my query for my custom report in 11i but the column returns null when I run it in Oracle sql developer
I their any setup needed to make this work?

Please refer below for my sample query.

SELECT I.INVOICE_ID, I.INVOICE_NUM, APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS
            (
             I.INVOICE_ID
            ,I.INVOICE_AMOUNT
            ,I.PAYMENT_STATUS_FLAG
            ,I.INVOICE_TYPE_LOOKUP_CODE
            ) Approval_Status
FROM   AP_INVOICES_ALL I;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center