SELECT A.order_type, sum(A.order_value) AS "Total", B.Description
FROM tpayment_order A, order_status_ref B
GROUP BY order_type, order_status_ref
But a vital assumption is that the order_status_ref is table with the following mapping:
order_type | Description
Without this mapping, the joining would be meaningless.
*Mark as answer if this solves your query.