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_ACT_REASSIGN_DELIVERY_V

Object Details

Object Name:	MST_ACT_REASSIGN_DELIVERY_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
PLAN_ID	NUMBER		Unique identifier for plan
TRIP_ID	NUMBER		Primary key for table
IN_REQUEST_ID	NUMBER		Primary key
TRIP_NUMBER	NUMBER		Trip number with in plan
MODE_OF_TRANSPORT	VARCHAR2	(30)	Truck, LTL, Ocean, Parcel etc
MODE_TL	VARCHAR2	(80)
TOTAL_WEIGHT	NUMBER
WEIGHT_UOM	VARCHAR2	(3)
VOLUME	NUMBER
VOLUME_UOM	VARCHAR2	(3)
TOTAL_PALLETS	NUMBER
TOTAL_PIECES	NUMBER
DISTANCE	NUMBER
DISTANCE_UOM	VARCHAR2	(3)
STOPS	NUMBER
CIRCUITY	NUMBER
TOTAL_COST	NUMBER
CURRENCY_UOM	VARCHAR2	(3)
LINE_NUMBER	NUMBER
BEFORE_AFTER	VARCHAR2	(80)
ORIGIN_LOCATION_ID	NUMBER
ORIGIN_COMPANY	VARCHAR2	(80)
ORIGIN_CITY	VARCHAR2	(120)
ORIGIN_STATE	VARCHAR2	(120)
ORIGIN_ZIP	VARCHAR2	(60)
ORIGIN_COUNTRY	VARCHAR2	(120)
DESTINATION_LOCATION_ID	NUMBER
DESTINATION_COMPANY	VARCHAR2	(80)
DESTINATION_CITY	VARCHAR2	(120)
DESTINATION_STATE	VARCHAR2	(120)
DESTINATION_ZIP	VARCHAR2	(60)
DESTINATION_COUNTRY	VARCHAR2	(120)

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      IN_REQUEST_ID
,      TRIP_NUMBER
,      MODE_OF_TRANSPORT
,      MODE_TL
,      TOTAL_WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      DISTANCE
,      DISTANCE_UOM
,      STOPS
,      CIRCUITY
,      TOTAL_COST
,      CURRENCY_UOM
,      LINE_NUMBER
,      BEFORE_AFTER
,      ORIGIN_LOCATION_ID
,      ORIGIN_COMPANY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_LOCATION_ID
,      DESTINATION_COMPANY
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
FROM APPS.MST_ACT_REASSIGN_DELIVERY_V;

Dependencies

[top of page]

APPS.MST_ACT_REASSIGN_DELIVERY_V references the following:

APPS: MST_AGG_PKG - show dependent code; MST_DELIVERY_LEGS; MST_IN_REQUESTS; MST_OUT_REQUESTS; MST_OUT_REQUEST_DETAILS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_ACT_REASSIGN_DELIVERY_V is not referenced by any database object