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_LEG_DELIVERIES_V

Object Details

Object Name:	MST_LEG_DELIVERIES_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	FK to PLAN_ID of MST_PLANS
DELIVERY_ID	NUMBER		Yes	ID of Delivery related to Trip Leg.
PICKUP_LOCATION_ID	NUMBER		Yes	Initial pick-up location of delivery. Foreign key to wsh_locations.
DROPOFF_LOCATION_ID	NUMBER		Yes	Final drop-off location of delivery. Foreign key to wsh_locations.
STOP_ID1	NUMBER		Yes	FK to STOP_ID of MST_TRIP_STOPS
STOP_ID2	NUMBER		Yes	FK to STOP_ID of MST_TRIP_STOPS
PICK_UP_STOP_ID	NUMBER		Yes	Pick-up stop identifier for the leg. FK to STOP_ID of MST_TRIP_STOPS
DROP_OFF_STOP_ID	NUMBER		Yes	Drop-off stop identifier for the leg. FK to STOP_ID of MST_TRIP_STOPS
DELIVERY_NUMBER	NUMBER			TP Delivery Number
ORIGIN_COMPANY	VARCHAR2	(80)		Company name for Origin Facility of Delivery.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of Origin Facility of Delivery.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of Origin Facility of Delivery.
ORIGIN_DESCRIPTION	VARCHAR2	(250)		Description of Origin Facility of Delivery.
ORIGIN_CITY	VARCHAR2	(120)		Origin City of Delivery.
ORIGIN_STATE	VARCHAR2	(120)		Origin State of Delivery.
ORIGIN_ZIP	VARCHAR2	(60)		Origin Postal Code of Delivery.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Countr of Delivery.
DESTINATION_COMPANY	VARCHAR2	(80)		Company name for Destination Facility of Delivery.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility of Delivery.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of Destination Facility of Delivery.
DESTINATION_DESCRIPTION	VARCHAR2	(250)		Description of Destination Facility of Delivery.
DESTINATION_CITY	VARCHAR2	(120)		Destination City of Delivery.
DESTINATION_STATE	VARCHAR2	(120)		Destination State of Delivery.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code of Delivery.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country of Delivery.
SHIP_DATE	VARCHAR2	(80)		Delivery Ship date.
DELIVER_DATE	VARCHAR2	(80)		Delivery date of Delivery.
SHIP_DATE_HIDDEN	DATE			Hidden Field Ship Date.
DELIVER_DATE_HIDDEN	DATE			Hidden Field for Delivery date.
WEIGHT	NUMBER			Delivery Weight.
CUBE	NUMBER			Cube in Delivery
PALLETS	NUMBER			Pallets in Delivery
PIECES	NUMBER			Pieces in Delivery
ORDERS	NUMBER			Orders in Delivery
ALLOCATED_COST	NUMBER			Cost allocated to delivery.
DIRECT_COST	NUMBER			Delivery Cost if Shipped independently.
CURRENCY_UOM	VARCHAR2	(3)		Unit of Measure for Cost.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.
FIRM_STATUS	VARCHAR2	(80)		Delivery Status.

Query Text

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


SELECT PLAN_ID
,      DELIVERY_ID
,      PICKUP_LOCATION_ID
,      DROPOFF_LOCATION_ID
,      STOP_ID1
,      STOP_ID2
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      DELIVERY_NUMBER
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_DESCRIPTION
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_DESCRIPTION
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      SHIP_DATE
,      DELIVER_DATE
,      SHIP_DATE_HIDDEN
,      DELIVER_DATE_HIDDEN
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      ALLOCATED_COST
,      DIRECT_COST
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
,      FIRM_STATUS
FROM APPS.MST_LEG_DELIVERIES_V;

Dependencies

[top of page]

APPS.MST_LEG_DELIVERIES_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_AGG_PKG - show dependent code; MST_DELIVERIES; MST_DELIVERY_LEGS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS

APPS.MST_LEG_DELIVERIES_V is not referenced by any database object