SELECT D.*
FROM t_process_message A
INNER JOIN t_process_parameter B ON A.process_message_id = B.process_message_id AND B.process_parameter_key = 'docId'
INNER JOIN cb_in_out_cashbank C ON C.in_out_cashbank_id = B.process_parameter_value::bigint --AND C.status_doc <> 'R'
INNER JOIN gl_journal_trx D ON C.doc_no = D.doc_no AND C.doc_type_id = D.doc_type_id
--INNER JOIN cb_in_ou_cashbank_payment E ON E.in_out_cashbank_id = C.in_out_cashbank_id
WHERE A.process_name = 'cb_cancel_submit_cb_in_ar'
    AND A.process_status = 'S'
ORDER BY A.process_message_id DESC