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: GMI.GMI_MASSTRANS_CTL

Object Details

Object Name:	GMI_MASSTRANS_CTL
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.GMI_MASSTRANS_CTL
Subobject Name:
Status:	VALID

Contains record of mass move transaction created.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMI_MASSTRANS_CTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOURNAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_ID	NUMBER	(10)	Yes	Journal Id Surrogate
TRANSACTION_TYPE	VARCHAR2	(4)	Yes	Transaction Type
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code
DOC_DATE	DATE		Yes	Document Date of the transaction
REASON_CODE	VARCHAR2	(4)	Yes	Reason Code
FROM_ITEM_NO	VARCHAR2	(32)		From Item Number
TO_ITEM_NO	VARCHAR2	(32)		To Item Number
FROM_LOT_NO	VARCHAR2	(32)		From Lot Number
TO_LOT_NO	VARCHAR2	(32)		To Lot Number
FROM_SUBLOT_NO	VARCHAR2	(32)		From Sublot Number
TO_SUBLOT_NO	VARCHAR2	(32)		To Sublot Number
FROM_WHSE_CODE	VARCHAR2	(4)		From Warehouse Code
FROM_LOCATION	VARCHAR2	(16)		From Location
TO_LOCATION	VARCHAR2	(16)		To Location
FROM_GRADE	VARCHAR2	(4)		From Grade
TO_GRADE	VARCHAR2	(4)		To Grade
FROM_LOT_STATUS	VARCHAR2	(4)		From Lot Status
TO_LOT_STATUS	VARCHAR2	(4)		To Lot Status
EXPIRED_LOTS	NUMBER	(1)		Expired Lots Indicator
TARGET_WHSE_CODE	VARCHAR2	(4)		Target Warehouse Code
TARGET_LOCATION	VARCHAR2	(16)		Target Location
TARGET_GRADE	VARCHAR2	(4)		Target Grade
TARGET_STATUS	VARCHAR2	(4)		Target Status
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT JOURNAL_ID
,      TRANSACTION_TYPE
,      ORGN_CODE
,      DOC_DATE
,      REASON_CODE
,      FROM_ITEM_NO
,      TO_ITEM_NO
,      FROM_LOT_NO
,      TO_LOT_NO
,      FROM_SUBLOT_NO
,      TO_SUBLOT_NO
,      FROM_WHSE_CODE
,      FROM_LOCATION
,      TO_LOCATION
,      FROM_GRADE
,      TO_GRADE
,      FROM_LOT_STATUS
,      TO_LOT_STATUS
,      EXPIRED_LOTS
,      TARGET_WHSE_CODE
,      TARGET_LOCATION
,      TARGET_GRADE
,      TARGET_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM GMI.GMI_MASSTRANS_CTL;

Dependencies

[top of page]

GMI.GMI_MASSTRANS_CTL does not reference any database object

GMI.GMI_MASSTRANS_CTL is referenced by following:

APPS: GMI_MASSTRANS_CTL