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

TABLE: MST.MST_OUT_REQUEST_DETAILS

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


This is the entity for storing all details of the output of the request


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_OUT_REQUEST_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOUT_REQUEST_DETAIL_ID
MST_OUT_REQUEST_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnOUT_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
OUT_REQUEST_DETAIL_ID NUMBER
Yes Primary key
OUT_REQUEST_ID NUMBER
Yes FK to mst_out_parameters
PLAN_ID NUMBER
Yes FK to mst_plans
EXCEPTION_TYPE NUMBER

Exception type code (as in mst_exception_details)
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 varchar column
CHAR2 VARCHAR2 (80)
Generic varchar column
CHAR3 VARCHAR2 (80)
Generic varchar column
CHAR4 VARCHAR2 (80)
Generic varchar column
CHAR5 VARCHAR2 (80)
Generic varchar 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).
NUMBER11 NUMBER

Generic number column
NUMBER12 NUMBER

Generic number column
DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

Query Text

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


SELECT OUT_REQUEST_DETAIL_ID
,      OUT_REQUEST_ID
,      PLAN_ID
,      EXCEPTION_TYPE
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NUMBER11
,      NUMBER12
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
FROM MST.MST_OUT_REQUEST_DETAILS;

Dependencies

[top of page]

MST.MST_OUT_REQUEST_DETAILS does not reference any database object

MST.MST_OUT_REQUEST_DETAILS is referenced by following:

SchemaAPPS
SynonymMST_OUT_REQUEST_DETAILS