ebs bank query

SELECT cba.bank_account_name ,
  cba.bank_account_id,
  cba.bank_account_name_alt,
  cba.bank_account_num ,
  cba.multi_currency_allowed_flag ,
  cba.zero_amount_allowed ,
  cba.account_classification ,
  bb.bank_name ,
  cba.bank_id,
  bb.bank_number,
  bb.bank_branch_type ,
  bb.bank_branch_name ,
  cba.bank_branch_id ,
  bb.bank_branch_number ,
  bb.eft_swift_code ,
  bb.description BANK_DESCRIPTION,
  cba.currency_code ,
  bb.address_line1,
  bb.city,
  bb.county,
  bb.state,
  bb.zip_code,
  bb.country,
  ou.name ,
  gcf.concatenated_segments,
  cba.ap_use_allowed_flag,
  cba.ar_use_allowed_flag,
  cba.xtr_use_allowed_flag,
  cba.pay_use_allowed_flag
FROM apps.ce_bank_accounts cba,
  apps.ce_bank_acct_uses_all bau,
  apps.cefv_bank_branches bb,
  apps.hr_operating_units ou,
  apps.gl_code_combinations_kfv gcf
WHERE cba.bank_account_id         = bau.bank_account_id
AND cba.bank_branch_id            = bb.bank_branch_id
AND ou.organization_id            = bau.org_id
AND cba.asset_code_combination_id = gcf.code_combination_id
AND (cba.end_date                IS NULL
OR cba.end_date                   > TRUNC(SYSDATE))
ORDER BY TO_NUMBER(cba.bank_account_num);



SELECT owners.account_owner_party_id,
  asp.segment1 vendor_num,
  asp.vendor_name,
  (SELECT NAME
  FROM apps.hr_operating_units hou
  WHERE 1                 = 1
  AND hou.organization_id = asa.org_id
  ) ou_name,
  asa.vendor_site_code,
  ieb.country_code,
  cbbv.bank_name,
  cbbv.bank_number,
  cbbv.bank_branch_name,
  cbbv.branch_number,
  cbbv.bank_branch_type,
  cbbv.eft_swift_code,
  ieb.bank_account_num,
  ieb.currency_code,
  ieb.iban,
  ieb.foreign_payment_use_flag,
  ieb.bank_account_name_alt
FROM apps.iby_pmt_instr_uses_all instrument,
  apps.iby_account_owners owners,
  apps.iby_external_payees_all payees,
  apps.iby_ext_bank_accounts ieb,
  apps.ap_supplier_sites_all asa,
  apps.ap_suppliers asp,
  apps.ce_bank_branches_v cbbv
WHERE owners.primary_flag      = 'Y'
AND owners.ext_bank_account_id = ieb.ext_bank_account_id
AND owners.ext_bank_account_id = instrument.instrument_id
AND payees.ext_payee_id        = instrument.ext_pmt_party_id
AND payees.payee_party_id      = owners.account_owner_party_id
AND payees.supplier_site_id    = asa.vendor_site_id
AND asa.vendor_id              = asp.vendor_id
AND cbbv.branch_party_id(+)    = ieb.branch_id
  --and asp.vendor_name like '%ABC Emp, Name'
AND asp.vendor_name LIKE 'ABCD LLC'
ORDER BY 4,
  1,
  3 ;