Payment Remittance Advice (link between iby_payments_all, ap_invoices_all, ap_inv_selection_criteria_all)

SELECT
 iba.org_id
,aica.checkrun_name
,iba.payment_reference_number
,iba.paper_document_number
,iba.payment_date
,iba.payment_currency_code
,iba.payment_amount
--,iba.payee_name
--,iba.payee_address1
--,iba.payee_address2
--,iba.payee_city
--,iba.payee_postal_code
--,iba.payee_state
--,iba.payee_country
,aia.vendor_id
,aia.vendor_site_id
,assa.vendor_site_code
,assa.party_site_id
,ass.segment1
,ass.vendor_name
,assa.address_line1
,assa.address_line2
,assa.address_line3
,assa.city
,assa.zip
,assa.state
,assa.province
,assa.country
,aia.accts_pay_code_combination_id
,aia.invoice_num
,aia.invoice_date
,aia.invoice_amount
,aia.invoice_currency_code
,aia.discount_amount_taken
,aia.amount_paid
 FROM iby_payments_all iba,
 ap_checks_all aca,
 ap_invoice_payments_all aipa,
 ap_invoices_all aia,
 iby_pay_service_requests ipsr,
 ap_inv_selection_criteria_all aica,
 ap_suppliers ass,
 ap_supplier_sites_all assa
 WHERE iba.payment_id=aca.payment_id
 and aca.check_id = aipa.check_id
 and aia.invoice_id = aipa.invoice_id
 and iba.org_id = aia.org_id
 and aia.org_id = aipa.org_id
 and ipsr.payment_service_request_id=iba.payment_service_request_id
 and ipsr.calling_app_id = 200
 and ipsr.call_app_pay_service_req_code = aica.checkrun_name
 and aia.vendor_id = ass.vendor_id
 and aia.vendor_site_id = assa.vendor_site_id
 and aia.org_id = assa.org_id
 and aica.checkrun_name=:P_CHECKRUN_NAME--'SAS01MAR16BHA2'
 and iba.org_id=:P_OPERATING_UNIT
 and iba.PAYMENT_METHOD_CODE in ('WIRE','EFT')
 --and iba.payment_id=67043;
 --and iba.payment_reference_number  in (6624,6625)
and iba.VOID_DATE is null;