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_POOL_ACTIVITY_CONSOL_V

Object Details

Object Name:	MST_R_POOL_ACTIVITY_CONSOL_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
OWNER_TYPE	NUMBER			Owner Type
FACILITY_ID	NUMBER		Yes	Facility ID
CARRIER_ID	NUMBER			Outbound Carrier ID
OUT_CARR_NAME	VARCHAR2	(30)	Yes	Outbound Carrier Name
OUT_CARR_SERV	VARCHAR2	(30)		Outbound Carrier Service Name
OUT_CARR_PHONE	VARCHAR2	(4000)		Outbound Carrier Phone Number
OUT_CARR_BOL	NUMBER			Outbound Trip Number within plan
OUT_CARR_PLAN_DEP_DATE	VARCHAR2	(20)		Outbound Trip Departure Date/Time
OUT_DEP_DATE_SORT	DATE			Outbound Trip Departure Date/Time (Not translated- For Sorting)
OUT_CARR_DEST_NAME	VARCHAR2	(4000)		Outbound Carrier Destination Name
OUT_CARR_DEST_CODE	VARCHAR2	(60)		Outbound Carrier Destination Location Code
OUT_CARR_DEST_PHONE	VARCHAR2	(4000)		Outbound Carrier Destination Phone Number
OUT_CARR_DEST_ADDR	VARCHAR2	(240)		Outbound Carrier Destination Address
OUT_CARR_DEST_CITY	VARCHAR2	(120)		Outbound Carrier Destination City
OUT_CARR_DEST_STATE	VARCHAR2	(120)		Outbound Carrier Destination State
OUT_CARR_DEST_ZIP	VARCHAR2	(60)		Outbound Carrier Destination Postal Code
OUT_CARR_PIECES	NUMBER			Total number of pieces in outbound trip
OUT_CARR_WEIGHT	NUMBER			Gross outbound trip weight
OUT_CARR_CUBE	NUMBER			Total cubic volume in outbound trip
IN_CARR_NAME	VARCHAR2	(30)	Yes	Inbound Carrier Name
IN_CARR_SERV	VARCHAR2	(30)		Inbound Carrier Service Name
IN_CARR_PHONE	VARCHAR2	(4000)		Inbound Carrier Phone Number
IN_CARR_BOL	NUMBER			Inbound Trip Number within plan
IN_CARR_ORIG_NAME	VARCHAR2	(4000)		Inbound Carrier Origin Name
IN_CARR_ORIG_CODE	VARCHAR2	(60)		Inbound Carrier Origin Location Code
IN_CARR_ORIG_PHONE	VARCHAR2	(4000)		Inbound Carrier Origin Phone Number
IN_CARR_ORIG_ADDR	VARCHAR2	(240)		Inbound Carrier Origin Address
IN_CARR_ORIG_CITY	VARCHAR2	(120)		Inbound Carrier Origin City
IN_CARR_ORIG_STATE	VARCHAR2	(120)		Inbound Carrier Origin State
IN_CARR_ORIG_ZIP	VARCHAR2	(60)		Inbound Carrier Origin Postal Code
IN_CARR_PLAN_PICK_DATE	VARCHAR2	(20)		Planned Delivery Date/Time
IN_PICK_DATE_SORT	DATE			Planned Delivery Date/Time (not translated - For Sorting)
IN_CARR_PIECES	NUMBER			Total number of pieces in inbound trip
IN_CARR_WEIGHT	NUMBER			Gross inbound trip weight
IN_CARR_CUBE	NUMBER			Total cubic volume in inbound trip
IN_CARR_INTERN_REF	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
IN_CARR_EXTERN_REF	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
,      OWNER_TYPE
,      FACILITY_ID
,      CARRIER_ID
,      OUT_CARR_NAME
,      OUT_CARR_SERV
,      OUT_CARR_PHONE
,      OUT_CARR_BOL
,      OUT_CARR_PLAN_DEP_DATE
,      OUT_DEP_DATE_SORT
,      OUT_CARR_DEST_NAME
,      OUT_CARR_DEST_CODE
,      OUT_CARR_DEST_PHONE
,      OUT_CARR_DEST_ADDR
,      OUT_CARR_DEST_CITY
,      OUT_CARR_DEST_STATE
,      OUT_CARR_DEST_ZIP
,      OUT_CARR_PIECES
,      OUT_CARR_WEIGHT
,      OUT_CARR_CUBE
,      IN_CARR_NAME
,      IN_CARR_SERV
,      IN_CARR_PHONE
,      IN_CARR_BOL
,      IN_CARR_ORIG_NAME
,      IN_CARR_ORIG_CODE
,      IN_CARR_ORIG_PHONE
,      IN_CARR_ORIG_ADDR
,      IN_CARR_ORIG_CITY
,      IN_CARR_ORIG_STATE
,      IN_CARR_ORIG_ZIP
,      IN_CARR_PLAN_PICK_DATE
,      IN_PICK_DATE_SORT
,      IN_CARR_PIECES
,      IN_CARR_WEIGHT
,      IN_CARR_CUBE
,      IN_CARR_INTERN_REF
,      IN_CARR_EXTERN_REF
FROM APPS.MST_R_POOL_ACTIVITY_CONSOL_V;

Dependencies

[top of page]

APPS.MST_R_POOL_ACTIVITY_CONSOL_V references the following:

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

APPS.MST_R_POOL_ACTIVITY_CONSOL_V is not referenced by any database object