[Home] [Help] [Dependency Information]
Object Name: | MST_DELIVERY_LEGS |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
This table mapping deliveries to their pickup and dropoff stops
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MST_DELIVERY_LEGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
DELIVERY_LEG_ID |
MST_DELIVERY_LEGS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
DELIVERY_ID |
MST_DELIVERY_LEGS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PICK_UP_STOP_ID |
MST_DELIVERY_LEGS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
DROP_OFF_STOP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_LEG_ID | NUMBER | Yes | Primary key for delivery leg | |
SR_DELIVERY_ID | NUMBER | This column stores the source delivery id | ||
DELIVERY_ID | NUMBER | Yes | Delivery identifier for this leg | |
PLAN_ID | NUMBER | Yes | FK to MST_PLANS | |
TRIP_ID | NUMBER | Denormalize for UI. | ||
SR_DELIVERY_LEG_ID | NUMBER | This column stores the source delivery leg id | ||
SEQUENCE_NUMBER | NUMBER | Yes | Sequence number of legs for this delivery | |
LOADING_SEQ_NUM | NUMBER | Sequence in which this is to be loaded in a trip | ||
UNLOADING_SEQ_NUM | NUMBER | Sequence in which this is to be unloaded in a trip | ||
PICK_UP_STOP_ID | NUMBER | Yes | Pick-up stop identifier for the leg. FK to wsh_locations | |
DROP_OFF_STOP_ID | NUMBER | Yes | Drop-off stop identifier for the leg. FK to wsh_locations | |
PLN_LOADING_START_TIME | DATE | Estimated loading start date time. | ||
PLN_LOADING_END_TIME | DATE | Estimated loading end date time. | ||
PLN_UNLOADING_START_TIME | DATE | Estimated unloading start date time. | ||
PLN_UNLOADING_END_TIME | DATE | Estimated unloading end date time. | ||
ORIGIN_STOP_ID | NUMBER | Foreign key to WSH_TRIP_STOPS. First stop of a delivery. | ||
DESTINATION_STOP_ID | NUMBER | Foreign key to WSH_TRIP_STOPS. Last stop of a delivery. | ||
ALLOCATED_TRANSPORT_COST | NUMBER | Transportation cost allocated to this delivery leg | ||
ALLOCATED_FAC_SHP_HAND_COST | NUMBER | Handling cost allocated to this delivery leg | ||
ALLOCATED_FAC_REC_HAND_COST | NUMBER | Handling receiving cost allocated to this delivery leg. | ||
ALLOCATED_FAC_LOADING_COST | NUMBER | Facility loading cost allocated to this delivery leg | ||
ALLOCATED_FAC_UNLOADING_COST | NUMBER | Facility Unloading cost allocated to this delivery leg | ||
DIRECT_DISTANCE | NUMBER | Direct distance between start and end locations of leg | ||
TRAVELED_DISTANCE | NUMBER | Actual travel distance in the trip for this leg | ||
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 DELIVERY_LEG_ID
, SR_DELIVERY_ID
, DELIVERY_ID
, PLAN_ID
, TRIP_ID
, SR_DELIVERY_LEG_ID
, SEQUENCE_NUMBER
, LOADING_SEQ_NUM
, UNLOADING_SEQ_NUM
, PICK_UP_STOP_ID
, DROP_OFF_STOP_ID
, PLN_LOADING_START_TIME
, PLN_LOADING_END_TIME
, PLN_UNLOADING_START_TIME
, PLN_UNLOADING_END_TIME
, ORIGIN_STOP_ID
, DESTINATION_STOP_ID
, ALLOCATED_TRANSPORT_COST
, ALLOCATED_FAC_SHP_HAND_COST
, ALLOCATED_FAC_REC_HAND_COST
, ALLOCATED_FAC_LOADING_COST
, ALLOCATED_FAC_UNLOADING_COST
, DIRECT_DISTANCE
, TRAVELED_DISTANCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM MST.MST_DELIVERY_LEGS;
MST.MST_DELIVERY_LEGS does not reference any database object
MST.MST_DELIVERY_LEGS is referenced by following:
|
|
|