Query : Payments

Tables:
AP_INVOICE_PAYMENTS_ALL

AP_PAYMENT_SCHEDULES_ALL

IBY_PAYMENTS_ALL

IBY_PAY_SERVICE_REQUESTS

AP_INVOICES_ALL.invoice_id = AP_INVOICE_PAYMENTS_ALL.invoice_id

AP_INVOICE_PAYMENTS_ALL.check_id = AP_CHECKS_ALL.check_id

AP_CHECKS_ALL.payment_id = IBY_PAYMENTS_ALL.payment_id

iby_payments_all.payment_id = iby_docs_payable_all.payment_id

iby_docs_payable_all.calling_app_doc_unique_ref2 = ap_invoices_all.invoice_id

Select * from AP_INVOICE_PAYMENTS_ALL



select

aia.invoice_num, aia.invoice_id, aia.invoice_amount, aia.invoice_date, aia.terms_date,
apsa.due_date,
aca.check_number,
--ipa.payment_date,
--ipa.check_number,
--ipa.payment_number,
ipa.payee_name,
ipa.payment_process_request_name


from
ap_invoices_all aia,
ap_invoice_payments_all aipa,
AP_PAYMENT_SCHEDULES_ALL apsa,
IBY_PAYMENTS_ALL ipa,
ap_checks_all aca--,
--IBY_PAY_SERVICE_REQUESTS ipsr

where
aia.invoice_id = aipa.invoice_id and
aia.invoice_id = apsa.invoice_id and
aca.check_id = aipa.check_id and
aipa.invoice_id = apsa.invoice_id and
--ipa.payment_amount = aipa.amount and
--ipsr.payment_service_request_id = ipa.payment_service_request_id and
aca.payment_id = ipa.payment_id and
ipa.payment_date between (sysdate-10) and (sysdate+3) and
aia.invoice_num = 'invoice_number'