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_LTL_PARC_V

Object Details

Object Name:	MST_R_FREIGHT_LTL_PARC_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
LTL_PARC_H_S_CARR_NAME	VARCHAR2	(30)	Yes	Carrier Name
LTL_PARC_H_S_SERVICE_LEVEL	VARCHAR2	(30)		Service Level
LTL_PARC_H_S_BOL	NUMBER			Trip Number within plan
LTL_PARC_H_S_PHONE_NUM	VARCHAR2	(4000)		Phone Number
LTL_PARC_H_S_PLAN_ARR_DATE	VARCHAR2	(20)		Planned Arrival Date
LTL_PARC_H_S_EARL_ALLOW_DATE	VARCHAR2	(20)		Earliest Allowed Acceptable Date
LTL_PARC_H_S_LATE_ALLOW_DATE	VARCHAR2	(20)		Latest Allowed Acceptable Date
LTL_PARC_H_S_DEST_COMP_NAME	VARCHAR2	(80)		Destination Company Name
LTL_PARC_H_S_DEST_ADDR	VARCHAR2	(240)		Destination Address
LTL_PARC_H_S_DEST_CITY	VARCHAR2	(120)		Destination City
LTL_PARC_H_S_DEST_STATE	VARCHAR2	(120)		Destination State
LTL_PARC_H_S_DEST_ZIP	VARCHAR2	(60)		Destination Postal Code
LTL_PARC_H_S_DEST_CONT_NAME	VARCHAR2	(4000)		Contact Name
LTL_PARC_H_S_DEST_CONT_NUM	VARCHAR2	(4000)		Contact Phone Number
LTL_PARC_H_S_PIECES	NUMBER			Total number of pieces
LTL_PARC_H_S_WEIGHT	NUMBER			Gross weight
LTL_PARC_H_S_CUBE	NUMBER			Total volume
LTL_PARC_H_S_COST	NUMBER			Total Cost associated with this trip
LTL_PARC_H_S_HOST_REF_NUM	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order Reference to return line
LTL_PARC_H_S_SUPP_REF_NUM	VARCHAR2	(150)		The user visible identifier for the header, ex. Order Number
LTL_PARC_H_S_FREIGHTS	VARCHAR2	(4000)		Freight Class
LTL_PARC_CUST_CARR_NAME	VARCHAR2	(30)	Yes	Carrier Name
LTL_PARC_CUST_SERVICE_LEVEL	VARCHAR2	(30)		Service Level
LTL_PARC_CUST_BOL	NUMBER			Trip number within plan
LTL_PARC_CUST_PHONE_NUM	VARCHAR2	(4000)		Phone Number
LTL_PARC_CUST_EARL_ALLO_DATE	VARCHAR2	(20)		Earliest Allowed Accpetable Date
LTL_PARC_CUST_LATE_ALLOW_DATE	VARCHAR2	(20)		Latest Allowed Accpetable Date
LTL_PARC_CUST_PIECES	NUMBER			Total number of pieces
LTL_PARC_CUST_WEIGHT	NUMBER			Gross weight
LTL_PARC_CUST_CUBE	NUMBER			Total volume
LTL_PARC_CUST_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
,      LTL_PARC_H_S_CARR_NAME
,      LTL_PARC_H_S_SERVICE_LEVEL
,      LTL_PARC_H_S_BOL
,      LTL_PARC_H_S_PHONE_NUM
,      LTL_PARC_H_S_PLAN_ARR_DATE
,      LTL_PARC_H_S_EARL_ALLOW_DATE
,      LTL_PARC_H_S_LATE_ALLOW_DATE
,      LTL_PARC_H_S_DEST_COMP_NAME
,      LTL_PARC_H_S_DEST_ADDR
,      LTL_PARC_H_S_DEST_CITY
,      LTL_PARC_H_S_DEST_STATE
,      LTL_PARC_H_S_DEST_ZIP
,      LTL_PARC_H_S_DEST_CONT_NAME
,      LTL_PARC_H_S_DEST_CONT_NUM
,      LTL_PARC_H_S_PIECES
,      LTL_PARC_H_S_WEIGHT
,      LTL_PARC_H_S_CUBE
,      LTL_PARC_H_S_COST
,      LTL_PARC_H_S_HOST_REF_NUM
,      LTL_PARC_H_S_SUPP_REF_NUM
,      LTL_PARC_H_S_FREIGHTS
,      LTL_PARC_CUST_CARR_NAME
,      LTL_PARC_CUST_SERVICE_LEVEL
,      LTL_PARC_CUST_BOL
,      LTL_PARC_CUST_PHONE_NUM
,      LTL_PARC_CUST_EARL_ALLO_DATE
,      LTL_PARC_CUST_LATE_ALLOW_DATE
,      LTL_PARC_CUST_PIECES
,      LTL_PARC_CUST_WEIGHT
,      LTL_PARC_CUST_CUBE
,      LTL_PARC_CUST_REF_NUM
FROM APPS.MST_R_FREIGHT_LTL_PARC_V;

Dependencies

[top of page]

APPS.MST_R_FREIGHT_LTL_PARC_V references the following:

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

APPS.MST_R_FREIGHT_LTL_PARC_V is not referenced by any database object