PER_ADDRESSES

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
ADDRESS_ID BUSINESS_GROUP_ID PERSON_ID DATE_FROM STYLE ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 ADDRESS_TYPE COUNTRY DATE_TO POSTAL_CODE REGION_1 REGION_2 REGION_3 TOWN_OR_CITY ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE16 ADDR_ATTRIBUTE17 ADDR_ATTRIBUTE18 ADDR_ATTRIBUTE19 ADDR_ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER ADD_INFORMATION13 ADD_INFORMATION14 ADD_INFORMATION15 ADD_INFORMATION16 ADD_INFORMATION17 ADD_INFORMATION18 ADD_INFORMATION19 ADD_INFORMATION20 DERIVED_LOCALE GEOMETRY ADDR_ATTRIBUTE21 ADDR_ATTRIBUTE22 ADDR_ATTRIBUTE23 ADDR_ATTRIBUTE24 ADDR_ATTRIBUTE25 ADDR_ATTRIBUTE26 ADDR_ATTRIBUTE27 ADDR_ATTRIBUTE28 ADDR_ATTRIBUTE29 ADDR_ATTRIBUTE30 ADD_INFORMATION21 ADD_INFORMATION22 ADD_INFORMATION23 ADD_INFORMATION24 ADD_INFORMATION25 ADD_INFORMATION26 ADD_INFORMATION27 ADD_INFORMATION28 ADD_INFORMATION29 ADD_INFORMATION30

Name

ADDRESS_ID

BUSINESS_GROUP_ID

PERSON_ID

DATE_FROM

STYLE

ADDRESS_LINE1

ADDRESS_LINE2

ADDRESS_LINE3

ADDRESS_TYPE

COUNTRY

DATE_TO

POSTAL_CODE

REGION_1

REGION_2

REGION_3

TOWN_OR_CITY

ADDR_ATTRIBUTE_CATEGORY

ADDR_ATTRIBUTE1

ADDR_ATTRIBUTE2

ADDR_ATTRIBUTE3

ADDR_ATTRIBUTE4

ADDR_ATTRIBUTE5

ADDR_ATTRIBUTE6

ADDR_ATTRIBUTE7

ADDR_ATTRIBUTE8

ADDR_ATTRIBUTE9

ADDR_ATTRIBUTE10

ADDR_ATTRIBUTE11

ADDR_ATTRIBUTE12

ADDR_ATTRIBUTE13

ADDR_ATTRIBUTE14

ADDR_ATTRIBUTE15

ADDR_ATTRIBUTE16

ADDR_ATTRIBUTE17

ADDR_ATTRIBUTE18

ADDR_ATTRIBUTE19

ADDR_ATTRIBUTE20

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

ADD_INFORMATION13

ADD_INFORMATION14

ADD_INFORMATION15

ADD_INFORMATION16

ADD_INFORMATION17

ADD_INFORMATION18

ADD_INFORMATION19

ADD_INFORMATION20

DERIVED_LOCALE

GEOMETRY

ADDR_ATTRIBUTE21

ADDR_ATTRIBUTE22

ADDR_ATTRIBUTE23

ADDR_ATTRIBUTE24

ADDR_ATTRIBUTE25

ADDR_ATTRIBUTE26

ADDR_ATTRIBUTE27

ADDR_ATTRIBUTE28

ADDR_ATTRIBUTE29

ADDR_ATTRIBUTE30

ADD_INFORMATION21

ADD_INFORMATION22

ADD_INFORMATION23

ADD_INFORMATION24

ADD_INFORMATION25

ADD_INFORMATION26

ADD_INFORMATION27

ADD_INFORMATION28

ADD_INFORMATION29

ADD_INFORMATION30

Query

SQL_Statement
SELECT "ADDRESS_ID","BUSINESS_GROUP_ID","PERSON_ID","DATE_FROM","STYLE","ADDRESS_LINE1","ADDRESS_LINE2","ADDRESS_LINE3","ADDRESS_TYPE","COUNTRY","DATE_TO","POSTAL_CODE","REGION_1","REGION_2","REGION_3","TOWN_OR_CITY","ADDR_ATTRIBUTE_CATEGORY","ADDR_ATTRIBUTE1","ADDR_ATTRIBUTE2","ADDR_ATTRIBUTE3","ADDR_ATTRIBUTE4","ADDR_ATTRIBUTE5","ADDR_ATTRIBUTE6","ADDR_ATTRIBUTE7","ADDR_ATTRIBUTE8","ADDR_ATTRIBUTE9","ADDR_ATTRIBUTE10","ADDR_ATTRIBUTE11","ADDR_ATTRIBUTE12","ADDR_ATTRIBUTE13","ADDR_ATTRIBUTE14","ADDR_ATTRIBUTE15","ADDR_ATTRIBUTE16","ADDR_ATTRIBUTE17","ADDR_ATTRIBUTE18","ADDR_ATTRIBUTE19","ADDR_ATTRIBUTE20","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","CREATED_BY","CREATION_DATE","OBJECT_VERSION_NUMBER","ADD_INFORMATION13","ADD_INFORMATION14","ADD_INFORMATION15","ADD_INFORMATION16","ADD_INFORMATION17","ADD_INFORMATION18","ADD_INFORMATION19","ADD_INFORMATION20","DERIVED_LOCALE","GEOMETRY","ADDR_ATTRIBUTE21","ADDR_ATTRIBUTE22","ADDR_ATTRIBUTE23","ADDR_ATTRIBUTE24","ADDR_ATTRIBUTE25","ADDR_ATTRIBUTE26","ADDR_ATTRIBUTE27","ADDR_ATTRIBUTE28","ADDR_ATTRIBUTE29","ADDR_ATTRIBUTE30","ADD_INFORMATION21","ADD_INFORMATION22","ADD_INFORMATION23","ADD_INFORMATION24","ADD_INFORMATION25","ADD_INFORMATION26","ADD_INFORMATION27","ADD_INFORMATION28","ADD_INFORMATION29","ADD_INFORMATION30" FROM PER_ADDRESSES WITH READ ONLY

SQL_Statement

SELECT "ADDRESS_ID","BUSINESS_GROUP_ID","PERSON_ID","DATE_FROM","STYLE","ADDRESS_LINE1","ADDRESS_LINE2","ADDRESS_LINE3","ADDRESS_TYPE","COUNTRY","DATE_TO","POSTAL_CODE","REGION_1","REGION_2","REGION_3","TOWN_OR_CITY","ADDR_ATTRIBUTE_CATEGORY","ADDR_ATTRIBUTE1","ADDR_ATTRIBUTE2","ADDR_ATTRIBUTE3","ADDR_ATTRIBUTE4","ADDR_ATTRIBUTE5","ADDR_ATTRIBUTE6","ADDR_ATTRIBUTE7","ADDR_ATTRIBUTE8","ADDR_ATTRIBUTE9","ADDR_ATTRIBUTE10","ADDR_ATTRIBUTE11","ADDR_ATTRIBUTE12","ADDR_ATTRIBUTE13","ADDR_ATTRIBUTE14","ADDR_ATTRIBUTE15","ADDR_ATTRIBUTE16","ADDR_ATTRIBUTE17","ADDR_ATTRIBUTE18","ADDR_ATTRIBUTE19","ADDR_ATTRIBUTE20","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","CREATED_BY","CREATION_DATE","OBJECT_VERSION_NUMBER","ADD_INFORMATION13","ADD_INFORMATION14","ADD_INFORMATION15","ADD_INFORMATION16","ADD_INFORMATION17","ADD_INFORMATION18","ADD_INFORMATION19","ADD_INFORMATION20","DERIVED_LOCALE","GEOMETRY","ADDR_ATTRIBUTE21","ADDR_ATTRIBUTE22","ADDR_ATTRIBUTE23","ADDR_ATTRIBUTE24","ADDR_ATTRIBUTE25","ADDR_ATTRIBUTE26","ADDR_ATTRIBUTE27","ADDR_ATTRIBUTE28","ADDR_ATTRIBUTE29","ADDR_ATTRIBUTE30","ADD_INFORMATION21","ADD_INFORMATION22","ADD_INFORMATION23","ADD_INFORMATION24","ADD_INFORMATION25","ADD_INFORMATION26","ADD_INFORMATION27","ADD_INFORMATION28","ADD_INFORMATION29","ADD_INFORMATION30"

FROM PER_ADDRESSES

WITH READ ONLY