Supplier Bank Detail Query

SELECT  hou.NAME, ass.VENDOR_NAME,assa.VENDOR_SITE_CODE ,bk.bank_name, bkb.bank_branch_name, bac.bank_account_num, bkb.branch_number,
         bkb.eft_swift_code, bac.currency_code
    FROM ce_banks_v bk,
         ce_bank_branches_v bkb,
         iby_ext_bank_accounts bac,
         iby_account_owners iao,
         hz_parties hp,
         ap_suppliers ass ,ap_supplier_sites_all assa,
         hr_operating_units hou
   WHERE bk.bank_party_id = bkb.bank_party_id
     AND bac.bank_id = bk.bank_party_id
     AND bkb.branch_party_id = bac.branch_id
     AND iao.ext_bank_account_id = bac.ext_bank_account_id
     and ass.PARTY_ID=iao.ACCOUNT_OWNER_PARTY_ID
     AND hp.party_id = iao.account_owner_party_id
    and ass.VENDOR_ID=assa.VENDOR_ID
    and hou.ORGANIZATION_ID=assa.ORG_ID
and assa.ORG_ID=86
ORDER BY 1, 2, 3,4,5,6