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]

TABLE: MST.MST_OUT_REQUESTS

Object Details

Object Name:	MST_OUT_REQUESTS
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

This is the entity for storing all output requests

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MST_OUT_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OUT_REQUEST_ID
MST_OUT_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID IN_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OUT_REQUEST_ID	NUMBER		Yes	Primary key
IN_REQUEST_ID	NUMBER		Yes	FK to mst_in_requests
PLAN_ID	NUMBER		Yes	FK to mst_plans
TRIP_ID	NUMBER			FK to mst_trips
CARRIER_ID	NUMBER			FK to wsh_carriers
CARRIER_SERVICE_ID	NUMBER			Carrier service id returned by request
SERVICE_LEVEL	VARCHAR2	(30)		Service level string returned by request
TRIP_STOP_ID	NUMBER			FK to mst_trip_stops
DELIVERY_ID	NUMBER			FK to mst_deliveries
DELIVERY_LEG_ID	NUMBER			FK to mst_delivery_legs
DELIVERY_DETAIL_ID	NUMBER			FK to mst_delivery_details
CONTINUOUS_MOVE_ID	NUMBER			FK to mst_cm_trips
NUMBER1	NUMBER			Used to return numberic value as result of executing request
NUMBER2	NUMBER			Used to return numberic value as result of executing request
NUMBER3	NUMBER			Used to return numberic value as result of executing request
NUMBER4	NUMBER			Used to return numberic value as result of executing request
NUMBER5	NUMBER			Used to return numberic value as result of executing request
NUMBER6	NUMBER			Used to return numberic value as result of executing request
NUMBER7	NUMBER			Used to return numberic value as result of executing request
NUMBER8	NUMBER			Used to return numberic value as result of executing request
NUMBER9	NUMBER			Used to return numberic value as result of executing request
NUMBER10	NUMBER			Used to return numberic value as result of executing request
CHAR1	VARCHAR2	(80)		Used to return string value as result of executing request
CHAR2	VARCHAR2	(80)		Used to return string value as result of executing request
CHAR3	VARCHAR2	(80)		Used to return string value as result of executing request
CHAR4	VARCHAR2	(80)		Used to return string value as result of executing request
CHAR5	VARCHAR2	(80)		Used to return string value as result of executing request
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
VEHICLE_TYPE_ID	NUMBER			Vehicle type id returned by request
DATE1	DATE			Used to return date value as result of executing request
DATE2	DATE			Used to return date value as result of executing request
DATE3	DATE			Used to return date value as result of executing request
DATE4	DATE			Used to return date value as result of executing request
DATE5	DATE			Used to return date value as result of executing request
NUMBER11	NUMBER
NUMBER12	NUMBER
NUMBER13	NUMBER
NUMBER14	NUMBER
NUMBER15	NUMBER

Query Text

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


SELECT OUT_REQUEST_ID
,      IN_REQUEST_ID
,      PLAN_ID
,      TRIP_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      SERVICE_LEVEL
,      TRIP_STOP_ID
,      DELIVERY_ID
,      DELIVERY_LEG_ID
,      DELIVERY_DETAIL_ID
,      CONTINUOUS_MOVE_ID
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VEHICLE_TYPE_ID
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
FROM MST.MST_OUT_REQUESTS;

Dependencies

[top of page]

MST.MST_OUT_REQUESTS does not reference any database object

MST.MST_OUT_REQUESTS is referenced by following:

APPS: MST_OUT_REQUESTS