Details of interface lines failing for CR memos could not apply to original debit item

 Hi, Need a query to fetch all the activities on an AR invoice for the linking ID under "Reference line id"

Example:

a credit memo interfaced from RMA from OM. The original invoice is closed. hence the CR memo Import and application failed.

 

The original invoice "342365" is closed. the query should following (if more no problem)

From Interface lines                                                                AR base tables

--------------------------------------------------------------------             ---------------------------------------------------------------------------------------------------------------------------------------------------------------

InterfaceLineid ordertype transactiontype amount              Customernumber transactionnumber transactiontype Activityclass activity type allocatedreceiptamount GL_date