Validation Status and Workflow Approval Status of an Invoice Batch

At our site we have some customization to Invoice workflow. In order to see what is the validation status (i.e. match_status_flag) and workflow approval status after invoice batch import, i can use this query to see if all customizations have worked or not.

I have added payment status to this query so that i can use it to determine payment status of an invoice batch. Immediately after import, payment status will be "N".

SELECT batch_name , aid.match_status_flag , aia.wfapproval_status , aia.payment_status_flag , COUNT(1) FROM ap_batches_all aba , ap_invoices_all aia , ap_invoice_lines_all ail , ap_invoice_distributions_all aid WHERE aba.batch_name in ('CPUT2_INVOICE_20120913A.DAT', 'SL_CHK_INVOICE_0913A.DAT') AND aba.batch_id = aia.batch_id AND aia.invoice_id = ail.invoice_id AND ail.invoice_id = aid.invoice_id AND ail.line_number = aid.invoice_line_number GROUP BY batch_name , aid.match_status_flag , aia.wfapproval_status , aia.payment_status_flag ;