How to query return transaction id from AP invoice tables?

Summary:

How to query return transaction id from AP invoice tables?

Content (required):

We have the requirement to get return transaction id of debit memo.

But the AP invoice distribution table only stores return transaction's parent receipt transaction in column RCV_TRANSACTION_ID.

AP_INVOICE_DISTRIBUTIONS_ALL.RCV_TRANSACTION_ID

Is it possible to get the return transaction id of debit memo by sql?

Please consider if one parent receipt transaction links to multiple return transaction.

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):