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_R_FREIGHT_TL_V

Object Details

Object Name:	MST_R_FREIGHT_TL_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	Plan ID
CUSTOMER_ID	NUMBER			Customer ID
SUPPLIER_ID	NUMBER			Supplier ID
FACILITY_ID	NUMBER		Yes	Facility ID
OWNER_TYPE	NUMBER			Facility Owner Type
TL_CARR_NAME	VARCHAR2	(30)	Yes	Carrier Name
TL_CARR_SERVICE_LEVEL	VARCHAR2	(30)		Service Level eg D2D, 2 day, Overnight etc
TL_CARR_PHONE_NUM	VARCHAR2	(4000)		Carrier Phone Number
TL_BOL	NUMBER			Trip Number within plan
TL_EQPT	VARCHAR2	(40)		Vehicle
TL_EARLIEST_ALLOW_ARR_DATE	VARCHAR2	(20)		Earliest Allowed Arrival Date
TL_PLANNED_ARR_DATE	VARCHAR2	(20)		Planned Arrival Date
TL_LATEST_ALLOW_ARR_DATE	VARCHAR2	(20)		Latest Allowed Arrival Date
TL_EARL_ALLOW_DEPART_DATE	VARCHAR2	(20)		Earliest Allowed Departure Date
TL_PLANNED_DEPART_DATE	VARCHAR2	(20)		Planned Departure Date
TL_LATEST_ALLOW_DEPART_DATE	VARCHAR2	(20)		Latest Allowed Departure Date
TL_UNLOAD_PIECES	NUMBER			Number of pieces being unloaded
TL_UNLOAD_WEIGHT	NUMBER			Unloaded wieght
TL_UNLOAD_CUBE	NUMBER			Unloaded volume
TL_LOAD_PIECES	NUMBER			Number of pieces being loaded
TL_LOAD_WEIGHT	NUMBER			Loaded weight
TL_LOAD_CUBE	NUMBER			Loaded volume
TL_LOAD_UNLOAD_INDICATOR	VARCHAR2	(1)		'L' -> Loading; 'U' -> Unloading
TL_HOST_COMP_ORDER_REF_NUM	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order Reference to return
TL_SUPP_CUST_ORDER_REF_NUM	VARCHAR2	(150)		The user visible identifier for the header, ex. Order Number

Query Text

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


SELECT PLAN_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      FACILITY_ID
,      OWNER_TYPE
,      TL_CARR_NAME
,      TL_CARR_SERVICE_LEVEL
,      TL_CARR_PHONE_NUM
,      TL_BOL
,      TL_EQPT
,      TL_EARLIEST_ALLOW_ARR_DATE
,      TL_PLANNED_ARR_DATE
,      TL_LATEST_ALLOW_ARR_DATE
,      TL_EARL_ALLOW_DEPART_DATE
,      TL_PLANNED_DEPART_DATE
,      TL_LATEST_ALLOW_DEPART_DATE
,      TL_UNLOAD_PIECES
,      TL_UNLOAD_WEIGHT
,      TL_UNLOAD_CUBE
,      TL_LOAD_PIECES
,      TL_LOAD_WEIGHT
,      TL_LOAD_CUBE
,      TL_LOAD_UNLOAD_INDICATOR
,      TL_HOST_COMP_ORDER_REF_NUM
,      TL_SUPP_CUST_ORDER_REF_NUM
FROM APPS.MST_R_FREIGHT_TL_V;

Dependencies

[top of page]

APPS.MST_R_FREIGHT_TL_V references the following:

APPS: FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOCATION_OWNERS

APPS.MST_R_FREIGHT_TL_V is not referenced by any database object