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: INV.MTL_ERES_TRANSACTIONS_GTMP

Object Details

Object Name:	MTL_ERES_TRANSACTIONS_GTMP
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ERES_TRANSACTIONS_GTMP
Subobject Name:
Status:	VALID

Temporary Table Details

INV.MTL_ERES_TRANSACTIONS_GTMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
TRANSACTION_HEADER_ID	NUMBER
TRANSACTION_TEMP_ID	NUMBER
ORIGINAL_TRANSACTION_TEMP_ID	NUMBER
TRANSACTION_SOURCE	VARCHAR2	(1000)
TRANSACTION_TYPE	VARCHAR2	(30)
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
INVENTORY_ITEM_ID	NUMBER
ITEM_NUMBER	VARCHAR2	(240)
ITEM_DESCRIPTION	VARCHAR2	(240)
REVISION	VARCHAR2	(3)
SUBINVENTORY_CODE	VARCHAR2	(10)
LOCATOR	VARCHAR2	(240)
ACCOUNT_NO	VARCHAR2	(240)
ACCOUNT_ALIAS	VARCHAR2	(240)
REASON_NAME	VARCHAR2	(30)
TRANSACTION_REFERENCE	VARCHAR2	(240)
LOCATION	VARCHAR2	(60)
TRANSACTION_QUANTITY	NUMBER
TRANSACTION_UOM	VARCHAR2	(3)
SECONDARY_TRANSACTION_QUANTITY	NUMBER
SECONDARY_UOM_CODE	VARCHAR2	(3)
TRANSACTION_DATE	DATE
LOT_NUMBER	VARCHAR2	(80)
LOT_EXPIRATION_DATE	DATE

Query Text

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


SELECT TRANSACTION_HEADER_ID
,      TRANSACTION_TEMP_ID
,      ORIGINAL_TRANSACTION_TEMP_ID
,      TRANSACTION_SOURCE
,      TRANSACTION_TYPE
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      REVISION
,      SUBINVENTORY_CODE
,      LOCATOR
,      ACCOUNT_NO
,      ACCOUNT_ALIAS
,      REASON_NAME
,      TRANSACTION_REFERENCE
,      LOCATION
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      SECONDARY_TRANSACTION_QUANTITY
,      SECONDARY_UOM_CODE
,      TRANSACTION_DATE
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
FROM INV.MTL_ERES_TRANSACTIONS_GTMP;

Dependencies

[top of page]

INV.MTL_ERES_TRANSACTIONS_GTMP does not reference any database object

INV.MTL_ERES_TRANSACTIONS_GTMP is referenced by following:

APPS: MTL_ERES_TRANSACTIONS_GTMP