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

TABLE: INV.MTL_SUMMARY_TEMP

Object Details
Object Name: MTL_SUMMARY_TEMP
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_SUMMARY_TEMP
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
SESSION_ID NUMBER

SESSION_ID of the user session
SUMMARY_TYPE VARCHAR2 (40)
Identifier for type of query
SUBINVENTORY VARCHAR2 (10)
Subinventory name
LOCATOR_ID NUMBER

Locator id for stock locators
TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 (30)
Transaction source type identifier
TRANSACTION_TYPE_NAME VARCHAR2 (80)
Transaction type identifier
TRANSACTION_ACTION_NAME VARCHAR2 (80)
Transaction action identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
NET_QTY NUMBER

Net quantity of the transactions
NET_VAL NUMBER

Net value of the transactions
NUM_TXNS NUMBER

Number of transactions
ABS_QTY NUMBER

Absolute quantity of the transactions
ABS_VAL NUMBER

Absolute value of the transactions
COST_GROUP_ID NUMBER

Cost Group Identifier - Used by WMS only
Query Text

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


SELECT SESSION_ID
,      SUMMARY_TYPE
,      SUBINVENTORY
,      LOCATOR_ID
,      TRANSACTION_SOURCE_TYPE_NAME
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_ACTION_NAME
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      NET_QTY
,      NET_VAL
,      NUM_TXNS
,      ABS_QTY
,      ABS_VAL
,      COST_GROUP_ID
FROM INV.MTL_SUMMARY_TEMP;

Dependencies

[top of page]

INV.MTL_SUMMARY_TEMP does not reference any database object

INV.MTL_SUMMARY_TEMP is referenced by following:

SchemaAPPS
SynonymMTL_SUMMARY_TEMP