DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_QOH_ITEM_TMP

Object Details
Object Name: MTL_QOH_ITEM_TMP
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_QOH_ITEM_TMP
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
TOTAL_QOH NUMBER

RESERVED_QOH NUMBER

AVAILABLE_QOH NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TOTAL_QOH
,      RESERVED_QOH
,      AVAILABLE_QOH
,      PRIMARY_UOM_CODE
FROM INV.MTL_QOH_ITEM_TMP;

Dependencies

[top of page]

INV.MTL_QOH_ITEM_TMP does not reference any database object

INV.MTL_QOH_ITEM_TMP is referenced by following:

SchemaAPPS
SynonymMTL_QOH_ITEM_TMP