VIEW: WSH.WSH_ITM_PARTY_CONTACTS#

Source

View Text - Preformatted

select PARTY_ID PARTY_ID, NAME NAME, JOB_TITLE JOB_TITLE, EMAIL EMAIL, FAX FAX, PHONE PHONE, ATTRIBUTE1_NAME ATTRIBUTE1_NAME, ATTRIBUTE2_NAME ATTRIBUTE2_NAME, ATTRIBUTE3_NAME ATTRIBUTE3_NAME, ATTRIBUTE4_NAME ATTRIBUTE4_NAME, ATTRIBUTE5_NAME ATTRIBUTE5_NAME, ATTRIBUTE6_NAME ATTRIBUTE6_NAME, ATTRIBUTE7_NAME ATTRIBUTE7_NAME, ATTRIBUTE8_NAME ATTRIBUTE8_NAME, ATTRIBUTE9_NAME ATTRIBUTE9_NAME, ATTRIBUTE10_NAME ATTRIBUTE10_NAME, ATTRIBUTE11_NAME ATTRIBUTE11_NAME, ATTRIBUTE12_NAME ATTRIBUTE12_NAME, ATTRIBUTE13_NAME ATTRIBUTE13_NAME, ATTRIBUTE14_NAME ATTRIBUTE14_NAME, ATTRIBUTE15_NAME ATTRIBUTE15_NAME, ATTRIBUTE1_VALUE ATTRIBUTE1_VALUE, ATTRIBUTE2_VALUE ATTRIBUTE2_VALUE, ATTRIBUTE3_VALUE ATTRIBUTE3_VALUE, ATTRIBUTE4_VALUE ATTRIBUTE4_VALUE, ATTRIBUTE5_VALUE ATTRIBUTE5_VALUE, ATTRIBUTE6_VALUE ATTRIBUTE6_VALUE, ATTRIBUTE7_VALUE ATTRIBUTE7_VALUE, ATTRIBUTE8_VALUE ATTRIBUTE8_VALUE, ATTRIBUTE9_VALUE ATTRIBUTE9_VALUE, ATTRIBUTE10_VALUE ATTRIBUTE10_VALUE, ATTRIBUTE11_VALUE ATTRIBUTE11_VALUE, ATTRIBUTE12_VALUE ATTRIBUTE12_VALUE, ATTRIBUTE13_VALUE ATTRIBUTE13_VALUE, ATTRIBUTE14_VALUE ATTRIBUTE14_VALUE, ATTRIBUTE15_VALUE ATTRIBUTE15_VALUE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HZ_PARTY_ID HZ_PARTY_ID, HZ_PARTY_NUMBER HZ_PARTY_NUMBER, HZ_PARTY_TYPE HZ_PARTY_TYPE, HZ_PARTY_STATUS HZ_PARTY_STATUS, ALTERNATE_NAME ALTERNATE_NAME, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, HZ_COUNTRY HZ_COUNTRY, HZ_ADDRESS1 HZ_ADDRESS1, HZ_ADDRESS2 HZ_ADDRESS2, HZ_ADDRESS3 HZ_ADDRESS3, HZ_ADDRESS4 HZ_ADDRESS4, HZ_CITY HZ_CITY, HZ_POSTAL_CODE HZ_POSTAL_CODE, HZ_STATE HZ_STATE, HZ_PROVINCE HZ_PROVINCE, HZ_COUNTY HZ_COUNTY from "WSH"."WSH_ITM_PARTY_CONTACTS"

View Text - HTML Formatted

SELECT PARTY_ID PARTY_ID
, NAME NAME
, JOB_TITLE JOB_TITLE
, EMAIL EMAIL
, FAX FAX
, PHONE PHONE
, ATTRIBUTE1_NAME ATTRIBUTE1_NAME
, ATTRIBUTE2_NAME ATTRIBUTE2_NAME
, ATTRIBUTE3_NAME ATTRIBUTE3_NAME
, ATTRIBUTE4_NAME ATTRIBUTE4_NAME
, ATTRIBUTE5_NAME ATTRIBUTE5_NAME
, ATTRIBUTE6_NAME ATTRIBUTE6_NAME
, ATTRIBUTE7_NAME ATTRIBUTE7_NAME
, ATTRIBUTE8_NAME ATTRIBUTE8_NAME
, ATTRIBUTE9_NAME ATTRIBUTE9_NAME
, ATTRIBUTE10_NAME ATTRIBUTE10_NAME
, ATTRIBUTE11_NAME ATTRIBUTE11_NAME
, ATTRIBUTE12_NAME ATTRIBUTE12_NAME
, ATTRIBUTE13_NAME ATTRIBUTE13_NAME
, ATTRIBUTE14_NAME ATTRIBUTE14_NAME
, ATTRIBUTE15_NAME ATTRIBUTE15_NAME
, ATTRIBUTE1_VALUE ATTRIBUTE1_VALUE
, ATTRIBUTE2_VALUE ATTRIBUTE2_VALUE
, ATTRIBUTE3_VALUE ATTRIBUTE3_VALUE
, ATTRIBUTE4_VALUE ATTRIBUTE4_VALUE
, ATTRIBUTE5_VALUE ATTRIBUTE5_VALUE
, ATTRIBUTE6_VALUE ATTRIBUTE6_VALUE
, ATTRIBUTE7_VALUE ATTRIBUTE7_VALUE
, ATTRIBUTE8_VALUE ATTRIBUTE8_VALUE
, ATTRIBUTE9_VALUE ATTRIBUTE9_VALUE
, ATTRIBUTE10_VALUE ATTRIBUTE10_VALUE
, ATTRIBUTE11_VALUE ATTRIBUTE11_VALUE
, ATTRIBUTE12_VALUE ATTRIBUTE12_VALUE
, ATTRIBUTE13_VALUE ATTRIBUTE13_VALUE
, ATTRIBUTE14_VALUE ATTRIBUTE14_VALUE
, ATTRIBUTE15_VALUE ATTRIBUTE15_VALUE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HZ_PARTY_ID HZ_PARTY_ID
, HZ_PARTY_NUMBER HZ_PARTY_NUMBER
, HZ_PARTY_TYPE HZ_PARTY_TYPE
, HZ_PARTY_STATUS HZ_PARTY_STATUS
, ALTERNATE_NAME ALTERNATE_NAME
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, HZ_COUNTRY HZ_COUNTRY
, HZ_ADDRESS1 HZ_ADDRESS1
, HZ_ADDRESS2 HZ_ADDRESS2
, HZ_ADDRESS3 HZ_ADDRESS3
, HZ_ADDRESS4 HZ_ADDRESS4
, HZ_CITY HZ_CITY
, HZ_POSTAL_CODE HZ_POSTAL_CODE
, HZ_STATE HZ_STATE
, HZ_PROVINCE HZ_PROVINCE
, HZ_COUNTY HZ_COUNTY
FROM "WSH"."WSH_ITM_PARTY_CONTACTS"