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_PARCELS_V

Object Details

Object Name:	MST_PARCELS_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
PLAN_NAME	VARCHAR2	(10)	Yes	Plan Name.
DESCRIPTION	VARCHAR2	(50)		Plan Description.
ROW_ID	ROWID	(10)		Row id from MST_TRIPS.
TRIP_NUMBER	NUMBER			Parcel Trip Number.
TRIP_ID	NUMBER		Yes	FK to TRIP_ID of MST_TRIPS.
CARRIER_ID	NUMBER			ID of Carrier related to Trip.
CARRIER	VARCHAR2	(30)	Yes	Name of Carrier related to Trip.
SERVICE	VARCHAR2	(30)		ID of Carrier Service related to Trip.
SERVICE_DESC	VARCHAR2	(80)		Name of Carrier Service related to Trip.
ORIGIN_COMPANY	VARCHAR2	(80)		Company name of Trip Origin.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of Origin Facility for the Trip.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of Origin Facility for the Trip.
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Description of Origin Facility for the Trip.
ORIGIN_CITY	VARCHAR2	(120)		Origin City for the Trip.
ORIGIN_STATE	VARCHAR2	(120)		Origin State for the Trip.
ORIGIN_ZIP	VARCHAR2	(60)		Origin Postal Code for the Trip.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Country for the Trip.
DESTINATION_COMPANY	VARCHAR2	(80)		Company Name of Trip Destination.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility for the Trip.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of Destination Facility for the Trip.
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Description of Destination Facility for the Trip.
DESTINATION_CITY	VARCHAR2	(120)		Destination City for the Trip.
DESTINATION_STATE	VARCHAR2	(120)		Destination State for the Trip.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code for the Trip.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country for the Trip.
DEPARTURE_DATE_TIME	VARCHAR2	(80)		Trip Departure date
DEP_DATETIME_HIDDEN	DATE			Hidden field for Trip Departure date
TIME_ZONE1	VARCHAR2	(10)		Time zone of Trip Origin.
ARRIVAL_DATE_TIME	VARCHAR2	(80)		Trip Arrival date at Destination.
ARR_DATETIME_HIDDEN	DATE			Hidden field for Trip Arrival date at Destination.
TIME_ZONE2	VARCHAR2	(10)		Time zone of Trip Destination.
COST	NUMBER			Trip Cost
CURRENCY_UOM	VARCHAR2	(3)		Unit of Measure for Cost.
WEIGHT	NUMBER			Weight in the Trip.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
CUBE	NUMBER			Cube in the Trip.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.
PALLETS	NUMBER			Pallets in the Trip.
PIECES	NUMBER			Pieces in the Trip.
ORDERS	NUMBER			Orders in the Trip.
FIRM_STATUS	NUMBER		Yes	Trip Status.
RELEASE_STATUS_CODE	NUMBER			Code for Release Status of the Trip.
RELEASE_STATUS	VARCHAR2	(80)		Code for Release Status of the Trip.
RELEASED	DATE			Date of Release for the trip.
RELEASED_CH	VARCHAR2	(4000)
RELEASE	NUMBER			Flag to indicate Trip release.
CHANGED_BY_USER	NUMBER			Flag to indicate User edits.
LOCKED_FOR_IMPACT	NUMBER			Flag to indicate Explicit Lock.

Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      DESCRIPTION
,      ROW_ID
,      TRIP_NUMBER
,      TRIP_ID
,      CARRIER_ID
,      CARRIER
,      SERVICE
,      SERVICE_DESC
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      DEPARTURE_DATE_TIME
,      DEP_DATETIME_HIDDEN
,      TIME_ZONE1
,      ARRIVAL_DATE_TIME
,      ARR_DATETIME_HIDDEN
,      TIME_ZONE2
,      COST
,      CURRENCY_UOM
,      WEIGHT
,      WEIGHT_UOM
,      CUBE
,      VOLUME_UOM
,      PALLETS
,      PIECES
,      ORDERS
,      FIRM_STATUS
,      RELEASE_STATUS_CODE
,      RELEASE_STATUS
,      RELEASED
,      RELEASED_CH
,      RELEASE
,      CHANGED_BY_USER
,      LOCKED_FOR_IMPACT
FROM APPS.MST_PARCELS_V;

Dependencies

[top of page]

APPS.MST_PARCELS_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_CARRIERS; WSH_LOCATIONS

APPS.MST_PARCELS_V is not referenced by any database object