[Home] [Help] [Dependency Information]
Object Name: | ISC_DBI_TMP_TRIP_STOPS |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DBI_TMP_TRIP_STOPS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | STOP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STOP_ID | NUMBER | Yes | Primary key to identify trip stop | |
CARRIER_ID | NUMBER | Freight carrier identifier | ||
MODE_OF_TRANSPORT | VARCHAR2 | (80) | Mode of transport identifier | |
SERVICE_LEVEL | VARCHAR2 | (80) | Service level identifier | |
TIME_ACTL_ARRL_DATE_ID | DATE | Actual arrival (truncated) date | ||
TIME_INIT_DEPT_DATE_ID | DATE | Initial departure (truncated) date of the trip | ||
TIME_PLN_ARRL_DATE_ID | DATE | Planned arrival (truncated) date | ||
ACTUAL_ARRIVAL_DATE | DATE | Actual arrival date | ||
ACTUAL_DEPARTURE_DATE | DATE | Actual departure date | ||
BATCH_ID | NUMBER | Batch identifier | ||
DISTANCE_TO_NEXT_STOP_TRX | NUMBER | Distance to next stop in transaction unit of measure | ||
DISTANCE_UOM_CODE | VARCHAR2 | (30) | Transaction unit of measure for distance | |
PLANNED_ARRIVAL_DATE | DATE | Planned arrival date | ||
STOP_RANK | NUMBER | Stop sequence number | ||
STOP_SEQUENCE_NUMBER | NUMBER | Stop sequence number | ||
TRIP_ID | NUMBER | Trip identifier | ||
ULTIMATE_STOP_SEQUENCE_NUMBER | NUMBER | Last stop sequence number of the corresponding trip |
Cut, paste (and edit) the following text to query this object:
SELECT STOP_ID
, CARRIER_ID
, MODE_OF_TRANSPORT
, SERVICE_LEVEL
, TIME_ACTL_ARRL_DATE_ID
, TIME_INIT_DEPT_DATE_ID
, TIME_PLN_ARRL_DATE_ID
, ACTUAL_ARRIVAL_DATE
, ACTUAL_DEPARTURE_DATE
, BATCH_ID
, DISTANCE_TO_NEXT_STOP_TRX
, DISTANCE_UOM_CODE
, PLANNED_ARRIVAL_DATE
, STOP_RANK
, STOP_SEQUENCE_NUMBER
, TRIP_ID
, ULTIMATE_STOP_SEQUENCE_NUMBER
FROM ISC.ISC_DBI_TMP_TRIP_STOPS;
ISC.ISC_DBI_TMP_TRIP_STOPS does not reference any database object
ISC.ISC_DBI_TMP_TRIP_STOPS is referenced by following:
|
|
|