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_ALLOCATIONS_GTMP

Object Details

Object Name:	MTL_ALLOCATIONS_GTMP
Object Type:	TABLE
Owner:	INV
Subobject Name:
Status:	VALID

Temporary Table Details

INV.MTL_ALLOCATIONS_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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
TRANSACTION_TEMP_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_NUMBER	VARCHAR2	(800)
GROUP_NUMBER	NUMBER
CONTENT_LPN	VARCHAR2	(30)
INNER_LPN	VARCHAR2	(30)
INNER_LPN_EXISTS	VARCHAR2	(1)
LOOSE_QTY_EXISTS	VARCHAR2	(1)
TRANSFER_LPN_ID	NUMBER
REVISION	VARCHAR2	(3)
LOT_ALLOC	VARCHAR2	(1)
SERIAL_ALLOC	VARCHAR2	(1)
LOT_NUMBER	VARCHAR2	(80)
SERIAL_NUMBER	VARCHAR2	(30)
TRANSACTION_QUANTITY	NUMBER
PRIMARY_QUANTITY	NUMBER
SECONDARY_QUANTITY	NUMBER
SUGGESTED_QUANTITY	NUMBER
SUGGESTED_UOM_CODE	VARCHAR2	(3)
PRIMARY_UOM_CODE	VARCHAR2	(3)
UOM_LOOKUP_CODE	NUMBER
CHILD_TRANSACTION_TEMP_ID	NUMBER
MOVE_ORDER_HEADER_ID	NUMBER
SEARCH_SEQUENCE	NUMBER

Query Text

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


SELECT TRANSACTION_TEMP_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      GROUP_NUMBER
,      CONTENT_LPN
,      INNER_LPN
,      INNER_LPN_EXISTS
,      LOOSE_QTY_EXISTS
,      TRANSFER_LPN_ID
,      REVISION
,      LOT_ALLOC
,      SERIAL_ALLOC
,      LOT_NUMBER
,      SERIAL_NUMBER
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      SECONDARY_QUANTITY
,      SUGGESTED_QUANTITY
,      SUGGESTED_UOM_CODE
,      PRIMARY_UOM_CODE
,      UOM_LOOKUP_CODE
,      CHILD_TRANSACTION_TEMP_ID
,      MOVE_ORDER_HEADER_ID
,      SEARCH_SEQUENCE
FROM INV.MTL_ALLOCATIONS_GTMP;

Dependencies

[top of page]

INV.MTL_ALLOCATIONS_GTMP does not reference any database object

INV.MTL_ALLOCATIONS_GTMP is referenced by following:

APPS: MTL_ALLOCATIONS_GTMP