Payment Batches Waiting to be Reviewed

This query can provide payment batches that are waiting for review. select call_app_pay_service_req_code , (select 'Invoice Count = ' || count(1) || ', Amount =' || to_char(sum(payment_amount),'$999,999,990.00') from ap_selected_invoices_all asi where checkrun_name = call_app_pay_service_req_code and ok_to_pay_flag = 'Y' ) from iby.iby_pay_service_requests psr WHERE calling_app_id = 200 AND payment_service_request_status = 'PENDING_REVIEW'