query to get the sales order and the respective rma order number in oracle fusion

Summary:

Hello Experts,

we are working on an integration and for that, we need the RMA orders information and the respective sales order reference numbers as well.

Could any of you have the query to fetch the RMA orders and the respective sales order reference details ?

if yes, please share it.

Thanks
Midhun Kumar

Content (please ensure you mask any confidential information):

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

25A

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