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

TABLE: MST.MST_CM_TRIPS

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


MST_CM_TRIPS has continuous move trips records


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_CM_TRIPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnCONTINUOUS_MOVE_ID
MST_CM_TRIPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnCARRIER_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan id
CARRIER_ID NUMBER

Carrier of the continuous move
CARRIER_SERVICE_ID NUMBER

FK to wsh_carrier_services
CONTINUOUS_MOVE_ID NUMBER
Yes Primary key for the table
LANE_ID NUMBER

Lane id of the continuous move. Rating to be based on this lane.
SR_CM_TRIP_ID NUMBER

This column stores the source continuous move id
CM_TRIP_NUMBER NUMBER

Continuous move trip number
PLANNED_FLAG NUMBER
Yes 1 => Trip Firm, 2 => Not Firm
SERVICE_LEVEL VARCHAR2 (30)
Service level for continuous move
START_LOCATION_ID NUMBER

First stop location of the first trip. Denormalize for the UI.
END_LOCATION_ID NUMBER

Last stop location of the last trip. Denormalize for the UI.
START_DATE DATE

Start date of the trip in continuous move.
END_DATE DATE

End date of the trip in continuous move.
VEHICLE_TYPE_ID NUMBER

Foreign key to FTE_VEHICLE_TYPES. Vehicle type used in continuous move trip.
KNOWN_TE_FIRM_STATUS NUMBER

This column stores the known TE firming status
RELEASE_STATUS NUMBER

Y - firm, N - not firm, E - Fail
SELECTED_FOR_RELEASE NUMBER

1 if selected for release, 2 if not selected for release
AUTO_RELEASE_FLAG NUMBER

1 trip released by auto release process, null if not auto released
RELEASE_ERROR_MSG VARCHAR2 (30)
Error message name when release_status_code is in error.
RELEASE_DATE DATE

Date time stamp on which trip is released.
TOTAL_TRANSPORTATION_COST NUMBER

Total transportation cost of continuous move trip
TOTAL_SAVING NUMBER

Total facility handling cost of continuous move trip
CHANGED_BY_USER NUMBER

A flag to indicate whether this CM 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 CM 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.
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 PLAN_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      CONTINUOUS_MOVE_ID
,      LANE_ID
,      SR_CM_TRIP_ID
,      CM_TRIP_NUMBER
,      PLANNED_FLAG
,      SERVICE_LEVEL
,      START_LOCATION_ID
,      END_LOCATION_ID
,      START_DATE
,      END_DATE
,      VEHICLE_TYPE_ID
,      KNOWN_TE_FIRM_STATUS
,      RELEASE_STATUS
,      SELECTED_FOR_RELEASE
,      AUTO_RELEASE_FLAG
,      RELEASE_ERROR_MSG
,      RELEASE_DATE
,      TOTAL_TRANSPORTATION_COST
,      TOTAL_SAVING
,      CHANGED_BY_USER
,      LOCKED_FOR_IMPACT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_CM_TRIPS;

Dependencies

[top of page]

MST.MST_CM_TRIPS does not reference any database object

MST.MST_CM_TRIPS is referenced by following:

SchemaAPPS
SynonymMST_CM_TRIPS