Query to Find the supplier Details for Payables

SELECT /*+ FIRST_ROWS */
       hrou.name,
       pov.segment1 "Supplier Number",
       pov.vendor_name,
       posa.vendor_site_code,
       ft.territory_short_name Country,
       posa.inactive_date "Site Inactive Date",
       posa.pay_group_lookup_code pay_group,
       posa.payment_method_lookup_code Payment_method,
       glcc.concatenated_segments Liability_account,
       posa.vat_registration_num,
       posa.attribute1 global_advice_client_id,
      (SELECT aba.bank_account_name
         FROM ap_bank_accounts_all aba
        WHERE aba.bank_account_id = abaua.external_bank_account_id
          and aba.org_id = abaua.org_id) bank_account_name,
      (SELECT aba.bank_account_num
         FROM ap_bank_accounts_all aba
        WHERE aba.bank_account_id = abaua.external_bank_account_id
          and aba.org_id = abaua.org_id)  bank_account_num,
      (SELECT aba.currency_code
         FROM ap_bank_accounts_all aba
        WHERE aba.bank_account_id = abaua.external_bank_account_id
          and aba.org_id = abaua.org_id)  bank_currency,
       abaua.start_date,
       abaua.end_date
  FROM po_vendors pov,
       po_vendor_sites_all posa,
       ap_bank_account_uses_all abaua,
       hr_operating_units hrou,
       fnd_territories_vl ft,
       gl_code_combinations_kfv glcc
 WHERE posa.vendor_id = pov.vendor_id
   and abaua.vendor_id(+) = posa.vendor_id
   and abaua.vendor_site_id(+) = posa.vendor_site_id
   and hrou.organization_id = posa.org_id
   and ft.territory_code(+) = posa.country
   and glcc.code_combination_id = posa.accts_pay_code_combination_id;