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_LTL_V

Object Details

Object Name:	MST_LTL_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.
TRIP_NUMBER	NUMBER			Trip number with in plan
TRIP_ID	NUMBER		Yes	FK to TRIP_ID of MST_TRIPS.
ROW_ID	ROWID	(10)		Row 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 Trip.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of Origin Facility for Trip.
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Description of Origin Facility for 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 Trip.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of Destination Facility for Trip.
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Description of Destination Facility for Trip.
DESTINATION_CITY	VARCHAR2	(120)		Destination City for Trip.
DESTINATION_STATE	VARCHAR2	(120)		Destination State for Trip.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code for Trip.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country for Trip.
DEPARTURE_DATE_TIME	VARCHAR2	(80)		Departure Date for the Trip.
DEP_DATETIME_HIDDEN	DATE			Hidden field for Departure Date for the Trip.
TIME_ZONE1	VARCHAR2	(10)		Time zone of Trip's Origin.
ARRIVAL_DATE_TIME	VARCHAR2	(80)		Arrival Date for the Trip at Destination.
ARR_DATETIME_HIDDEN	DATE			Hidden Field for Arrival Date for the Trip at Destination.
TIME_ZONE2	VARCHAR2	(10)		Time zone of Trip's Destination.
COST	NUMBER			Cost related to Trip.
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 Trip.
RELEASE_STATUS	VARCHAR2	(80)		Name for Release Status of Trip.
RELEASED	DATE			Date of Release of 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 Lock.

Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      DESCRIPTION
,      TRIP_NUMBER
,      TRIP_ID
,      ROW_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_LTL_V;

Dependencies

[top of page]

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