DBA Data[Home] [Help] [Dependency Information]

VIEW: WSH.WSH_ITM_ITEMS#

Object Details
Object Name: WSH_ITM_ITEMS#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER
Yes
REQUEST_CONTROL_ID NUMBER
Yes
ORIGINAL_SYSTEM_REFERENCE NUMBER

ORIGINAL_SYSTEM_LINE_REFERENCE NUMBER

PRODUCT_CODE VARCHAR2 (850)
DESCRIPTION VARCHAR2 (500)
CLASSIFIER_TYPE VARCHAR2 (50)
CLASSIFIER_LABEL VARCHAR2 (50)
CLASSIFICATION_TYPE VARCHAR2 (50)
CLASSIFICATION_LABEL VARCHAR2 (50)
ENC_MASSMARKET VARCHAR2 (1)
ENC_PUBLIC VARCHAR2 (1)
ENC_TYPE VARCHAR2 (1)
END_USE_TYPE VARCHAR2 (35)
MILITARY_ENDUSER VARCHAR2 (1)
NON_US_GOVT VARCHAR2 (1)
END_USER_CERT VARCHAR2 (1)
INCO_TERM VARCHAR2 (50)
ITEM_VALUE NUMBER

INCOMING_CURRENCY VARCHAR2 (50)
ATTRIBUTE1_NAME VARCHAR2 (240)
ATTRIBUTE2_NAME VARCHAR2 (240)
ATTRIBUTE3_NAME VARCHAR2 (240)
ATTRIBUTE4_NAME VARCHAR2 (240)
ATTRIBUTE5_NAME VARCHAR2 (240)
ATTRIBUTE6_NAME VARCHAR2 (240)
ATTRIBUTE7_NAME VARCHAR2 (240)
ATTRIBUTE8_NAME VARCHAR2 (240)
ATTRIBUTE9_NAME VARCHAR2 (240)
ATTRIBUTE10_NAME VARCHAR2 (240)
ATTRIBUTE11_NAME VARCHAR2 (240)
ATTRIBUTE12_NAME VARCHAR2 (240)
ATTRIBUTE13_NAME VARCHAR2 (240)
ATTRIBUTE14_NAME VARCHAR2 (240)
ATTRIBUTE15_NAME VARCHAR2 (240)
ATTRIBUTE1_VALUE VARCHAR2 (240)
ATTRIBUTE2_VALUE VARCHAR2 (240)
ATTRIBUTE3_VALUE VARCHAR2 (240)
ATTRIBUTE4_VALUE VARCHAR2 (240)
ATTRIBUTE5_VALUE VARCHAR2 (240)
ATTRIBUTE6_VALUE VARCHAR2 (240)
ATTRIBUTE7_VALUE VARCHAR2 (240)
ATTRIBUTE8_VALUE VARCHAR2 (240)
ATTRIBUTE9_VALUE VARCHAR2 (240)
ATTRIBUTE10_VALUE VARCHAR2 (240)
ATTRIBUTE11_VALUE VARCHAR2 (240)
ATTRIBUTE12_VALUE VARCHAR2 (240)
ATTRIBUTE13_VALUE VARCHAR2 (240)
ATTRIBUTE14_VALUE VARCHAR2 (240)
ATTRIBUTE15_VALUE VARCHAR2 (240)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SRC_ORGANIZATION_ID VARCHAR2 (240)
LONG_DESCRIPTION VARCHAR2 (4000)
HAZARD_CLASS VARCHAR2 (40)
ITEM_TYPE VARCHAR2 (80)
UNIT_OF_MEASURE VARCHAR2 (3)
COUNTRY VARCHAR2 (5)
ORGANIZATION_CODE VARCHAR2 (3)
OPERATING_UNIT NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_ID
,      REQUEST_CONTROL_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      PRODUCT_CODE
,      DESCRIPTION
,      CLASSIFIER_TYPE
,      CLASSIFIER_LABEL
,      CLASSIFICATION_TYPE
,      CLASSIFICATION_LABEL
,      ENC_MASSMARKET
,      ENC_PUBLIC
,      ENC_TYPE
,      END_USE_TYPE
,      MILITARY_ENDUSER
,      NON_US_GOVT
,      END_USER_CERT
,      INCO_TERM
,      ITEM_VALUE
,      INCOMING_CURRENCY
,      ATTRIBUTE1_NAME
,      ATTRIBUTE2_NAME
,      ATTRIBUTE3_NAME
,      ATTRIBUTE4_NAME
,      ATTRIBUTE5_NAME
,      ATTRIBUTE6_NAME
,      ATTRIBUTE7_NAME
,      ATTRIBUTE8_NAME
,      ATTRIBUTE9_NAME
,      ATTRIBUTE10_NAME
,      ATTRIBUTE11_NAME
,      ATTRIBUTE12_NAME
,      ATTRIBUTE13_NAME
,      ATTRIBUTE14_NAME
,      ATTRIBUTE15_NAME
,      ATTRIBUTE1_VALUE
,      ATTRIBUTE2_VALUE
,      ATTRIBUTE3_VALUE
,      ATTRIBUTE4_VALUE
,      ATTRIBUTE5_VALUE
,      ATTRIBUTE6_VALUE
,      ATTRIBUTE7_VALUE
,      ATTRIBUTE8_VALUE
,      ATTRIBUTE9_VALUE
,      ATTRIBUTE10_VALUE
,      ATTRIBUTE11_VALUE
,      ATTRIBUTE12_VALUE
,      ATTRIBUTE13_VALUE
,      ATTRIBUTE14_VALUE
,      ATTRIBUTE15_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SRC_ORGANIZATION_ID
,      LONG_DESCRIPTION
,      HAZARD_CLASS
,      ITEM_TYPE
,      UNIT_OF_MEASURE
,      COUNTRY
,      ORGANIZATION_CODE
,      OPERATING_UNIT
FROM WSH.WSH_ITM_ITEMS#;

Dependencies

[top of page]

WSH.WSH_ITM_ITEMS# references the following:

SchemaWSH
TableWSH_ITM_ITEMS
WSH.WSH_ITM_ITEMS# is referenced by following:

SchemaAPPS
SynonymWSH_ITM_ITEMS