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


TABLE: INV.MTL_ONHAND_QUANTITY_TEMP

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


MTL_ONHAND_QUANTITY_TEMP is used in the form, Multi-Organization Item
Quantities. This form requests Multi-Org Item Quantities report.
MTL_ONHAND_QUANTITY_TEMP temporarily stores the item on hand quantity
information for the specified organizations. Upon report completion,
the stored information is deleted. SEQ_NUM, based on the sequence,
MTL_ONHAND_QUANTITY_TEMP_S, is used to distinguish a set of
records from others. The C_COLUMNs, D_COLUMNs and N_COLUMNs are
generic column names to store character, date and number information
respectively.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SEQ_NUM NUMBER

Group sequence id created by onhand query routine
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
SUBINVENTORY VARCHAR2 (10)
Secondary inventory identifier
LOCATOR_ID NUMBER

Stock locator id
QUANTITY NUMBER

Quantity for item
REVISION VARCHAR2 (3)
Inventory item revision code
LOT_NUMBER VARCHAR2 (80)
Lot number for item
C_COLUMN1 VARCHAR2 (240)
Generic character query column
C_COLUMN2 VARCHAR2 (240)
Generic character query column
C_COLUMN3 VARCHAR2 (240)
Generic character query column
C_COLUMN4 VARCHAR2 (240)
Generic character query column
C_COLUMN5 VARCHAR2 (240)
Generic character query column
C_COLUMN6 VARCHAR2 (240)
Generic character query column
C_COLUMN7 VARCHAR2 (240)
Generic character query column
C_COLUMN8 VARCHAR2 (240)
Generic character query column
N_COLUMN1 NUMBER

Generic numeric query column
N_COLUMN2 NUMBER

Generic numeric query column
N_COLUMN3 NUMBER

Generic numeric query column
N_COLUMN4 NUMBER

Generic numeric query column
N_COLUMN5 NUMBER

Generic numeric query column
D_COLUMN1 DATE

Generic date query column
D_COLUMN2 DATE

Generic date query column
D_COLUMN3 DATE

Generic date query column
D_COLUMN4 DATE

Generic date query column
D_COLUMN5 DATE

Generic date query column
Query Text

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


SELECT SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      QUANTITY
,      REVISION
,      LOT_NUMBER
,      C_COLUMN1
,      C_COLUMN2
,      C_COLUMN3
,      C_COLUMN4
,      C_COLUMN5
,      C_COLUMN6
,      C_COLUMN7
,      C_COLUMN8
,      N_COLUMN1
,      N_COLUMN2
,      N_COLUMN3
,      N_COLUMN4
,      N_COLUMN5
,      D_COLUMN1
,      D_COLUMN2
,      D_COLUMN3
,      D_COLUMN4
,      D_COLUMN5
FROM INV.MTL_ONHAND_QUANTITY_TEMP;

Dependencies

[top of page]

INV.MTL_ONHAND_QUANTITY_TEMP does not reference any database object

INV.MTL_ONHAND_QUANTITY_TEMP is referenced by following:

SchemaINV
ViewMTL_ONHAND_QUANTITY_TEMP#