VIEW: WSH.WSH_ITM_DENIED_PARTIES#

Source

View Text - Preformatted

select RESPONSE_LINE_ID RESPONSE_LINE_ID, MATCH_TYPE MATCH_TYPE, MATCH_DESC MATCH_DESC, MATCH_WORDS MATCH_WORDS, NOTE1 NOTE1, NOTE2 NOTE2, NOTE3 NOTE3, DOCUMENT_VOLUME DOCUMENT_VOLUME, DOCUMENT_PAGE DOCUMENT_PAGE, DOCUMENT_DATE DOCUMENT_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, EXPIRATION_DATE EXPIRATION_DATE, NAME NAME, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, ADDRESS5 ADDRESS5, CITY CITY, STATE_OR_PROVINCE STATE_OR_PROVINCE, COUNTRY_CODE COUNTRY_CODE, COUNTRY_NAME COUNTRY_NAME, POSTAL_CODE POSTAL_CODE, CONTACT_NAME CONTACT_NAME, EMAIL EMAIL, PHONE PHONE, 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 from "WSH"."WSH_ITM_DENIED_PARTIES"

View Text - HTML Formatted

SELECT RESPONSE_LINE_ID RESPONSE_LINE_ID
, MATCH_TYPE MATCH_TYPE
, MATCH_DESC MATCH_DESC
, MATCH_WORDS MATCH_WORDS
, NOTE1 NOTE1
, NOTE2 NOTE2
, NOTE3 NOTE3
, DOCUMENT_VOLUME DOCUMENT_VOLUME
, DOCUMENT_PAGE DOCUMENT_PAGE
, DOCUMENT_DATE DOCUMENT_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, NAME NAME
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, ADDRESS5 ADDRESS5
, CITY CITY
, STATE_OR_PROVINCE STATE_OR_PROVINCE
, COUNTRY_CODE COUNTRY_CODE
, COUNTRY_NAME COUNTRY_NAME
, POSTAL_CODE POSTAL_CODE
, CONTACT_NAME CONTACT_NAME
, EMAIL EMAIL
, PHONE PHONE
, 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
FROM "WSH"."WSH_ITM_DENIED_PARTIES"