SQL Query to get the list of failed approval transactions

SELECT d.*-- h.transaction_id, d.state,d.status,h.module_identifier, h.CREATION_DATE
FROM HRC_TXN_HEADER h,HRC_TXN_DATA d
WHERE h.Transaction_id = d.Transaction_id
and h.transaction_id = 000000000000000

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin