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 |