How to get address details in oracle (code)

select
hl.ADDRESS1,
hl.ADDRESS2,
hl.ADDRESS3,
hl.ADDRESS4,
hl.STATE,
hl.CITY,
hl.POSTAL_CODE ,
hca.account_number
from hz_locations hl,
hz_cust_accounts   hca,
hz_parties  hp,
hz_party_sites   hps,
hz_cust_acct_sites_all  hcasa
where      hp.party_id      = hca.party_id
and  hp.party_id      = hps.party_id
and  hps.location_id  = hl.location_id
and  hca.cust_account_id     = hcasa.cust_account_id
and  hcasa.party_site_id     = hps.party_site_id