How to find return transfer Order using SQL or REST API?

Summary:

Content (please ensure you mask any confidential information):

Hello Experts

I created a transfer order request to destination type - Inventory
. Pick release and ship confirmed. This created transfer order ISSUE.
Received the transfer order to inventory destination. Created the receipt
Navigated to return receipts. Created a return transaction
Oracle created return transfer order
Now if I have to find the return transfer order using a sql or API, how do I find this?

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

25D

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