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