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_HEADER_V

Object Details

Object Name:	MST_R_FREIGHT_HEADER_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
FACILITY_ID	NUMBER		Yes	Facility ID
CUST_SUPP_COMP_NAME	VARCHAR2	(4000)		Customer/Supplier Company Name
TP_DEPARTMENT_NAME	VARCHAR2	(4000)		Transportation Planning Department Name (Must be set properly in profile)
TP_CONTACT_NAME	VARCHAR2	(4000)		Transportation Planning Contact Name
TP_CONTACT_PHONE_NUM	VARCHAR2	(4000)		Transportation Planning Contact Phone Number
TP_CONTACT_EMAIL_ID	VARCHAR2	(4000)		Transportation Planning Contact EMail Address
HOST_COMP_NAME	VARCHAR2	(4000)		Host Company Name
HOST_COMP_CONTACT_NAME	VARCHAR2	(4000)		Host Company Contact Name
HOST_COMP_CONTACT_PHONE	VARCHAR2	(4000)		Host Company Contact Phone Number
HOST_COMP_CONTACT_EMAIL	VARCHAR2	(4000)		Host Copmany Contact EMail Address
FACILITY_NAME	VARCHAR2	(60)	Yes	Facility Name
PLAN_NAME	VARCHAR2	(10)	Yes	Plan Name
REPORT_DATE	DATE			Reported Date
PLAN_START_DATE	DATE		Yes	Plan Start Date
PLAN_COMPLETION_DATE	DATE		Yes	Plan Completion Date
TL_MOVEMENTS	NUMBER			Total Truck Movements ( Both Loading and Unloading )
LTL_MOVEMENTS	NUMBER			Total LTL Movements ( Both Loading and Unloading )
PARCEL_MOVEMENTS	NUMBER			Total Parcel Movements ( Both Loading and Unloading )
UNLOAD_TL_PIECES	NUMBER			Number of pieces being unloaded ( TL )
UNLOAD_LTL_PIECES	NUMBER			Number of pieces being unloaded ( LTL )
UNLOAD_PARCEL_PIECES	NUMBER			Number of pieces being unloaded ( Parcel )
UNLOAD_TL_WEIGHT	NUMBER			Gross weight being unloaded ( TL )
UNLOAD_LTL_WEIGHT	NUMBER			Gross weight being unloaded ( LTL )
UNLOAD_PARCEL_WEIGHT	NUMBER			Gross weight being unloaded ( Parcel )
UNLOAD_TL_CUBE	NUMBER			Unloaded Volume ( TL )
UNLOAD_LTL_CUBE	NUMBER			Unloaded Volume ( LTL )
UNLOAD_PARCEL_CUBE	NUMBER			Unloaded Volume ( Parcel )
LOAD_TL_PIECES	NUMBER			Number of pieces being loaded ( TL )
LOAD_LTL_PIECES	NUMBER			Number of pieces being loaded ( LTL )
LOAD_PARCEL_PIECES	NUMBER			Number of pieces being loaded ( Parcel )
LOAD_TL_WEIGHT	NUMBER			Gross weight being loaded ( TL )
LOAD_LTL_WEIGHT	NUMBER			Gross weight being loaded ( LTL )
LOAD_PARCEL_WEIGHT	NUMBER			Gross weight being loaded ( Parcel )
LOAD_TL_CUBE	NUMBER			Loaded Volume ( TL )
LOAD_LTL_CUBE	NUMBER			Loaded Volume ( LTL )
LOAD_PARCEL_CUBE	NUMBER			Loaded Volume ( Parcel )
TOTAL_PIECES	NUMBER			Total number of pieces ( Both loading and unloading )
TOTAL_WEIGHT	NUMBER			Gross Weight ( Both loading and unloading )
TOTAL_CUBE	NUMBER			Volume ( Both loading and unloading )

Query Text

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


SELECT PLAN_ID
,      FACILITY_ID
,      CUST_SUPP_COMP_NAME
,      TP_DEPARTMENT_NAME
,      TP_CONTACT_NAME
,      TP_CONTACT_PHONE_NUM
,      TP_CONTACT_EMAIL_ID
,      HOST_COMP_NAME
,      HOST_COMP_CONTACT_NAME
,      HOST_COMP_CONTACT_PHONE
,      HOST_COMP_CONTACT_EMAIL
,      FACILITY_NAME
,      PLAN_NAME
,      REPORT_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      TL_MOVEMENTS
,      LTL_MOVEMENTS
,      PARCEL_MOVEMENTS
,      UNLOAD_TL_PIECES
,      UNLOAD_LTL_PIECES
,      UNLOAD_PARCEL_PIECES
,      UNLOAD_TL_WEIGHT
,      UNLOAD_LTL_WEIGHT
,      UNLOAD_PARCEL_WEIGHT
,      UNLOAD_TL_CUBE
,      UNLOAD_LTL_CUBE
,      UNLOAD_PARCEL_CUBE
,      LOAD_TL_PIECES
,      LOAD_LTL_PIECES
,      LOAD_PARCEL_PIECES
,      LOAD_TL_WEIGHT
,      LOAD_LTL_WEIGHT
,      LOAD_PARCEL_WEIGHT
,      LOAD_TL_CUBE
,      LOAD_LTL_CUBE
,      LOAD_PARCEL_CUBE
,      TOTAL_PIECES
,      TOTAL_WEIGHT
,      TOTAL_CUBE
FROM APPS.MST_R_FREIGHT_HEADER_V;

Dependencies

[top of page]

APPS.MST_R_FREIGHT_HEADER_V references the following:

APPS: FND_PROFILE - show dependent code; FTE_LOCATION_PARAMETERS; MST_AGG_PKG - show dependent code; MST_PLANS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS; WSH_LOCATION_OWNERS

APPS.MST_R_FREIGHT_HEADER_V is not referenced by any database object