[Home] [Help] [Dependency Information]
Object Name: | CSF_TDS_ROUTE_CACHE |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_TDS_ROUTE_CACHE |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000148613C00018$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000148613C00019$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000148613C00020$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
CSF_TDS_RCT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FROM_SEGMENT_ID
TO_SEGMENT_ID CONFIG FROM_SEGMENT_SIDE TO_SEGMENT_SIDE FROM_SEGMENT_POSITION TO_SEGMENT_POSITION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT_FROM | NUMBER | |||
SIDE_FROM | NUMBER | |||
SPOT_FROM | NUMBER | |||
SEGMENT_TO | NUMBER | |||
SIDE_TO | NUMBER | |||
SPOT_TO | NUMBER | |||
RESULTTIME | NUMBER | |||
RESULTDISTANCE | NUMBER | |||
DATETIME | DATE | |||
HITCOUNT | NUMBER | |||
ROUTE_CACHE_ID | NUMBER | (30) | ||
GEOMETRY | SDO_GEOMETRY | (1) | ||
ROUTE | CLOB | (4000) | ||
SECURITY_GROUP_ID | NUMBER | |||
FROM_SEGMENT_ID | NUMBER | (15) | ||
TO_SEGMENT_ID | NUMBER | (15) | ||
CONFIG | VARCHAR2 | (100) | ||
TIME | NUMBER | (15) | ||
DISTANCE | NUMBER | (15) | ||
COST | NUMBER | (15) | ||
RAMHITCOUNT | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
FROM_SEGMENT_SIDE | VARCHAR2 | (1) | ||
TO_SEGMENT_SIDE | VARCHAR2 | (1) | ||
FROM_SEGMENT_POSITION | VARCHAR2 | (3) | ||
TO_SEGMENT_POSITION | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_FROM
, SIDE_FROM
, SPOT_FROM
, SEGMENT_TO
, SIDE_TO
, SPOT_TO
, RESULTTIME
, RESULTDISTANCE
, DATETIME
, HITCOUNT
, ROUTE_CACHE_ID
, GEOMETRY
, ROUTE
, SECURITY_GROUP_ID
, FROM_SEGMENT_ID
, TO_SEGMENT_ID
, CONFIG
, TIME
, DISTANCE
, COST
, RAMHITCOUNT
, CREATION_DATE
, LAST_UPDATE_DATE
, FROM_SEGMENT_SIDE
, TO_SEGMENT_SIDE
, FROM_SEGMENT_POSITION
, TO_SEGMENT_POSITION
FROM CSF.CSF_TDS_ROUTE_CACHE;
|
|
|