eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MST.MST_DELIVERY_LEGS

Object Details

Object Name:	MST_DELIVERY_LEGS
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

This table mapping deliveries to their pickup and dropoff stops

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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).

Query Text

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;

Dependencies

[top of page]

MST.MST_DELIVERY_LEGS does not reference any database object

MST.MST_DELIVERY_LEGS is referenced by following:

APPS: MST_DELIVERY_LEGS