SQL & PL/SQL

Hi All,

I have data as below in my table and my need is to show the quantity in same row instead of two rows.

WITH t AS ( SELECT - 1 trx_id
, 1 quantity
, 'RECIVE' action
FROM dual
UNION
SELECT 123
, 1
, 'DELIVER'
FROM dual
)
SELECT *
FROM t;

The receive trx id is always -1 as it is systematic.

received_quantity deliver_quantity

1 1