[Home] [Help] [Dependency Information]
Object Name: | MST_TRIP_STOPS |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
MST_TRIP_STOPS has vehicle trip stop records
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MST_TRIP_STOPS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
STOP_ID |
MST_TRIP_STOPS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
TRIP_ID |
MST_TRIP_STOPS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PLANNED_ARRIVAL_DATE |
MST_TRIP_STOPS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
STOP_LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STOP_ID | NUMBER | Yes | Primary key for table | |
TRIP_ID | NUMBER | Yes | Trip id. Foreign key to MST_TRIPS. | |
SR_STOP_ID | NUMBER | Stop Id in TE instance | ||
STOP_LOCATION_ID | NUMBER | Yes | Foreign key to WSH_LOCATIONS | |
STOP_SEQUENCE_NUMBER | NUMBER | Yes | Indicates sequence of stop on trip. | |
PLAN_ID | NUMBER | Yes | This column stores the plan id that owns the trip that has this trip stops | |
PLANNED_ARRIVAL_DATE | DATE | Date on which the trip is planned to arrive at the stop | ||
PLANNED_DEPARTURE_DATE | DATE | Date on which the trip is planned to depart from the stop | ||
PLN_LOADING_START_TIME | DATE | Time when the loading starts | ||
PLN_LOADING_END_TIME | DATE | Time when the loading ends | ||
PLN_UNLOADING_START_TIME | DATE | Time when the unloading should start | ||
PLN_UNLOADING_END_TIME | DATE | Time when the unloading should end | ||
DEPARTURE_GROSS_WEIGHT | NUMBER | Required for dynamic planning | ||
DEPARTURE_NET_WEIGHT | NUMBER | Required for dynamic planning | ||
DEPARTURE_VOLUME | NUMBER | Required for dynamic planning | ||
DEPARTURE_FILL_PERCENT | NUMBER | Required for dynamic planning | ||
DEPARTURE_PIECES | NUMBER | Total pieces departed from this stop. Denormalized for UI. | ||
DEPARTURE_PALLETS | NUMBER | Total pallets departed from this stop. Denormalized for UI. | ||
DISTANCE_TO_NEXT_STOP | NUMBER | Planned driving distance between next stop and this stop | ||
DRV_TIME_TO_NEXT_STOP | NUMBER | Planned driving time to next stop | ||
WKEND_LAYOVER_STOPS | NUMBER | Number of weekend layover stops from previous stops | ||
WKDAY_LAYOVER_STOPS | NUMBER | Number of weekdays layover stops from previous stops | ||
TOTAL_LAYOVER_DURATION | NUMBER | Total layover stop duration | ||
DISTANCE_COST | NUMBER | This column stores the distance cost from this stop to the next stop in the same trip | ||
CARRIER_LOADING_COST | NUMBER | This column stores the loading cost at this stop | ||
CARRIER_UNLOADING_COST | NUMBER | This column stores the unloading cost at this stop | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT STOP_ID
, TRIP_ID
, SR_STOP_ID
, STOP_LOCATION_ID
, STOP_SEQUENCE_NUMBER
, PLAN_ID
, PLANNED_ARRIVAL_DATE
, PLANNED_DEPARTURE_DATE
, PLN_LOADING_START_TIME
, PLN_LOADING_END_TIME
, PLN_UNLOADING_START_TIME
, PLN_UNLOADING_END_TIME
, DEPARTURE_GROSS_WEIGHT
, DEPARTURE_NET_WEIGHT
, DEPARTURE_VOLUME
, DEPARTURE_FILL_PERCENT
, DEPARTURE_PIECES
, DEPARTURE_PALLETS
, DISTANCE_TO_NEXT_STOP
, DRV_TIME_TO_NEXT_STOP
, WKEND_LAYOVER_STOPS
, WKDAY_LAYOVER_STOPS
, TOTAL_LAYOVER_DURATION
, DISTANCE_COST
, CARRIER_LOADING_COST
, CARRIER_UNLOADING_COST
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM MST.MST_TRIP_STOPS;
MST.MST_TRIP_STOPS does not reference any database object
MST.MST_TRIP_STOPS is referenced by following:
|
|
|