VIEW: WSH.WSH_ITM_ITEMS#

Source

View Text - Preformatted

select ITEM_ID ITEM_ID, REQUEST_CONTROL_ID REQUEST_CONTROL_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, PRODUCT_CODE PRODUCT_CODE, DESCRIPTION DESCRIPTION, CLASSIFIER_TYPE CLASSIFIER_TYPE, CLASSIFIER_LABEL CLASSIFIER_LABEL, CLASSIFICATION_TYPE CLASSIFICATION_TYPE, CLASSIFICATION_LABEL CLASSIFICATION_LABEL, ENC_MASSMARKET ENC_MASSMARKET, ENC_PUBLIC ENC_PUBLIC, ENC_TYPE ENC_TYPE, END_USE_TYPE END_USE_TYPE, MILITARY_ENDUSER MILITARY_ENDUSER, NON_US_GOVT NON_US_GOVT, END_USER_CERT END_USER_CERT, INCO_TERM INCO_TERM, ITEM_VALUE ITEM_VALUE, INCOMING_CURRENCY INCOMING_CURRENCY, 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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SRC_ORGANIZATION_ID SRC_ORGANIZATION_ID, LONG_DESCRIPTION LONG_DESCRIPTION, HAZARD_CLASS HAZARD_CLASS, ITEM_TYPE ITEM_TYPE, UNIT_OF_MEASURE UNIT_OF_MEASURE, COUNTRY COUNTRY, ORGANIZATION_CODE ORGANIZATION_CODE, OPERATING_UNIT OPERATING_UNIT from "WSH"."WSH_ITM_ITEMS"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, REQUEST_CONTROL_ID REQUEST_CONTROL_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, PRODUCT_CODE PRODUCT_CODE
, DESCRIPTION DESCRIPTION
, CLASSIFIER_TYPE CLASSIFIER_TYPE
, CLASSIFIER_LABEL CLASSIFIER_LABEL
, CLASSIFICATION_TYPE CLASSIFICATION_TYPE
, CLASSIFICATION_LABEL CLASSIFICATION_LABEL
, ENC_MASSMARKET ENC_MASSMARKET
, ENC_PUBLIC ENC_PUBLIC
, ENC_TYPE ENC_TYPE
, END_USE_TYPE END_USE_TYPE
, MILITARY_ENDUSER MILITARY_ENDUSER
, NON_US_GOVT NON_US_GOVT
, END_USER_CERT END_USER_CERT
, INCO_TERM INCO_TERM
, ITEM_VALUE ITEM_VALUE
, INCOMING_CURRENCY INCOMING_CURRENCY
, 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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SRC_ORGANIZATION_ID SRC_ORGANIZATION_ID
, LONG_DESCRIPTION LONG_DESCRIPTION
, HAZARD_CLASS HAZARD_CLASS
, ITEM_TYPE ITEM_TYPE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, COUNTRY COUNTRY
, ORGANIZATION_CODE ORGANIZATION_CODE
, OPERATING_UNIT OPERATING_UNIT
FROM "WSH"."WSH_ITM_ITEMS"