eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.HR_H2PI_ADDRESSES#

Source

View Text - Preformatted


select LAST_UPD_DATE LAST_UPD_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, ADDRESS_ID ADDRESS_ID, PERSON_ID PERSON_ID, STYLE STYLE, DATE_FROM DATE_FROM, DATE_TO DATE_TO, ADDRESS_TYPE ADDRESS_TYPE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, TOWN_OR_CITY TOWN_OR_CITY, REGION_1 REGION_1, REGION_2 REGION_2, REGION_3 REGION_3, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3, 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, 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, STATUS STATUS from "HR"."HR_H2PI_ADDRESSES"

View Text - HTML Formatted

SELECT LAST_UPD_DATE LAST_UPD_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, ADDRESS_ID ADDRESS_ID
, PERSON_ID PERSON_ID
, STYLE STYLE
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, ADDRESS_TYPE ADDRESS_TYPE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, TOWN_OR_CITY TOWN_OR_CITY
, REGION_1 REGION_1
, REGION_2 REGION_2
, REGION_3 REGION_3
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, 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
, 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
, STATUS STATUS
FROM "HR"."HR_H2PI_ADDRESSES"