View on HZ_LOCATIONS which gives formatted address
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT LOC.LOCATION_ID LOCATION_ID , LOC.ADDRESS1||CHR(10)|| LOC.CITY||' , '||LOC.STATE||'-'||LOC.POSTAL_CODE||CHR(10)|| LOC.COUNTY||CHR(10)|| LOC.COUNTRY||CHR(10) ADDRESS FROM HZ_LOCATIONS LOC WITH READ ONLY