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

TABLE: MST.MST_TRIPS

Object Details
Object Name: MST_TRIPS
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


This table stores vehicle trip records i.e. information about an instance of vehicle going from one location to another with intermediate stops


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_TRIPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnTRIP_ID
MST_TRIPS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnTRIP_NUMBER
MST_TRIPS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnVEHICLE_TYPE_ID
MST_TRIPS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnMODE_OF_TRANSPORT
ColumnCARRIER_ID
ColumnSERVICE_LEVEL
MST_TRIPS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnLANE_ID
Columns
Name Datatype Length Mandatory Comments
TRIP_ID NUMBER
Yes Primary key for table
PLAN_ID NUMBER
Yes Unique identifier for plan
SR_TRIP_ID NUMBER

TRIP_ID in TE
TRIP_NUMBER NUMBER

Trip number with in plan
VEHICLE_TYPE_ID NUMBER

FK to MST_VEHICLE_TYPES
STATUS_CODE NUMBER
Yes Trip status codes, 1 - Open, 2 - In Transit, 3 - Closed
PLANNED_FLAG NUMBER
Yes 1 => Load Firm, 2 => Trip Firm, 3 => Not Firm
CARRIER_ID NUMBER

Vendor providing (trip) service
LANE_ID NUMBER

Foreign key to FTE_LANES
SHIP_METHOD_CODE VARCHAR2 (30)
Ship method code for this vehicle trip
CARRIER_SERVICE_ID NUMBER

FK to wsh_carrier_services
SERVICE_LEVEL VARCHAR2 (30)
Service level eg D2D, 2 day, Overnight etc
MODE_OF_TRANSPORT VARCHAR2 (30)
Truck, LTL, Ocean, Parcel etc
LOAD_TENDER_STATUS NUMBER

Load tender status: 1 - Not tendered, 2 - tendered, 3 - Retendered, 4 - Accepted, 5 - Canceled, 6 - Rejected
CONTINUOUS_MOVE_ID NUMBER

All vehicle trips that are part of continuous move will have same continuous move id
CONTINUOUS_MOVE_SEQUENCE NUMBER

Sequence of the load in continuous move
MOVE_TYPE NUMBER

2 - EMPTY, 1 or null - LOADED. To be populated for continuous move
TOTAL_DIRECT_DISTANCE NUMBER

Total driving distance between source and final destination
TOTAL_TRIP_DISTANCE NUMBER

Total distance covered in the trip (denormalized)
TOTAL_BASIC_TRANSPORT_COST NUMBER

Sum of fixed charge + distance charge/wt/vol/piece unit charge+time charge for TL. For ltl/parcel = total charge - discount
TOTAL_ACCESSORIAL_COST NUMBER

Sum of other misc (document/disposal/other charges)
TOTAL_HANDLING_COST NUMBER

Total handling cost
TOTAL_LAYOVER_COST NUMBER

Weekend + weekday layover charge
TOTAL_LOAD_UNLOAD_COST NUMBER

Total load/unload cost at all facilities
TOTAL_STOP_COST NUMBER

For TL, sum of all stop charges
TRIP_START_DATE DATE

for denormalization
PEAK_PALLET_UTILIZATION NUMBER

Peak pallets utilization of the truck
PEAK_VOLUME_UTILIZATION NUMBER

Peak volume utilization of the truck
PEAK_WEIGHT_UTILIZATION NUMBER

Peak weight utilization of the truck
EFFECTIVE_VOL_CAPACITY NUMBER

Effective volume capacity
TRIP_END_DATE DATE

for denormalization
ORIGIN_LOCATION_ID NUMBER

for denormalization
DESTINATION_LOCATION_ID NUMBER

for denormalization
CHANGED_BY_USER NUMBER

A flag to indicate whether this trip is changed by user after plan run so that during reoptimization we can honor user edits
LOCKED_FOR_IMPACT NUMBER

A flag to indicate whether this trip is in the middle of user's action. No other user should modify this trip when this flag is TRUE. 1 - TRUE, 2 - NOT TRUE.
OUT_OF_SCOPE NUMBER

1 out of scope. 2 in scope. Trip is out of scope if delivery detail is not satisfying plan options
RELEASE_STATUS NUMBER

Y trip firm, Y load firm, N not firm, E error
RELEASE_DATE DATE

Date time stamp on which trip is released
SELECTED_FOR_RELEASE NUMBER

Y - if selected for release, N or null if not selected
RELEASE_ERROR_MSG VARCHAR2 (255)
Error message if release_status_code is in error
AUTO_RELEASE_FLAG NUMBER

Trip released by auto release process
KNOWN_TE_FIRM_STATUS NUMBER

This column stores the firming status from TE
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).
Query Text

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


SELECT TRIP_ID
,      PLAN_ID
,      SR_TRIP_ID
,      TRIP_NUMBER
,      VEHICLE_TYPE_ID
,      STATUS_CODE
,      PLANNED_FLAG
,      CARRIER_ID
,      LANE_ID
,      SHIP_METHOD_CODE
,      CARRIER_SERVICE_ID
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      LOAD_TENDER_STATUS
,      CONTINUOUS_MOVE_ID
,      CONTINUOUS_MOVE_SEQUENCE
,      MOVE_TYPE
,      TOTAL_DIRECT_DISTANCE
,      TOTAL_TRIP_DISTANCE
,      TOTAL_BASIC_TRANSPORT_COST
,      TOTAL_ACCESSORIAL_COST
,      TOTAL_HANDLING_COST
,      TOTAL_LAYOVER_COST
,      TOTAL_LOAD_UNLOAD_COST
,      TOTAL_STOP_COST
,      TRIP_START_DATE
,      PEAK_PALLET_UTILIZATION
,      PEAK_VOLUME_UTILIZATION
,      PEAK_WEIGHT_UTILIZATION
,      EFFECTIVE_VOL_CAPACITY
,      TRIP_END_DATE
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      CHANGED_BY_USER
,      LOCKED_FOR_IMPACT
,      OUT_OF_SCOPE
,      RELEASE_STATUS
,      RELEASE_DATE
,      SELECTED_FOR_RELEASE
,      RELEASE_ERROR_MSG
,      AUTO_RELEASE_FLAG
,      KNOWN_TE_FIRM_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_TRIPS;

Dependencies

[top of page]

MST.MST_TRIPS does not reference any database object

MST.MST_TRIPS is referenced by following:

SchemaAPPS
SynonymMST_TRIPS