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_AVAILABLE_INVENTORY_TEMP

Object Details

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

Temporary Table Details

INV.MTL_AVAILABLE_INVENTORY_TEMP 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
SOURCE_LINE_ID	NUMBER
MOVE_ORDER_LINE_ID	NUMBER
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
LOCATOR_ID	NUMBER
TRANSACTION_ACTION_ID	NUMBER
TRANSACTION_TEMP_ID	NUMBER
REASON_ID	NUMBER
TRANSACTION_SOURCE_TYPE_ID	NUMBER
LOT_NUMBER	VARCHAR2	(80)
SUBINVENTORY_CODE	VARCHAR2	(10)
LOT_CREATED	DATE
LOT_EXPIRATION_DATE	DATE
GRADE_CODE	VARCHAR2	(150)
ONHAND_QTY	NUMBER
SECONDARY_ONHAND_QTY	NUMBER
TRANSACTION_QTY	NUMBER
SECONDARY_TRANSACTION_QTY	NUMBER
TRANSACTION_UOM	VARCHAR2	(3)
SECONDARY_UOM	VARCHAR2	(3)
REVISION	VARCHAR2	(3)
ORDER_BY	NUMBER
WMS_RULE_ID	NUMBER
LPN_ID	NUMBER
SERIAL_NUMBER	VARCHAR2	(80)
CONSIST_STRING	VARCHAR2	(2000)
ORDER_BY_STRING	VARCHAR2	(2000)
COST_GROUP_ID	NUMBER

Query Text

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


SELECT SOURCE_LINE_ID
,      MOVE_ORDER_LINE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LOCATOR_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TEMP_ID
,      REASON_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      LOT_CREATED
,      LOT_EXPIRATION_DATE
,      GRADE_CODE
,      ONHAND_QTY
,      SECONDARY_ONHAND_QTY
,      TRANSACTION_QTY
,      SECONDARY_TRANSACTION_QTY
,      TRANSACTION_UOM
,      SECONDARY_UOM
,      REVISION
,      ORDER_BY
,      WMS_RULE_ID
,      LPN_ID
,      SERIAL_NUMBER
,      CONSIST_STRING
,      ORDER_BY_STRING
,      COST_GROUP_ID
FROM INV.MTL_AVAILABLE_INVENTORY_TEMP;

Dependencies

[top of page]

INV.MTL_AVAILABLE_INVENTORY_TEMP does not reference any database object

INV.MTL_AVAILABLE_INVENTORY_TEMP is referenced by following:

APPS: MTL_AVAILABLE_INVENTORY_TEMP