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