eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSH.WSH_ITM_ITEMS

Object Details

Object Name:	WSH_ITM_ITEMS
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_ITM_ITEMS
Subobject Name:
Status:	VALID

Stores item information required for license determination. Submitting a request to ITM Adapter for license determination involves creating a row in WSH_ITM_REQUEST_CONTROL and all the items involved in this transaction have to be populated in WSH_ITM_ITEMS with the corresponding request_control_id.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_ITM_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_CONTROL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER		Yes	Primary Key
REQUEST_CONTROL_ID	NUMBER		Yes	Foreign key to WSH_ITM_REQUEST_CONTROL.REQUEST_CONTROL_ID
ORIGINAL_SYSTEM_REFERENCE	NUMBER			Reference Header Id from the Integrating Application. Ex: OM Can populate Order_header_id here.
ORIGINAL_SYSTEM_LINE_REFERENCE	NUMBER			Reference Line Id from the Integrating Application. Ex: OM Can populate Order_line_id here.
PRODUCT_CODE	VARCHAR2	(850)		Product Code(Concatenated segments from mtl_system_items)
DESCRIPTION	VARCHAR2	(500)		Description
CLASSIFIER_TYPE	VARCHAR2	(50)		Indicates the type of Author of the clssification used for the product. Type can be multi country organization(UN), a country(US) or an agency (Bureau of Export Administration).
CLASSIFIER_LABEL	VARCHAR2	(50)		Indicates the actual of Author of the clssification used for the product. If the type is countries then the label can be US.
CLASSIFICATION_TYPE	VARCHAR2	(50)		Indicates the type of classification used. Here type can be CCL or USML.
CLASSIFICATION_LABEL	VARCHAR2	(50)		If Type is CCL then Lable should be a valid ECCN Number.
ENC_MASSMARKET	VARCHAR2	(1)		'Y', if the product is mass marketed.
ENC_PUBLIC	VARCHAR2	(1)		'Y', if the product is publicly available.
ENC_TYPE	VARCHAR2	(1)		The type of encryption used for the product. Valid values for this element include RTL (retail), NRT(non-retail), UOS (unrestricted, open source code), COS (commercially open source code), or CWH (crypto-with-a-hole).
END_USE_TYPE	VARCHAR2	(35)		End Use Type
MILITARY_ENDUSER	VARCHAR2	(1)		'Y' if end user is military classified.
NON_US_GOVT	VARCHAR2	(1)		'Y' if its NON US Govt:
END_USER_CERT	VARCHAR2	(1)		'Y', If the end user certificate is available.
INCO_TERM	VARCHAR2	(50)		Inco term
ITEM_VALUE	NUMBER			Item Value
INCOMING_CURRENCY	VARCHAR2	(50)		Incoming Currency
ATTRIBUTE1_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE2_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE3_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE4_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE5_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE6_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE7_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE8_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE9_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE10_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE11_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE12_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE13_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE14_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE15_NAME	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE1_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE2_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE3_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE4_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE5_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE6_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE7_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE8_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE9_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE10_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE11_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE12_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE13_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE14_VALUE	VARCHAR2	(240)		flexfield attribute
ATTRIBUTE15_VALUE	VARCHAR2	(240)		flexfield attribute
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
ORGANIZATION_ID	NUMBER			Organization ID
SRC_ORGANIZATION_ID	VARCHAR2	(240)		Source organization ID
LONG_DESCRIPTION	VARCHAR2	(4000)		Long Description
HAZARD_CLASS	VARCHAR2	(40)		Hazard Class
ITEM_TYPE	VARCHAR2	(80)		Item Type
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit of Measure
COUNTRY	VARCHAR2	(5)		Country
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code of the Item
OPERATING_UNIT	NUMBER			Operaing UUnit

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 does not reference any database object

WSH.WSH_ITM_ITEMS is referenced by following:

WSH: WSH_ITM_ITEMS#