Detail SQL query using the payment tables in oracle apps r12

 select aca.AMOUNT CHECK_AMOUNT,

aca.check_date,

aca.check_number,

aca.currency_code,

aca.status_lookup_code payment_status,

aca.bank_account_num,

aca.payment_method_code,

aca.bank_account_name,

aia.invoice_num,     

aia.invoice_type_lookup_code,

aia.invoice_currency_code,

aia.invoice_date,

aps.vendor_name,

apss.vendor_site_code,

aia.invoice_amount

  from apps.ap_invoices_all         aia,

      apps.ap_suppliers aps,

       apps.ap_supplier_sites_all apss,

       apps.gl_code_combinations_kfv gcc,

       apps.ap_invoice_payments_all aipa,

       apps.ap_checks_all aca

 where aia.vendor_id=aps.vendor_id

   and aia.VENDOR_SITE_ID=APSS.VENDOR_SITE_ID

   AND aps.vendor_id=apss.VENDOR_ID

   and aipa.invoice_id(+)=aia.invoice_id

   and aca.check_id   (+)=aipa.check_id

   and aia.ORG_ID=:P_ORG_ID