[Home] [Help] [Dependency Information]
Object Name: | MRP_MESSAGES_TMP |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_MESSAGES_TMP |
Subobject Name: | |
Status: | VALID |
MRP_MESSAGES_TMP is a temporary table that is used to get timing
statistics for DML statements executed by stored procedures. The
column REQUEST_ID stores the request id of the concurrent request
which inserted the row. MESSAGE_NAME stores the message name that
needs to be translated using the message dictionary. START_DATE
contains the start date of the task and END_DATE stores the end date
of the task. This difference between the two gives the elapsed time
for the task.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_MESSAGES_TMP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
REQUEST_ID | NUMBER | Yes | Concurrent Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
MESSAGE_NAME | VARCHAR2 | (240) | Yes | Message name |
START_DATE | DATE | Yes | Start date of the task | |
END_DATE | DATE | Completion date of the task | ||
TOKEN1 | VARCHAR2 | (30) | Token 1 | |
TOKEN_VALUE1 | VARCHAR2 | (80) | Value of token 1 | |
TRANSLATE_TOKEN1 | NUMBER | Should token 1 be translated | ||
TOKEN2 | VARCHAR2 | (30) | Token 2 | |
TOKEN_VALUE2 | VARCHAR2 | (80) | Value of token 2 | |
TRANSLATE_TOKEN2 | NUMBER | Should token 2 be translated | ||
ROW_COUNT | NUMBER | Number of rows affected |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, MESSAGE_NAME
, START_DATE
, END_DATE
, TOKEN1
, TOKEN_VALUE1
, TRANSLATE_TOKEN1
, TOKEN2
, TOKEN_VALUE2
, TRANSLATE_TOKEN2
, ROW_COUNT
FROM MRP.MRP_MESSAGES_TMP;
MRP.MRP_MESSAGES_TMP does not reference any database object
MRP.MRP_MESSAGES_TMP is referenced by following:
|
|
|