PER_PERSON_ADDRESSES_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

PERSON_ID

ADDRESS_TYPE

ADDRESS_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BUSINESS_GROUP_ID

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

ADDRESS_LINE_4

BUILDING

FLOOR_NUMBER

TOWN_OR_CITY

REGION_1

REGION_2

REGION_3

COUNTRY

POSTAL_CODE

LONG_POSTAL_CODE

TIMEZONE_CODE

DERIVED_LOCALE

GEOMETRY

DQ_VALIDATION_LEVEL

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

ADDR_ATTRIBUTE21

ADDR_ATTRIBUTE22

ADDR_ATTRIBUTE23

ADDR_ATTRIBUTE24

ADDR_ATTRIBUTE25

ADDR_ATTRIBUTE26

ADDR_ATTRIBUTE27

ADDR_ATTRIBUTE28

ADDR_ATTRIBUTE29

ADDR_ATTRIBUTE30

ADDL_ADDRESS_ATTRIBUTE1

ADDL_ADDRESS_ATTRIBUTE2

ADDL_ADDRESS_ATTRIBUTE3

ADDL_ADDRESS_ATTRIBUTE4

ADDL_ADDRESS_ATTRIBUTE5

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

Query

SQL_Statement

SELECT

PER_PERSON_ADDR_USAGES_F.PERSON_ID,

PER_PERSON_ADDR_USAGES_F.ADDRESS_TYPE,

PER_ADDRESSES_F.ADDRESS_ID,

PER_ADDRESSES_F.EFFECTIVE_START_DATE,

PER_ADDRESSES_F.EFFECTIVE_END_DATE,

PER_ADDRESSES_F.BUSINESS_GROUP_ID,

PER_ADDRESSES_F.ADDRESS_LINE_1,

PER_ADDRESSES_F.ADDRESS_LINE_2,

PER_ADDRESSES_F.ADDRESS_LINE_3,

PER_ADDRESSES_F.ADDRESS_LINE_4,

PER_ADDRESSES_F.BUILDING,

PER_ADDRESSES_F.FLOOR_NUMBER,

PER_ADDRESSES_F.TOWN_OR_CITY,

PER_ADDRESSES_F.REGION_1,

PER_ADDRESSES_F.REGION_2,

PER_ADDRESSES_F.REGION_3,

PER_ADDRESSES_F.COUNTRY,

PER_ADDRESSES_F.POSTAL_CODE,

PER_ADDRESSES_F.LONG_POSTAL_CODE,

PER_ADDRESSES_F.TIMEZONE_CODE,

PER_ADDRESSES_F.DERIVED_LOCALE,

PER_ADDRESSES_F.GEOMETRY,

PER_ADDRESSES_F.DQ_VALIDATION_LEVEL,

PER_ADDRESSES_F.ADDR_ATTRIBUTE_CATEGORY,

PER_ADDRESSES_F.ADDR_ATTRIBUTE1,

PER_ADDRESSES_F.ADDR_ATTRIBUTE2,

PER_ADDRESSES_F.ADDR_ATTRIBUTE3,

PER_ADDRESSES_F.ADDR_ATTRIBUTE4,

PER_ADDRESSES_F.ADDR_ATTRIBUTE5,

PER_ADDRESSES_F.ADDR_ATTRIBUTE6,

PER_ADDRESSES_F.ADDR_ATTRIBUTE7,

PER_ADDRESSES_F.ADDR_ATTRIBUTE8,

PER_ADDRESSES_F.ADDR_ATTRIBUTE9,

PER_ADDRESSES_F.ADDR_ATTRIBUTE10,

PER_ADDRESSES_F.ADDR_ATTRIBUTE11,

PER_ADDRESSES_F.ADDR_ATTRIBUTE12,

PER_ADDRESSES_F.ADDR_ATTRIBUTE13,

PER_ADDRESSES_F.ADDR_ATTRIBUTE14,

PER_ADDRESSES_F.ADDR_ATTRIBUTE15,

PER_ADDRESSES_F.ADDR_ATTRIBUTE16,

PER_ADDRESSES_F.ADDR_ATTRIBUTE17,

PER_ADDRESSES_F.ADDR_ATTRIBUTE18,

PER_ADDRESSES_F.ADDR_ATTRIBUTE19,

PER_ADDRESSES_F.ADDR_ATTRIBUTE20,

PER_ADDRESSES_F.ADDR_ATTRIBUTE21,

PER_ADDRESSES_F.ADDR_ATTRIBUTE22,

PER_ADDRESSES_F.ADDR_ATTRIBUTE23,

PER_ADDRESSES_F.ADDR_ATTRIBUTE24,

PER_ADDRESSES_F.ADDR_ATTRIBUTE25,

PER_ADDRESSES_F.ADDR_ATTRIBUTE26,

PER_ADDRESSES_F.ADDR_ATTRIBUTE27,

PER_ADDRESSES_F.ADDR_ATTRIBUTE28,

PER_ADDRESSES_F.ADDR_ATTRIBUTE29,

PER_ADDRESSES_F.ADDR_ATTRIBUTE30,

PER_ADDRESSES_F.ADDL_ADDRESS_ATTRIBUTE1,

PER_ADDRESSES_F.ADDL_ADDRESS_ATTRIBUTE2,

PER_ADDRESSES_F.ADDL_ADDRESS_ATTRIBUTE3,

PER_ADDRESSES_F.ADDL_ADDRESS_ATTRIBUTE4,

PER_ADDRESSES_F.ADDL_ADDRESS_ATTRIBUTE5,

PER_ADDRESSES_F.OBJECT_VERSION_NUMBER,

PER_ADDRESSES_F.CREATED_BY,

PER_ADDRESSES_F.CREATION_DATE,

PER_ADDRESSES_F.LAST_UPDATE_DATE,

PER_ADDRESSES_F.LAST_UPDATE_LOGIN,

PER_ADDRESSES_F.LAST_UPDATED_BY

FROM

PER_PERSON_ADDR_USAGES_F,

PER_ADDRESSES_F

WHERE

PER_PERSON_ADDR_USAGES_F.ADDRESS_ID = PER_ADDRESSES_F.ADDRESS_ID AND PER_PERSON_ADDR_USAGES_F.EFFECTIVE_START_DATE = PER_ADDRESSES_F.EFFECTIVE_START_DATE