VIEW: HR.PER_ADDRESSES#

Source

View Text - Preformatted

select ADDRESS_ID ADDRESS_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, DATE_FROM DATE_FROM, PRIMARY_FLAG PRIMARY_FLAG, STYLE STYLE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_TYPE ADDRESS_TYPE, COUNTRY COUNTRY, DATE_TO DATE_TO, POSTAL_CODE POSTAL_CODE, REGION_1 REGION_1, REGION_2 REGION_2, REGION_3 REGION_3, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3, TOWN_OR_CITY TOWN_OR_CITY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY, ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1, ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2, ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3, ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4, ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5, ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6, ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7, ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8, ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9, ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10, ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11, ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12, ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13, ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14, ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15, ADDR_ATTRIBUTE16 ADDR_ATTRIBUTE16, ADDR_ATTRIBUTE17 ADDR_ATTRIBUTE17, ADDR_ATTRIBUTE18 ADDR_ATTRIBUTE18, ADDR_ATTRIBUTE19 ADDR_ATTRIBUTE19, ADDR_ATTRIBUTE20 ADDR_ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADD_INFORMATION13 ADD_INFORMATION13, ADD_INFORMATION14 ADD_INFORMATION14, ADD_INFORMATION15 ADD_INFORMATION15, ADD_INFORMATION16 ADD_INFORMATION16, ADD_INFORMATION17 ADD_INFORMATION17, ADD_INFORMATION18 ADD_INFORMATION18, ADD_INFORMATION19 ADD_INFORMATION19, ADD_INFORMATION20 ADD_INFORMATION20, PARTY_ID PARTY_ID, DERIVED_LOCALE DERIVED_LOCALE, GEOMETRY GEOMETRY, COMMENTS COMMENTS from "HR"."PER_ADDRESSES"

View Text - HTML Formatted

SELECT ADDRESS_ID ADDRESS_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, DATE_FROM DATE_FROM
, PRIMARY_FLAG PRIMARY_FLAG
, STYLE STYLE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_TYPE ADDRESS_TYPE
, COUNTRY COUNTRY
, DATE_TO DATE_TO
, POSTAL_CODE POSTAL_CODE
, REGION_1 REGION_1
, REGION_2 REGION_2
, REGION_3 REGION_3
, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, TOWN_OR_CITY TOWN_OR_CITY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, ADDR_ATTRIBUTE16 ADDR_ATTRIBUTE16
, ADDR_ATTRIBUTE17 ADDR_ATTRIBUTE17
, ADDR_ATTRIBUTE18 ADDR_ATTRIBUTE18
, ADDR_ATTRIBUTE19 ADDR_ATTRIBUTE19
, ADDR_ATTRIBUTE20 ADDR_ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADD_INFORMATION13 ADD_INFORMATION13
, ADD_INFORMATION14 ADD_INFORMATION14
, ADD_INFORMATION15 ADD_INFORMATION15
, ADD_INFORMATION16 ADD_INFORMATION16
, ADD_INFORMATION17 ADD_INFORMATION17
, ADD_INFORMATION18 ADD_INFORMATION18
, ADD_INFORMATION19 ADD_INFORMATION19
, ADD_INFORMATION20 ADD_INFORMATION20
, PARTY_ID PARTY_ID
, DERIVED_LOCALE DERIVED_LOCALE
, GEOMETRY GEOMETRY
, COMMENTS COMMENTS
FROM "HR"."PER_ADDRESSES"