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 |
Hi Team,
I am using a query to find out the expense reports which are having IN PROCESS status, as you mentioned above there is a status called IN PROGRESS but i cant find it in the ap_lookup_codes, I am using 11.5.10.2 version, is this the status code introduded in R12??
Appreciate your respone
Thanks,
Raghav
LikeLike