Hello Members

Can anyone help me in the following query. I wrote the following query to fetch R21 AP invoice payments with both functional and invoice currency, I will be glad for assistance if there is a better way.

SELECT--- ou.name Company,
         cc.concatenated_segments,
   ---      ai.invoice_type_lookup_code invoice_type,
         ac.Check_Number,
         ai.invoice_num,
         ai.invoice_date,
         ai.gl_date,
         ai.terms_date "DUE_DATE",
         v.segment1 "VENDOR_NUMBER",            
         v.vendor_name,
         ltrim(ai.invoice_amount),
        ai.invoice_currency_code,
        ltrim(ap.amount) "AMOUNT_PAID",
        ltrim(ap.exchange_rate) "EXCHANGE_RATE",
  ---       ap.exchange_date "EXCHANGE_DATE",