Custom Data Model - Remittance Advice - Change From Check to Wire Payments?

Summary

Custom report using SQL data model - How to change from check payments to wire payments?

Content

We have a custom report for AMEX remittance advice which gives us a detailed listing of payments made by check to AMEX for a specified date range.  We need a copy of the report that will work the same way for wire payments.  Below is the SQL in the data model for the original report.  Can someone please advise how to modify the SQL to work for wire payments?  Thanks, Wendy

 

Code Snippet

select DISTINCT 
	PP.LIST_NAME EMPLOYEE_NAME,
	Cc.CCNUMBER,
	AI.INVOICE_NUM,
	AI.INVOICE_AMOUNT,
	AC.CHECK_NUMBER,
	ac.AMOUNT,
	TO_CHAR(AC.CHECK_DATE ,'RRRR-MM-DD') CHECK_DATE
from EXM_CREDIT_CARD_TRXNS ecct,
     EXM_CARDS ec,
     IBY_CREDITCARD cc,
     PER_WORKFORCE_X PP,
     EXM_EXPENSES ee,
     EXM_EXPENSE_REPORTS exm ,
     AP_INVOICES_ALL  AI,
     AP_INVOICE_PAYMENTS_ALL  AIP,
     AP_CHECKS_ALL  ac
WHERE  1=1
 AND ecct.CREDIT_CARD_TRXN_ID  = ee.CREDIT_CARD_TRXN_ID
AND  ee.EXPENSE_REPORT_ID = exm.EXPENSE_REPORT_ID
AND ecct.CARD_ID = ec.CARD_ID
AND  ee.EXPENSE_REPORT_ID = exm.EXPENSE_REPORT_ID
AND EXM.EXPENSE_REPORT_NUM = REPLACE(AI.INVOICE_NUM,'.1')
AND ec.CARD_REFERENCE_ID = cc.INSTRID
AND ec.PERSON_ID = PP.PERSON_ID
and AI.INVOICE_ID=AIP.INVOICE_ID
AND AIP.CHECK_ID=AC.CHECK_ID
AND AC.VENDOR_NAME ='American Express'
AND AC.CHECK_DATE BETWEEN :START_DATE AND :END_DATE