Checks and Vendor Information for a Payment Process Request.

select --idp.calling_app_doc_ref_number invoice_number

pv.vendor_name, idp.*

from apps.iby_pay_service_requests ipsr,

apps.iby_pay_instructions_all ipi,

apps.iby_payments_all ip,

apps.iby_docs_payable_all idp,

apps.po_vendors pv --, apps.po_vendor_sites_all pvs

where ipsr.payment_service_request_id = ipi.payment_service_request_id

and ipi.payment_instruction_id = ip.payment_instruction_id

and ip.payment_id = idp.payment_id

and pv.party_id = idp.payee_party_id

--and pvs.vendor_id = pv.vendor_id

and call_app_pay_service_req_code = 'PPR Name here';