[Home] [Help] [Dependency Information]
Object Name: | WSH_DEL_WV_UPGRADE_TMP |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
WSH_DEL_WV_UPGRADE_TMP will hold information related deliveries and trips which are associated with containers being upgraded as part of LPN Converence Project.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_DEL_WV_UPGRADE_TMP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELIVERY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | Delivery Identifier | ||
TRIP_ID | NUMBER | Trip Identifier | ||
PICK_UP_STOP_SEQ_NUMBER | NUMBER | Pickup Stop Sequence Number | ||
DROP_OFF_STOP_SEQ_NUMBER | NUMBER | Dropoff Stop Sequence Number | ||
REC_VALID_FLAG | VARCHAR2 | (10) | Y-indicates record already upgraded. N-indicates record needs to be upgraded |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, TRIP_ID
, PICK_UP_STOP_SEQ_NUMBER
, DROP_OFF_STOP_SEQ_NUMBER
, REC_VALID_FLAG
FROM WSH.WSH_DEL_WV_UPGRADE_TMP;
WSH.WSH_DEL_WV_UPGRADE_TMP does not reference any database object
WSH.WSH_DEL_WV_UPGRADE_TMP is referenced by following:
|
|
|