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_SHORT_CHK_TEMP

Object Details

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

The MTL_SHORT_CHK_TEMP table is used to store the temporary results of material shortage queries. Each set of results is identified by a unique SEQ_NUM number. When the query results are no longer needed, the rows for that sequence number are purged from the table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_SHORT_CHK_TEMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID INVENTORY_ITEM_ID OBJECT_TYPE OBJECT_ID OBJECT_DETAIL_ID SEQ_NUM
MTL_SHORT_CHK_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SEQ_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_NUM	NUMBER		Yes	Sequence number
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
QUANTITY_OPEN	NUMBER		Yes	Open demand for item
UOM_CODE	VARCHAR2	(3)		Unit of measure for quantity
OBJECT_TYPE	NUMBER		Yes	Type of demand
OBJECT_ID	NUMBER		Yes	Demand source's header identifier
OBJECT_DETAIL_ID	NUMBER		Yes	Demand source's line identifier (if applicable)
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT SEQ_NUM
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      QUANTITY_OPEN
,      UOM_CODE
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJECT_DETAIL_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
FROM INV.MTL_SHORT_CHK_TEMP;

Dependencies

[top of page]

INV.MTL_SHORT_CHK_TEMP does not reference any database object

INV.MTL_SHORT_CHK_TEMP is referenced by following:

INV: MTL_SHORT_CHK_TEMP#