[Home] [Help] [Dependency Information]
Object Name: | ISC_DBI_TRIP_STOPS_F |
---|---|
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_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DBI_TRIP_STOPS_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | 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 | ||
DISTANCE_TO_NEXT_STOP_G | NUMBER | Distance to next stop in reporting unit of measure | ||
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_FREIGHT_COST_G | NUMBER | Trip freight cost in primary global currency | ||
TRIP_FREIGHT_COST_G1 | NUMBER | Trip freight cost in secondary global currency | ||
TRIP_ID | NUMBER | Trip identifier | ||
ULTIMATE_STOP_SEQUENCE_NUMBER | NUMBER | Last stop sequence number of the corresponding trip | ||
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard WHO Column | ||
PROGRAM_ID | NUMBER | Standard WHO Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard WHO Column | ||
REQUEST_ID | NUMBER | Standard WHO Column |
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
, DISTANCE_TO_NEXT_STOP_G
, DISTANCE_TO_NEXT_STOP_TRX
, DISTANCE_UOM_CODE
, PLANNED_ARRIVAL_DATE
, STOP_RANK
, STOP_SEQUENCE_NUMBER
, TRIP_FREIGHT_COST_G
, TRIP_FREIGHT_COST_G1
, TRIP_ID
, ULTIMATE_STOP_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM ISC.ISC_DBI_TRIP_STOPS_F;
ISC.ISC_DBI_TRIP_STOPS_F does not reference any database object
ISC.ISC_DBI_TRIP_STOPS_F is referenced by following:
|
|
|