Suppliers External Bank account information details.

Suppliers External Bank account information details.

SELECT   'Bank Account at Supplier Level', sup.segment1,

          eba.*,ss.*,

          sup.vendor_name,ss.*,

          epa.org_id, NULL, NULL, eba.bank_account_num,

         piu.order_of_preference priority, eba.ext_bank_account_id

    FROM ap_suppliers sup,

         ap_supplier_sites_all ss,

         iby_external_payees_all epa,

         iby_pmt_instr_uses_all piu,

         iby_ext_bank_accounts eba

   WHERE sup.party_id = epa.payee_party_id

     AND sup.vendor_id = ss.vendor_id

     AND epa.ext_payee_id = piu.ext_pmt_party_id

     AND piu.instrument_id = eba.ext_bank_account_id

     AND sup.segment1 = '1488'

     AND epa.supplier_site_id IS NULL

     AND epa.party_site_id IS NULL