Query to Extract Vendor Bank Account Details in Oracle Apps 11i

  SELECT aba.bank_account_id,
         aba.bank_account_name,
         aba.bank_account_num,
         bb.bank_num,
         (SELECT hou.name
            FROM hr_operating_units hou
           WHERE hou.organization_id = aba.org_id)
            operating_unit_name,
         aba.set_of_books_id,
         aba.currency_code,
         aba.description,
         aba.contact_first_name,
         aba.contact_middle_name,
         aba.contact_last_name,
         aba.contact_prefix,
         aba.contact_title,
         aba.contact_area_code,
         aba.contact_phone,
         aba.bank_account_type,
         aba.attribute_category,
         aba.attribute1,
         aba.check_digits,
         aba.org_id,
         aba.bank_account_name_alt,
         aba.account_holder_name,
         aba.account_holder_name_alt,
         aba.allow_multi_assignments_flag,
         aba.iban_number,
         abau.vendor_id,
         abau.vendor_site_id,
         abau.primary_flag,
         abau.start_date,
         abau.end_date,
         pv.segment1,
         pvs.vendor_site_code
    FROM ap_bank_accounts_all aba,
         ap_bank_account_uses_all abau,
         po_vendors pv,
         po_vendor_sites_all pvs,
         ap_bank_branches bb
   WHERE     NVL (aba.inactive_date, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)
         AND aba.bank_account_id = abau.external_bank_account_id
         AND TRUNC (SYSDATE) BETWEEN NVL (abau.start_date, TRUNC (SYSDATE))
                                 AND NVL (abau.end_date, TRUNC (SYSDATE))
         AND abau.vendor_id = pv.vendor_id
         AND abau.vendor_site_id = pvs.vendor_site_id(+)
         AND aba.bank_branch_id = bb.bank_branch_id
ORDER BY aba.bank_branch_id;