VIEW: WSH.WSH_ITM_PARTIES#

Source

View Text - Preformatted

select PARTY_ID PARTY_ID, REQUEST_CONTROL_ID REQUEST_CONTROL_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, SOURCE_ORG_ID SOURCE_ORG_ID, PARTY_TYPE PARTY_TYPE, PARTY_NAME PARTY_NAME, PARTY_ADDRESS1 PARTY_ADDRESS1, PARTY_ADDRESS2 PARTY_ADDRESS2, PARTY_ADDRESS3 PARTY_ADDRESS3, PARTY_ADDRESS4 PARTY_ADDRESS4, PARTY_ADDRESS5 PARTY_ADDRESS5, PARTY_CITY PARTY_CITY, PARTY_STATE PARTY_STATE, PARTY_COUNTRY_CODE PARTY_COUNTRY_CODE, PARTY_COUNTRY_NAME PARTY_COUNTRY_NAME, POSTAL_CODE POSTAL_CODE, CONTACT_NAME CONTACT_NAME, PHONE PHONE, EMAIL EMAIL, FAX FAX, WEB WEB, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUST_SITE_USE_ID CUST_SITE_USE_ID, ACCOUNT_NAME ACCOUNT_NAME, ACCOUNT_NUMBER ACCOUNT_NUMBER, TAX_REFERENCE TAX_REFERENCE, PARTY_SITE_NUMBER PARTY_SITE_NUMBER, ALTERNATE_NAME ALTERNATE_NAME, OPERATING_UNIT OPERATING_UNIT, ADDRTYPE ADDRTYPE, PARTNER_CODE PARTNER_CODE, HZ_PARTY_ID HZ_PARTY_ID, HZ_PARTY_NUMBER HZ_PARTY_NUMBER, HZ_PARTY_TYPE HZ_PARTY_TYPE, HZ_PARTY_STATUS HZ_PARTY_STATUS, HZ_HQ_BRANCH_IND HZ_HQ_BRANCH_IND, HZ_SIC_CODE HZ_SIC_CODE, HZ_SIC_CODE_TYPE HZ_SIC_CODE_TYPE, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, HZ_LOCATION_ID HZ_LOCATION_ID, 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, CONTACT_HZ_PARTY_ID CONTACT_HZ_PARTY_ID, CONTACT_HZ_PARTY_NUMBER CONTACT_HZ_PARTY_NUMBER from "WSH"."WSH_ITM_PARTIES"

View Text - HTML Formatted

SELECT PARTY_ID PARTY_ID
, REQUEST_CONTROL_ID REQUEST_CONTROL_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, SOURCE_ORG_ID SOURCE_ORG_ID
, PARTY_TYPE PARTY_TYPE
, PARTY_NAME PARTY_NAME
, PARTY_ADDRESS1 PARTY_ADDRESS1
, PARTY_ADDRESS2 PARTY_ADDRESS2
, PARTY_ADDRESS3 PARTY_ADDRESS3
, PARTY_ADDRESS4 PARTY_ADDRESS4
, PARTY_ADDRESS5 PARTY_ADDRESS5
, PARTY_CITY PARTY_CITY
, PARTY_STATE PARTY_STATE
, PARTY_COUNTRY_CODE PARTY_COUNTRY_CODE
, PARTY_COUNTRY_NAME PARTY_COUNTRY_NAME
, POSTAL_CODE POSTAL_CODE
, CONTACT_NAME CONTACT_NAME
, PHONE PHONE
, EMAIL EMAIL
, FAX FAX
, WEB WEB
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUST_SITE_USE_ID CUST_SITE_USE_ID
, ACCOUNT_NAME ACCOUNT_NAME
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, TAX_REFERENCE TAX_REFERENCE
, PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, ALTERNATE_NAME ALTERNATE_NAME
, OPERATING_UNIT OPERATING_UNIT
, ADDRTYPE ADDRTYPE
, PARTNER_CODE PARTNER_CODE
, HZ_PARTY_ID HZ_PARTY_ID
, HZ_PARTY_NUMBER HZ_PARTY_NUMBER
, HZ_PARTY_TYPE HZ_PARTY_TYPE
, HZ_PARTY_STATUS HZ_PARTY_STATUS
, HZ_HQ_BRANCH_IND HZ_HQ_BRANCH_IND
, HZ_SIC_CODE HZ_SIC_CODE
, HZ_SIC_CODE_TYPE HZ_SIC_CODE_TYPE
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, HZ_LOCATION_ID HZ_LOCATION_ID
, 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
, CONTACT_HZ_PARTY_ID CONTACT_HZ_PARTY_ID
, CONTACT_HZ_PARTY_NUMBER CONTACT_HZ_PARTY_NUMBER
FROM "WSH"."WSH_ITM_PARTIES"