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_SHUTTLE_ACTIVITY_V

Object Details

Object Name:	MST_R_SHUTTLE_ACTIVITY_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	Comments
REPORT_FLAVOR	VARCHAR2	(8)
PLAN_ID	NUMBER		Plan ID
FACILITY_ID	NUMBER		Facility ID
CARRIER_ID	NUMBER		Carrier ID
IN_CARRIER_NAME	VARCHAR2	(30)	Carrier Name
IN_BOL	NUMBER		Trip number within plan
IN_EQPT_TYPE	VARCHAR2	(40)	Vehicle Type
ORIG_FAC_CODE	VARCHAR2	(60)	Origin Facility Code
ORIG_FAC_NAME	VARCHAR2	(30)	Origin Facility Name
ORIG_FAC_ADDR	VARCHAR2	(240)	Origin Facility Address
ORIG_FAC_CITY	VARCHAR2	(120)	Origin Facility City
ORIG_FAC_STATE	VARCHAR2	(120)	Origin Facility State
ORIG_FAC_ZIP	VARCHAR2	(60)	Origin Facility Postal Code
ORIG_FAC_PHONE	VARCHAR2	(4000)	Origin Facility Contact Phone Number
STOP_FAC_NAME	VARCHAR2	(30)	(Intermediate) Destination Facility Name
STOP_FAC_ADDR	VARCHAR2	(240)	(Intermediate) Destination Facility Address
STOP_FAC_CITY	VARCHAR2	(120)	(Intermediate) Destination Facility City
STOP_FAC_STATE	VARCHAR2	(120)	(Intermediate) Destination Facility State
STOP_FAC_ZIP	VARCHAR2	(60)	(Intermediate) Destination Facility Postal Code
STOP_FAC_PHONE	VARCHAR2	(4000)	(Intermediate) Destination Facility Contact Phone Number
PLAN_DEPART_DATE	VARCHAR2	(20)	Planned Departure Date/Time
PLAN_ARRIV_DATE	VARCHAR2	(20)	Planned Arrival Date/Time
TOTAL_COST	NUMBER		Total Cost
TOTAL_DISTANCE	NUMBER		Total Distance
TOTAL_PIECES	NUMBER		Total number of pieces
TOTAL_WEIGHT	NUMBER		Gross weight
TOTAL_CUBE	NUMBER		Total cubic volume
CARGO_SEQ_NUM	CHAR	(0)	Sequence Number
CARGO_COMMENT	CHAR	(0)	Comment Field
CARGO_PIECES	CHAR	(0)	Total number of pieces in the delivery
CARGO_WEIGHT	CHAR	(0)	Gross delivery weight
CARGO_CUBE	CHAR	(0)	Total delivery cubic volume
OUT_BOL	NUMBER		Outbound Trip Numberr
OUT_PLAN_DEPART_DATE	VARCHAR2	(20)	Planned Departure Date/Time from Consolidation Facility
OUT_DEPART_DATE_SORT	DATE		Planned Departure Date/Time from Consolidation Facility (Not translated - For sorting)
OUT_PIECES	NUMBER		Total number of pieces
OUT_WEIGHT	NUMBER		Gross weight
OUT_CUBE	NUMBER		Total cubic volume
DEST_LOC_CODE	VARCHAR2	(60)	Destination Location Code
POOL_LOC_CODE	VARCHAR2	(92)	Pool Location Code for pool orders
HOST_COMP_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 REPORT_FLAVOR
,      PLAN_ID
,      FACILITY_ID
,      CARRIER_ID
,      IN_CARRIER_NAME
,      IN_BOL
,      IN_EQPT_TYPE
,      ORIG_FAC_CODE
,      ORIG_FAC_NAME
,      ORIG_FAC_ADDR
,      ORIG_FAC_CITY
,      ORIG_FAC_STATE
,      ORIG_FAC_ZIP
,      ORIG_FAC_PHONE
,      STOP_FAC_NAME
,      STOP_FAC_ADDR
,      STOP_FAC_CITY
,      STOP_FAC_STATE
,      STOP_FAC_ZIP
,      STOP_FAC_PHONE
,      PLAN_DEPART_DATE
,      PLAN_ARRIV_DATE
,      TOTAL_COST
,      TOTAL_DISTANCE
,      TOTAL_PIECES
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      CARGO_SEQ_NUM
,      CARGO_COMMENT
,      CARGO_PIECES
,      CARGO_WEIGHT
,      CARGO_CUBE
,      OUT_BOL
,      OUT_PLAN_DEPART_DATE
,      OUT_DEPART_DATE_SORT
,      OUT_PIECES
,      OUT_WEIGHT
,      OUT_CUBE
,      DEST_LOC_CODE
,      POOL_LOC_CODE
,      HOST_COMP_REF_NUM
FROM APPS.MST_R_SHUTTLE_ACTIVITY_V;

Dependencies

[top of page]

APPS.MST_R_SHUTTLE_ACTIVITY_V references the following:

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

APPS.MST_R_SHUTTLE_ACTIVITY_V is not referenced by any database object