Query to check Bank Account Assignment

SELECT cust.account_number supp_cust_num, 'Customer' TYPE,party.PARTY_NAME, bank.bank_account_num
  FROM apps.iby_ext_bank_accounts bank,
       apps.hz_cust_accounts cust,
       apps.iby_Account_owners own,
       apps.hz_parties party
 WHERE     1 = 1
       AND bank.ext_bank_account_id = own.ext_bank_account_id
       AND cust.party_id = own.ACCOUNT_OWNER_PARTY_ID
       AND party.party_id = own.ACCOUNT_OWNER_PARTY_ID
       AND bank.bank_account_num = '&bank_account'
UNION
SELECT supp.segment1 supp_cust_num, 'Supplier' TYPE,party.PARTY_NAME, bank.bank_account_num
  FROM apps.iby_ext_bank_accounts bank,
       apps.ap_suppliers supp,
       apps.iby_Account_owners own,
       apps.hz_parties party
 WHERE     1 = 1
       AND bank.ext_bank_account_id = own.ext_bank_account_id
       AND supp.party_id = own.ACCOUNT_OWNER_PARTY_ID
       AND party.party_id = own.ACCOUNT_OWNER_PARTY_ID
       AND bank.bank_account_num = '&bank_account'