Andy address4 test

Description
Run Andy address4 test and other Oracle EBS reports with Blitz Report™ on our demo environment
select
hl.address1,
hl.address2,
hl.address3,
hl.address4,
hl.city,
hl.state,
hl.postal_code,
hz_format_pub.format_address(hps.location_id,null,null,' , ') address
from
hz_party_sites hps,
hz_locations hl
where
hl.address4 is not null and
hps.location_id=hl.location_id