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

TABLE: MSC.MSC_TRIP_STOPS

Object Details
Object Name: MSC_TRIP_STOPS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


MSC_TRIP_STOPS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_TRIP_STOPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnSTOP_ID
MSC_TRIP_STOPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnSTOP_LOCATION_ID
MSC_TRIP_STOPS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnTRIP_ID
Columns
Name Datatype Length Mandatory Comments
STOP_ID NUMBER
Yes Stop ID
STOP_LOCATION_ID NUMBER
Yes Location ID
STATUS_CODE VARCHAR2 (2) Yes Stop Statu Code OP- Open IT- In transit CL- Closed
STOP_SEQUENCE_NUMBER NUMBER
Yes Indicates sequence of Stops on trip
PLANNED_ARRIVAL_DATE DATE

Date on which trip is planned to arrive at the stop.
PLANNED_DEPARTURE_DATE DATE

Date on which trip is planned to depart from stop.
TRIP_ID NUMBER
Yes Trip Identifier
SR_INSTANCE_ID NUMBER
Yes Instance Identifier
PLAN_ID NUMBER
Yes Plan Identifier
LAST_UPDATE_DATE DATE
Yes Who Columns?
LAST_UPDATED_BY NUMBER
Yes Who Columns?
CREATION_DATE DATE
Yes Who Columns?
CREATED_BY NUMBER
Yes Who Columns?
LAST_UPDATE_LOGIN NUMBER

Who Columns?
REFRESH_NUMBER NUMBER

Refresh Number
Query Text

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


SELECT STOP_ID
,      STOP_LOCATION_ID
,      STATUS_CODE
,      STOP_SEQUENCE_NUMBER
,      PLANNED_ARRIVAL_DATE
,      PLANNED_DEPARTURE_DATE
,      TRIP_ID
,      SR_INSTANCE_ID
,      PLAN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REFRESH_NUMBER
FROM MSC.MSC_TRIP_STOPS;

Dependencies

[top of page]

MSC.MSC_TRIP_STOPS does not reference any database object

MSC.MSC_TRIP_STOPS is referenced by following:

SchemaAPPS
SynonymMSC_TRIP_STOPS