[Home] [Help] [Dependency Information]
Object Name: | MST_RELATED_LOADS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
Contains related loads of a trip grouped together.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | FK to mst_plans | ||
GROUP_ID | NUMBER | Sequence generated for grouping related trips. | ||
CONTINUOUS_MOVE_ID | NUMBER | FK to mst_cm_trips | ||
TRIP_ID | NUMBER | FK to mst_trips | ||
MODE_OF_TRANSPORT | VARCHAR2 | (30) | mode of transport of the trip. | |
STATUS | NUMBER | 0 or null - if trip's related loads are not evaluated, 1 - trip's related loads are evaluated. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, GROUP_ID
, CONTINUOUS_MOVE_ID
, TRIP_ID
, MODE_OF_TRANSPORT
, STATUS
FROM MST.MST_RELATED_LOADS_TEMP;
MST.MST_RELATED_LOADS_TEMP does not reference any database object
MST.MST_RELATED_LOADS_TEMP is referenced by following:
|
|
|