Payables and Cash Management - EBS (MOSC)

MOSC Banner

Need Table/Column/SQL to get Invoice Approval Status (on screen one, not the one using the package)

Hi folks.

I need to retrieve the Approval Status we see on the Invoice screen.


As far as I can ascertain there is an on screen Validation Status, an on screen Approval Status, a database column Approval Status, and a database Approval Status retrieved using the packaged function ap_invoices_pkg.get_approval_status


The database column and packaged function never return a value inline with the Approval Status on screen, and it's that one I need to get.


Below are the steps, and values :


1) Create the invoice:

On screen Validation Status = Not Validated

On screen Approval Status = Not required

Tagged:

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