Those are E-Business Suite tables, which is a specialist area. Most of the people who answer questions on this forum won't know EBS. If you want people who underdstand the HZ schema I suggest you ask your question on [url https://forums.oracle.com/forums/category.jspa?categoryID=3]the appropriate site.
I also suggest you put a little effiort into attempting an answer before your ask, as people are usually unwilling to reward abject laziness.
select * from hz_party_sites site, hz_party_site_uses uses,hz_locations loc where site.party_site_id = uses.party_site_id
and uses.site_use_type = 'SHIP_TO'
and site.status = 'A'
and site.location_id = loc.location_id