SELECT ieba.*

FROM iby_pmt_instr_uses_all uses

,iby_external_payees_all payee

,iby_ext_bank_accounts ieba

,ap_supplier_sites_all pvs

,ap_suppliers s

WHERE uses.instrument_type = 'BANKACCOUNT'

AND payee.ext_payee_id = uses.ext_pmt_party_id

AND payee.payment_function = 'PAYABLES_DISB'

AND uses.instrument_id = ieba.ext_bank_account_id

AND SYSDATE BETWEEN nvl(ieba.start_date, SYSDATE) AND

nvl(ieba.end_date, SYSDATE)

AND payee.party_site_id = pvs.party_site_id

AND s.vendor_id = pvs.vendor_id

AND payee.org_id = pvs.org_id

AND pvs.org_id = p_org_id

AND s.vendor_name = p_vendor_name

ITPub博客

取供应商银行