How To Identify Where An Expense Report Is In the Process

The values for the column EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all come from the Payables Lookup Code EXPENSE REPORT STATUS

Code	Lookup Code Meaning
CANCELLED	Cancelled
EMPAPPR	Pending Individual’s Approval
ERROR	Pending System Administrator Action
HOLD_PENDING_RECEIPTS	Hold Pending Receipts
INPROGRESS	In Progress
INVOICED	Ready for Payment
MGRAPPR	Pending Payables Approval
MGRPAYAPPR	Ready for Invoicing
PAID	Paid
PARPAID	Partially Paid
PAYAPPR	Payables Approved
PENDMGR	Pending Manager Approval
PEND_HOLDS_CLEARANCE	Pending Payment Verification
REJECTED	Rejected
RESOLUTN	Pending Your Resolution
RETURNED	Returned
SAVED	Saved
SUBMITTED	Submitted
UNUSED	Unused
WITHDRAWN	Withdrawn

Oracle Functional