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_STOP_DELIVERIES_V

Object Details

Object Name:	MST_STOP_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 stop.
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.
PICK_UP_STOP_ID	NUMBER		Yes	Pick-up stop identifier for the leg.
DROP_OFF_STOP_ID	NUMBER		Yes	Drop-off stop identifier for the leg.
TRIP_ID	NUMBER		Yes	Trip id. Foreign key to MST_TRIPS.
STOP_ID	NUMBER		Yes	ID of Stop. FK to STOP_ID of MST_TRIP_STOPS
DELIVERY_NUMBER	NUMBER			TP Delivery Number
ORIGIN_COMPANY	VARCHAR2	(80)		Name of Company from where delivery is Originated.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of the Facility for Delivery Origin.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of the Facility for Delivery Origin.
ORIGIN_DESCRIPTION	VARCHAR2	(250)		Description of the Facility for Delivery Origin.
ORIGIN_CITY	VARCHAR2	(120)		Delivery Origin City.
ORIGIN_STATE	VARCHAR2	(120)		Delivery Origin State.
ORIGIN_ZIP	VARCHAR2	(60)		Delivery Origin Postal Code.
ORIGIN_COUNTRY	VARCHAR2	(120)		Delivery Origin Country.
DESTINATION_COMPANY	VARCHAR2	(80)		Name of Company, which is delivery's Destination.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of the Facility for Delivery Destination.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of the Facility for Delivery Destination.
DESTINATION_DESCRIPTION	VARCHAR2	(250)		Description of the Facility for Delivery Destination.
DESTINATION_CITY	VARCHAR2	(120)		Delivery Destination City.
DESTINATION_STATE	VARCHAR2	(120)		Delivery Destination State.
DESTINATION_ZIP	VARCHAR2	(60)		Delivery Destination Postal Code.
DESTINATION_COUNTRY	VARCHAR2	(120)		Delivery Destination Country.
LOAD_UNLOAD_FLAG	VARCHAR2	(10)		Flag to indicate Load/Unload.
EARLIEST_ALLOWED_DATE_TIME	VARCHAR2	(80)		Earliest date for Pickup/Dropoff of the delivery.
LATEST_ALLOWED_DATE_TIME	VARCHAR2	(80)		Latest date for Pickup/Dropoff of the delivery.
EARLY_ALLOWED_DATE_HIDDEN	DATE			Hidden field for Earliest date for Pickup/Dropoff of the delivery.
LATEST_ALLOWED_DATE_HIDDEN	DATE			Hidden field for Latest date for Pickup/Dropoff of the delivery.
WEIGHT	NUMBER			Delivery Weight.
CUBE	NUMBER			Delivery Cube.
PALLETS	NUMBER			Pallets in Delivery.
PIECES	NUMBER			Pieces in Delivery.
ORDERS	NUMBER			Orders included in Delivery.
ALLOCATED_COST	NUMBER			Allocated cost of Delivery.
DIRECT_COST	NUMBER			Direct cost of Delivery.
FIRM_STATUS	VARCHAR2	(80)		Status of Delivery.
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.

Query Text

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


SELECT PLAN_ID
,      DELIVERY_ID
,      PICKUP_LOCATION_ID
,      DROPOFF_LOCATION_ID
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      TRIP_ID
,      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
,      LOAD_UNLOAD_FLAG
,      EARLIEST_ALLOWED_DATE_TIME
,      LATEST_ALLOWED_DATE_TIME
,      EARLY_ALLOWED_DATE_HIDDEN
,      LATEST_ALLOWED_DATE_HIDDEN
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      ALLOCATED_COST
,      DIRECT_COST
,      FIRM_STATUS
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_STOP_DELIVERIES_V;

Dependencies

[top of page]

APPS.MST_STOP_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_STOP_DELIVERIES_V is not referenced by any database object