eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ISC.MLOG$_ISC_DBI_TRIP_STOPS_F

Object Details

Object Name:	MLOG$_ISC_DBI_TRIP_STOPS_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

snapshot log for master table ISC.ISC_DBI_TRIP_STOPS_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
ACTUAL_ARRIVAL_DATE	DATE
ACTUAL_DEPARTURE_DATE	DATE
CARRIER_ID	NUMBER
DISTANCE_TO_NEXT_STOP_G	NUMBER
DISTANCE_TO_NEXT_STOP_TRX	NUMBER
DISTANCE_UOM_CODE	VARCHAR2	(30)
MODE_OF_TRANSPORT	VARCHAR2	(80)
PLANNED_ARRIVAL_DATE	DATE
SERVICE_LEVEL	VARCHAR2	(80)
STOP_ID	NUMBER
STOP_RANK	NUMBER
STOP_SEQUENCE_NUMBER	NUMBER
TIME_ACTL_ARRL_DATE_ID	DATE
TIME_INIT_DEPT_DATE_ID	DATE
TIME_PLN_ARRL_DATE_ID	DATE
TRIP_FREIGHT_COST_G	NUMBER
TRIP_FREIGHT_COST_G1	NUMBER
TRIP_ID	NUMBER
ULTIMATE_STOP_SEQUENCE_NUMBER	NUMBER
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTUAL_ARRIVAL_DATE
,      ACTUAL_DEPARTURE_DATE
,      CARRIER_ID
,      DISTANCE_TO_NEXT_STOP_G
,      DISTANCE_TO_NEXT_STOP_TRX
,      DISTANCE_UOM_CODE
,      MODE_OF_TRANSPORT
,      PLANNED_ARRIVAL_DATE
,      SERVICE_LEVEL
,      STOP_ID
,      STOP_RANK
,      STOP_SEQUENCE_NUMBER
,      TIME_ACTL_ARRL_DATE_ID
,      TIME_INIT_DEPT_DATE_ID
,      TIME_PLN_ARRL_DATE_ID
,      TRIP_FREIGHT_COST_G
,      TRIP_FREIGHT_COST_G1
,      TRIP_ID
,      ULTIMATE_STOP_SEQUENCE_NUMBER
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_DBI_TRIP_STOPS_F;

Dependencies

[top of page]

ISC.MLOG$_ISC_DBI_TRIP_STOPS_F does not reference any database object

ISC.MLOG$_ISC_DBI_TRIP_STOPS_F is referenced by following:

APPS: MLOG$_ISC_DBI_TRIP_STOPS_F