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_SERIAL_NUMBERS

Object Details

Object Name:	WSH_ITM_SERIAL_NUMBERS
Object Type:	TABLE
Owner:	WSH
Subobject Name:
Status:	VALID

Stores information of the serial numbers of the delivery details. Submitting a delivery screening request to ITM Adapter involves creating a row in WSH_ITM_REQUEST_CONTROL. All serial numbers of the deliveries, which have to be screened as part of this request have to be populated in WSH_ITM_SERIAL_NUMBERS with the corresponding request_control_id,delivery_id and delivery_detail_id.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER	(22)	Yes	Delivery ID for which the serial number is associated
REQUEST_CONTROL_ID	NUMBER	(22)	Yes	Foreign Key to WSH_ITM_REQUEST_CONTROL.REQUEST_CONTROL_ID
DELIVERY_DETAIL_ID	NUMBER	(22)	Yes	Delivery Detail ID for which the serial number is associated
SERIAL_NUMBER	VARCHAR2	(240)		Serial Number

Query Text

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


SELECT DELIVERY_ID
,      REQUEST_CONTROL_ID
,      DELIVERY_DETAIL_ID
,      SERIAL_NUMBER
FROM WSH.WSH_ITM_SERIAL_NUMBERS;

Dependencies

[top of page]

WSH.WSH_ITM_SERIAL_NUMBERS does not reference any database object

WSH.WSH_ITM_SERIAL_NUMBERS is referenced by following:

APPS: WSH_ITM_SERIAL_NUMBERS