SELECT request_id, transaction_mode, transaction_header_id, count(*) FROM MTL_TRANSACTIONS_INTERFACE group by transaction_header_id,transaction_mode,request_id
View Text - HTML Formatted
SELECT REQUEST_ID , TRANSACTION_MODE , TRANSACTION_HEADER_ID , COUNT(*) FROM MTL_TRANSACTIONS_INTERFACE GROUP BY TRANSACTION_HEADER_ID , TRANSACTION_MODE , REQUEST_ID