Customer's Bank Accounts

SELECT acct.account_number
     , acct.status Account_Status
     , acct.account_established_date
     , acct.account_termination_date
     , acct.account_activation_date
     , asite.bill_to_flag
     , asite.ship_to_flag
     , asite.customer_category_code
     , psite.party_site_name
     , psite.status Party_Site_Status
     , psite.start_date_active
     , psite.end_date_active
     , loc.address1 || ' ' || loc.address2 address
     , loc.city
     , loc.state
     , loc.postal_code
     , siteu.site_use_code
     , siteu.primary_flag
     , siteu.status site_uses_status
     , banku.start_date
     , banku.end_date 
     , banku.primary_flag
     , bank.bank_account_num
     , bank.bank_account_name
     , bank.inactive_date
  FROM apps.hz_cust_accounts         acct
     , apps.hz_cust_acct_sites_all   asite
     , apps.hz_party_sites           psite
     , apps.hz_locations             loc
     , apps.hz_cust_site_uses_all    siteu
     , apps.ap_bank_account_uses_all banku
     , apps.ap_bank_accounts_all     bank
 WHERE acct.account_number        = :account_number -- in single quotes
   AND asite.cust_account_id      = acct.cust_account_id
   AND asite.party_site_id        = psite.party_site_id
   AND psite.location_id          = loc.location_id
   AND siteu.cust_acct_site_id    = asite.cust_acct_site_id
   AND banku.customer_site_use_id = siteu.site_use_id
   AND bank.bank_account_id       = banku.external_bank_account_id
 ORDER BY bank.bank_account_num