select   hps.party_site_number,
hl.address1 address1,
       hl.address2 address2, 
       hl.address3 address3, 
       hl.address4 address4,
       hl.city city, 
       hl.state state, 
       hl.postal_code zip_code,
       hl.country country from
       apps.hz_locations hl,apps.hz_party_sites hps
       where hl.location_id=hps.location_id
       and hps.party_site_number in
       ('44022.071849'
,'44022.071856'
,'44022.070519'
,'44022.070662'
,'44022.071364'
,'44022.071978'
,'44022.072028'
,'44022.072025'
,'44022.072113'
,'44022.072124'
,'44022.075721'
,'44022.072158'
,'44022.072375'
,'44022.075107'
,'44022.075111'
,'44022.075375'
,'44022.075136'
,'44022.075227'
,'44022.075266'
,'44022.075654'
,'44022.075542'
,'44022.075298'
,'44022.075417'
,'44022.075329'
,'44022.0SIT36'
,'44022.075709'
,'44022.075710'
,'44022.079111'
,'44022.075631'
,'44022.075720'
,'44022.0R4078'
,'44022.0R4166'
,'44022.0RU499'
,'44022.075670'
,'44022.0RV157'
,'44022.07572T'
,'44022.075259'
,'44022.071920'
,'44022.075324'
,'44022.075333'
,'44022.075325'
,'44022.075620'
,'44022.075260'
,'44022.075261'
,'44022.075323'
,'44022.070007'
,'44022.071440'
,'44022.075585'
,'44022.023W9R'
,'44022.075538'
,'44022.Z23W9R'
,'44022.07192T'
,'44022.07533T'
,'44022.07526T'
,'44022.0752TT'
,'44022.0753TT'
,'44022.07532T'
,'44022.0753ZZ'
,'44022.0756TT'
,'44022.07525T'
,'44022.07000T'
,'44022.07144T'
,'44022.07558Z'
,'44022.07563T')