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: GMP.MR_MESG_TBL

Object Details

Object Name:	MR_MESG_TBL
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.MR_MESG_TBL
Subobject Name:
Status:	VALID

Error message log. Stores the list of error messages generated during
the P/MRP run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MR_MESG_TBL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MRP_ID MESSAGE_LINE_NO
MR_MESG_TBLI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MESSAGE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
MRP_ID	NUMBER	(10)	Yes	Surrogate key for the MRP run.
MESSAGE_LINE_NO	NUMBER	(10)	Yes	Unique number generated for each row written into the table for this MRP Run.
MESSAGE_CODE	VARCHAR2	(32)	Yes	Code for the error message. The description of this code gives details of the error
SHOPDAY_NO	VARCHAR2	(8)		Number identifying the shop day referred to (if any) in the error message.
CALENDAR_ID	NUMBER	(10)		Surrogate key identifying the calendar referred to (if any) in the error
ITEM_ID1	NUMBER	(10)		Surrogate key identifying the first item referred to in the message
ITEM_ID2	NUMBER	(10)		Surrogate key identifying the second item referred to in the message
WHSE_CODE1	VARCHAR2	(4)		First warehouse referred to in the message text.
WHSE_CODE2	VARCHAR2	(4)		Second warehouse referred to in the message.
REQUIRED_QTY	NUMBER			The required quantity referred to in the error message.example - Such an error message would generated for cases where MRP could not plan.
START_DATE	DATE		Yes	Start date referred to in the error message.
FORMULA_ID	NUMBER	(10)		Surrogate key identifying the formula referred to in the message text.
END_DATE	DATE		Yes	End date referred to in the error message.
ORGN_CODE	VARCHAR2	(4)		Organization code referred to in the error message.
LEADTIME	NUMBER			Lead time referred to in the error message.
ACTION_NO	NUMBER	(10)		Action number - if related to an action message
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column

Query Text

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


SELECT MRP_ID
,      MESSAGE_LINE_NO
,      MESSAGE_CODE
,      SHOPDAY_NO
,      CALENDAR_ID
,      ITEM_ID1
,      ITEM_ID2
,      WHSE_CODE1
,      WHSE_CODE2
,      REQUIRED_QTY
,      START_DATE
,      FORMULA_ID
,      END_DATE
,      ORGN_CODE
,      LEADTIME
,      ACTION_NO
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GMP.MR_MESG_TBL;

Dependencies

[top of page]

GMP.MR_MESG_TBL does not reference any database object

GMP.MR_MESG_TBL is referenced by following:

APPS: MR_MESG_TBL