Need Query to get error data which is shown in review cost distribution process

Summary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled in our organization, so the business user doesnt go to review the cost distributions processes in the UI to check for any exceptions until the close day.

Content (please ensure you mask any confidential information): We need to create a report for displaying the exceptions and schedule it to send to the business user well in advance to clear any exceptions for smooth month end.

We are using the table CST_TP_ERRORS and CST_TRANSACTIONS_ERRORS, but this is not giving the error transaction details as we see from the UI. Need help with the other table which can be utilised for the same.