Query to find Supplier Bank Details

1--
2SELECT                                                /*Supplier Information*/
3      aps.segment1               oracle_supplier_number,
4       aps.vendor_id,
5       aps.vendor_name           supplier_name,
6       aps.party_id              supplier_party_id,
7       iepa.remit_advice_fax     remit_advice_fax,
8       iepa.remit_advice_email   remit_advice_email/* Supplier Site Information */
9       ,
10       assa.vendor_site_id,
11       assa.party_site_id        supplier_party_site_id,
12       assa.vendor_site_code     vendor_site_code,
13       assa.pay_site_flag        pay_site_flag,
14       assa.purchasing_site_flag purchasing_site_flag,
15       assa.rfq_only_site_flag   rfq_only_site_flag/* Bank Information*/
16       ,
17       ieba.ext_bank_account_id,
18       hp.party_name             Bank_party_name,
19       ieba.bank_account_num     bank_account_num,
20       ieba.bank_account_name    bank_account_name,
21       ieba.country_code         bank_acct_country_code,
22       ieba.currency_code        bank_acct_currency_code/* Bank Address */
23       ,
24       hp.address1               bank_address_line1,
25       hp.address2               bank_address_line2,
26       hp.address3               bank_address_line3,
27       hp.city                   bank_address_city,
28       hp.state                  bank_address_state,
29       hp.postal_code            bank_address_zip,
30       hp.country                bank_address_country/* Bank Branch Address */
31       ,
32       hp1.address1              branch_address_line1,
33       hp1.address2              branch_address_line2,
34       hp1.address3              branch_address_line3,
35       hp1.city                  branch_address_city,
36       hp1.state                 branch_address_state,
37       hp1.postal_code           branch_address_zip,
38       hp1.country               branch_address_country
39  FROM ap_supplier_sites_all   assa,
40       hz_parties              hp,
41       iby_ext_bank_accounts   ieba,
42       iby_external_payees_all iepa,
43       iby_pmt_instr_uses_all  ipiua,
44       ap_suppliers            aps,
45       hz_parties              hp1
46 WHERE     assa.vendor_site_id = iepa.supplier_site_id
47       AND hp.party_id = ieba.bank_id
48       AND ipiua.instrument_id = ieba.ext_bank_account_id
49       AND ipiua.ext_pmt_party_id = iepa.ext_payee_id
50       AND assa.vendor_id = aps.vendor_id
51       AND ieba.branch_id = hp1.party_id
52       AND ipiua.instrument_type = 'BANKACCOUNT'
53       AND ipiua.payment_flow = 'DISBURSEMENTS'
54       AND ipiua.order_of_preference = 1