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_TRAN_TBL

Object Details

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

MRP transaction table. Scheduled transactions, MRP transactions, and adjusted forecast.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MR_TRAN_TBLI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MRP_ID ITEM_ID WHSE_CODE TRANS_DATE LINE_NO
MR_TRAN_TBL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MRP_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
MRP_ID	NUMBER	(10)	Yes	Key identifying the MRP run whose transaction are written.
LINE_NO	NUMBER	(10)	Yes	Unique number assigned to each row in this table for this run.
ACTION_NO	NUMBER	(10)		Assigned values only for MRP generated transactions.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key identifying the item for which there is a transaction.
CO_CODE	VARCHAR2	(4)		Company code for the transaction.
ORGN_CODE	VARCHAR2	(4)		Organization code for the transaction.
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse code on the transaction.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
DOC_TYPE	VARCHAR2	(4)	Yes	Code identifying the type of document which created the transaction.
TRANS_DATE	DATE		Yes	Transaction date on which transaction will occur.
TRANS_QTY	NUMBER		Yes	Transaction quantity.
TRANS_UM	VARCHAR2	(4)		Primary UOM of an item.
DOC_ID	NUMBER	(10)		Surrogate key identifying the document which created the transaction.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		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
,      LINE_NO
,      ACTION_NO
,      ITEM_ID
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      CREATED_BY
,      DOC_TYPE
,      TRANS_DATE
,      TRANS_QTY
,      TRANS_UM
,      DOC_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GMP.MR_TRAN_TBL;

Dependencies

[top of page]

GMP.MR_TRAN_TBL does not reference any database object

GMP.MR_TRAN_TBL is referenced by following:

GMP: MR_TRAN_TBL#