DBA Data[Home] [Help] [Dependency Information]

TABLE: MST.MST_IN_REQUESTS

Object Details
Object Name: MST_IN_REQUESTS
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


This is the entity for storing all requests, coming due to changes from UI, for engine to process


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_IN_REQUESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnIN_REQUEST_ID
MST_IN_REQUESTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnTYPE_CODE
MST_IN_REQUESTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnORIGINAL_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
IN_REQUEST_ID NUMBER
Yes Primary key
ORIGINAL_REQUEST_ID NUMBER

Previous request id for undo pupose
PLAN_ID NUMBER
Yes FK to mst_plans
TYPE_CODE VARCHAR2 (10) Yes Type of different request
TYPE_ID NUMBER
Yes Type of different request.
TRIP_ID NUMBER

FK to mst_trips
TRIP_STOP_ID NUMBER

FK to mst_trip_stops
DELIVERY_ID NUMBER

FK to mst_deliveries
DELIVERY_DETAIL_ID NUMBER

FK to mst_delivery_details
DELIVERY_LEG_ID NUMBER

FK to mst_delivery_legs
VEHICLE_TYPE_ID NUMBER

Vehicle type id passed as input parameter for request
CONTINUOUS_MOVE_ID NUMBER

FK to mst_cm_trips
CARRIER_ID NUMBER

FK to WSH_CARRIERS
CARRIER_SERVICE_ID NUMBER

Carrier service id passed as input parameter for request
SERVICE_LEVEL VARCHAR2 (30)
Service level string passed as input parameter for request
NUMBER1 NUMBER

Generic number column
NUMBER2 NUMBER

Generic number column
NUMBER3 NUMBER

Generic number column
NUMBER4 NUMBER

Generic number column
NUMBER5 NUMBER

Generic number column
NUMBER6 NUMBER

Generic number column
NUMBER7 NUMBER

Generic number column
NUMBER8 NUMBER

Generic number column
NUMBER9 NUMBER

Generic number column
NUMBER10 NUMBER

Generic number column
CHAR1 VARCHAR2 (80)
Generic varchar2 column
CHAR2 VARCHAR2 (80)
Generic varchar2 column
CHAR3 VARCHAR2 (80)
Generic varchar2 column
CHAR4 VARCHAR2 (80)
Generic varchar2 column
CHAR5 VARCHAR2 (80)
Generic varchar2 column
DATE1 DATE

Generic Date column
DATE2 DATE

Generic Date column
DATE3 DATE

Generic Date column
DATE4 DATE

Generic Date column
DATE5 DATE

Generic Date column
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
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).
Query Text

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


SELECT IN_REQUEST_ID
,      ORIGINAL_REQUEST_ID
,      PLAN_ID
,      TYPE_CODE
,      TYPE_ID
,      TRIP_ID
,      TRIP_STOP_ID
,      DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      DELIVERY_LEG_ID
,      VEHICLE_TYPE_ID
,      CONTINUOUS_MOVE_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      SERVICE_LEVEL
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_IN_REQUESTS;

Dependencies

[top of page]

MST.MST_IN_REQUESTS does not reference any database object

MST.MST_IN_REQUESTS is referenced by following:

SchemaAPPS
SynonymMST_IN_REQUESTS