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 specific debit memo ?

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

For example:

Receipt count=100 AP Invoice:1001

Return1 count=10 Debit memo: 1002

Return2 count=10 Debit memo: 1003

Return3 count=10 Debit memo: 1004

Return4 count=10 Debit memo: 1005

My question is how to get the mapping between Return 1~4 and Debit memo 1002~1005?