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]

VIEW: APPS.MST_DD_DELIVERY_LEGS_V

Object Details

Object Name:	MST_DD_DELIVERY_LEGS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Identifier of plan to which current record belong
DELIVERY_ID	NUMBER		Yes	Delivery identifier for this delivery leg
SEQUENCE_NUMBER	NUMBER		Yes	Sequence number of current leg for this delivery
CARRIER_ID	NUMBER			Vendor providing (trip) service
CARRIER_NAME	VARCHAR2	(30)	Yes	Name of vendor providing this service
STOP_LOCATION_ID1	NUMBER		Yes	location_id (wsh_locations.wsh_location_id) of previous stop of current delivery leg
STOP_LOCATION_ID2	NUMBER		Yes	location_id (wsh_locations.wsh_location_id) of next stop of current delivery leg
TRIP_ID	NUMBER		Yes	trip_id (FK to mst_trips) of current trip on which current delivery is boarded
TRIP_NUMBER	NUMBER			trip_number (mst_trips.trip_number) of current trip on which current delivery is boarded
MODE_OF_TRANSPORT	VARCHAR2	(30)		Untranslated mode of transport of current trip on which current delivery is boarded
MODE_OF_TRANSPORT_TL	VARCHAR2	(80)	Yes	Translated mode of transport of current trip on which current delivery is boarded
SERVICE_LEVEL	VARCHAR2	(30)		Un translated service level of current trip on which current delivery is boarded
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Translated service level of current trip on which current delivery is boarded
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Description of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_CITY	VARCHAR2	(120)		City of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_STATE	VARCHAR2	(120)		State of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_ZIP	VARCHAR2	(60)		Zip of facility at which current delivery was loaded for its this delivery leg.
ORIGIN_COUNTRY	VARCHAR2	(120)		Country of facility at which current delivery was loaded for its this delivery leg.
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Description of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_CITY	VARCHAR2	(120)		City of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_STATE	VARCHAR2	(120)		State of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_ZIP	VARCHAR2	(60)		Zip of facility at which current delivery was unloaded for its this delivery leg.
DESTINATION_COUNTRY	VARCHAR2	(120)		Country of facility at which current delivery was unloaded for its this delivery leg.
PLANNED_DEPARTURE_DATE	VARCHAR2	(40)		Local planned departure date of trip from the facility at which current delivery was loaded for its this delivery leg concatenated with local timezone. Zone of facility is considered as local timezone.
PLANNED_ARRIVAL_DATE	VARCHAR2	(40)		Local planned arrival date of trip at the facility at which current delivery was unloaded for its this delivery leg concatenated with local timezone. Zone of facility is considered as local timezone.
PLANNED_DEPARTURE_DATE_DT	DATE			Planned departure date (in server timezone) of trip from the facility at which current delivery was loaded for its this delivery leg.
PLANNED_ARRIVAL_DATE_DT	DATE			Planned arrival date (in server timezone) of trip from the facility at which current delivery was unloaded for its this delivery leg.
TOTAL_LEG_COST	NUMBER			Total cost of this leg of delivery
LEG_COST_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters

Query Text

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


SELECT PLAN_ID
,      DELIVERY_ID
,      SEQUENCE_NUMBER
,      CARRIER_ID
,      CARRIER_NAME
,      STOP_LOCATION_ID1
,      STOP_LOCATION_ID2
,      TRIP_ID
,      TRIP_NUMBER
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_TL
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      PLANNED_DEPARTURE_DATE
,      PLANNED_ARRIVAL_DATE
,      PLANNED_DEPARTURE_DATE_DT
,      PLANNED_ARRIVAL_DATE_DT
,      TOTAL_LEG_COST
,      LEG_COST_UOM
FROM APPS.MST_DD_DELIVERY_LEGS_V;

Dependencies

[top of page]

APPS.MST_DD_DELIVERY_LEGS_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_DD_DELIVERY_LEGS_V is not referenced by any database object