There are 8 authorization status
that a purchase order can have. The table below lists all the statuses along
with their meanings.
You can use the query below to see
the information listed in the table above :
SELECT lookup_code, displayed_field, description
FROM po_lookup_codes
WHERE lookup_type = 'AUTHORIZATION STATUS';
select authorization_status from po_headers_all pha where 1=1;
| LOOKUP CODE | DISPLAYED FIELD | DESCRIPTION |
| APPROVED | Approved | Document has been Approved |
| CANCELLED | Cancelled | Document has been Cancelled |
| IN PROCESS | In Process | Document is still undergoing Approval |
| INCOMPLETE | Incomplete | Document is not yet Complete |
| PRE-APPROVED | Pre-Approved | Document is Approved but not yet Accepted |
| REJECTED | Rejected | Document as been Rejected |
| REQUIRES REAPPROVAL | Requires Reapproval | Requires Reapproval |
| RETURNED | Returned | Document has been Returned |
