Query - Supplier - Site- Active Bank Information - Oracle EBS

SELECT
   pv.segment1 vendor_number
 , pv.vendor_name
 , pvs.org_id
 , pvs.vendor_site_code
 , ibv.home_country || '-' || ibv.bank_name bank_name
 , abb.home_country || '-' || abb.bank_branch_name bank_branch_name
 , aba.bank_account_num
 , hepa.default_payment_method_code pay_method
 , hepa.inactive_date assignment_inactive_date
 , ipiua.order_of_preference uses_preference
 , ipiua.start_date uses_start_date
 , ipiua.end_date uses_end_date
 , pv.vendor_id
 , pvs.vendor_site_id
 , ibv.bank_party_id
 , abb.branch_party_id
 , aba.ext_bank_account_id
 , hepa.ext_payee_id
 , hepa.payee_party_id
 , ipiua.instrument_payment_use_id
FROM
   ap.ap_suppliers pv
 , ap.ap_supplier_sites_all pvs
 , iby_ext_banks_v ibv
 , iby_ext_bank_branches_v abb
 , iby_ext_bank_accounts aba
 , iby_external_payees_all hepa
 , iby_pmt_instr_uses_all ipiua
WHERE
      pv.vendor_id          = 2684821
  AND pv.vendor_id          = pvs.vendor_id
  AND pvs.vendor_site_id    = hepa.supplier_site_id
  AND hepa.org_id           = pvs.org_id
  AND nvl( pvs.inactive_date, SYSDATE ) >= SYSDATE
  AND nvl( hepa.inactive_date, SYSDATE ) >= SYSDATE
  AND hepa.ext_payee_id     = ipiua.ext_pmt_party_id (+)
  AND ipiua.instrument_id   = aba.ext_bank_account_id (+)
  AND nvl( ipiua.end_date, SYSDATE ) >= SYSDATE
  AND aba.branch_id         = abb.branch_party_id (+)
  AND ibv.bank_party_id (+) = abb.bank_party_id;