[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
WSH.WSH_ITM_SERIAL_NUMBERS does not reference any database object
WSH.WSH_ITM_SERIAL_NUMBERS is referenced by following:
|
|
|