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

TABLE: INV.MTL_LSP_ONHAND_BALANCE_TMP

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

View Type

Internal

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CATEGORY VARCHAR2 (163)
Item category
WAREHOUSE_ID NUMBER

Organization identifier
WAREHOUSE VARCHAR2 (23)
Organization code
ITEM_ID NUMBER

Inventory item identifier
ITEM VARCHAR2 (40)
Inventory item segment
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory item description
REVISION VARCHAR2 (3)
Item revision code
SUBINVENTORY VARCHAR2 (10)
Subinventory code
LOCATOR VARCHAR2 (122)
Locator segment
LOT VARCHAR2 (80)
Lot number
LPN VARCHAR2 (30)
Licence plate number
PARENT_LPN VARCHAR2 (30)
Parent licence plate number
SERIAL VARCHAR2 (30)
Serial number
CONTAINERIZED_FLAG VARCHAR2 (3)
Containerized Flag
PRIMARY_QUANTITY NUMBER

Transaction quantity in terms of primary uom of the item
PRIMARY_UOM VARCHAR2 (25) Yes Primary unit of measure
SECONDARY_QUANTITY NUMBER

Secondary quantity
SECONDARY_UOM VARCHAR2 (25)
Secondary unit of measure that may have been used to do the material transaction
SNAPSHOT_DATE DATE

The date to keep the onhand quantity snapshot
ONHAND_STATUS VARCHAR2 (80)
Onhand material status
XML_DOCUMENT_ID NUMBER

XML document identifier
Query Text

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


SELECT CATEGORY
,      WAREHOUSE_ID
,      WAREHOUSE
,      ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      LOT
,      LPN
,      PARENT_LPN
,      SERIAL
,      CONTAINERIZED_FLAG
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      SNAPSHOT_DATE
,      ONHAND_STATUS
,      XML_DOCUMENT_ID
FROM INV.MTL_LSP_ONHAND_BALANCE_TMP;

Dependencies

[top of page]

INV.MTL_LSP_ONHAND_BALANCE_TMP does not reference any database object

INV.MTL_LSP_ONHAND_BALANCE_TMP is referenced by following:

SchemaINV
ViewMTL_LSP_ONHAND_BALANCE_TMP#