[Home] [Help]
[Dependency Information]
| Object Name: | WSH_OTM_DLV_OBJ |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| TRANSACTION_CODE | VARCHAR2 | (3) | |
| DELIVERY_ID | NUMBER |
|
|
| NAME | VARCHAR2 | (30) | |
| FREIGHT_TERMS | VARCHAR2 | (30) | |
| FOB_CODE | VARCHAR2 | (30) | |
| CARRIER_ID | VARCHAR2 | (30) | |
| SERVICE_LEVEL | VARCHAR2 | (30) | |
| MODE_OF_TRANSPORT | VARCHAR2 | (30) | |
| INITIAL_PICKUP_LOCATION_ID | VARCHAR2 | (30) | |
| ULTIMATE_DROPOFF_LOCATION_ID | VARCHAR2 | (30) | |
| EARLIEST_PICKUP_DATE | DATE |
|
|
| LATEST_PICKUP_DATE | DATE |
|
|
| EARLIEST_DROPOFF_DATE | DATE |
|
|
| LATEST_DROPOFF_DATE | DATE |
|
|
| GROSS_WEIGHT | NUMBER |
|
|
| WEIGHT_UOM_CODE | VARCHAR2 | (150) | |
| VOLUME | NUMBER |
|
|
| VOLUME_UOM_CODE | VARCHAR2 | (150) | |
| NET_WEIGHT | NUMBER |
|
|
| REVISION | NUMBER |
|
|
| REASON_OF_TRANSPORT | VARCHAR2 | (30) | |
| DESCRIPTION | VARCHAR2 | (30) | |
| ADDITIONAL_SHIPMENT_INFO | VARCHAR2 | (500) | |
| ROUTING_INSTRUCTIONS | VARCHAR2 | (120) | |
| TOTAL_ITEM_COUNT | NUMBER |
|
|
| REVISION_QLFR | VARCHAR2 | (20) | |
| REASON_OF_TRANSPORT_QLFR | VARCHAR2 | (20) | |
| DESCRIPTION_QLFR | VARCHAR2 | (20) | |
| ADDITIONAL_SHIPMENT_INFO_QLFR | VARCHAR2 | (20) | |
| ROUTING_INSTRUCTIONS_QLFR | VARCHAR2 | (20) | |
| RL_DETAILS |
WSH_OTM_DET_TAB
|
|
|
| LPN |
WSH_OTM_LPN_TAB
|
|
APPS
WSH_OTM_DET_TAB
WSH_OTM_LPN_TAB
SYS
STANDARD
- show dependent code
APPS
WSH_OTM_DLV_TAB
WSH_OTM_OUTBOUND
- show dependent code
|
|
|
|