- Maximo status tables are used to track the status changes and helpful to understand business flow in various modules like workorder, procurement etc.
- Querying the status tables for specific record is simple, that by using record key as parameter (WONUM, PONUM, INVOICENUM etc.)
- However, retrieving the previous/next status of specific status for bulk of records can be tricky.
- Here are few queries, that can be helpful in such cases.