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

TABLE: INV.MTL_ADJUSTMENT_SYNC_TEMP

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


Temporary Table for Transactions history adjustment


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

Transaction Number
TRANSACTION_DATE DATE

Date of Transaction
CATEGORY VARCHAR2 (163)
Category
CATEGORY_ID NUMBER
Yes Category Identifier
WAREHOUSE VARCHAR2 (240) Yes Organization Name
ORGANIZATION_ID NUMBER

Organization identifier
ITEM VARCHAR2 (240)
Item
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
REVISION VARCHAR2 (3)
Revision
SUBINVENTORY VARCHAR2 (10)
Subinventory Name
LOCATOR VARCHAR2 (122)
Locator
TRANSFER_WAREHOUSE VARCHAR2 (240)
Transfer Organization Name
TRANSFER_SUBINVENTORY VARCHAR2 (10)
Transfer Subinventory Name
TRANSFER_LOCATOR VARCHAR2 (122)
Transfer locator
LPN VARCHAR2 (30)
License Plate Number
TRANSFER_LPN VARCHAR2 (30)
Transfer License Plate Number
CONTENT_LPN VARCHAR2 (30)
Content License Plate Number
TRANSACTION_TYPE VARCHAR2 (80) Yes Transaction type
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction source type Identifier
TRANSACTION_ACTION_ID NUMBER

Transaction action identifier
TRANSACTION_SOURCE VARCHAR2 (240)
Transaction Source
CREATION_DATE DATE

Standard Who column
TRANSACTION_EXTRACTED VARCHAR2 (1)
Extracted Transaction
XML_DOCUMENT_ID NUMBER

XML Document Identifier
TRANSACTION_QUANTITY NUMBER

Transaction Quantity
TRANSACTION_UOM VARCHAR2 (25) Yes UOM Transaction
PRIMARY_QUANTITY NUMBER

Primary Quantity
PRIMARY_UOM VARCHAR2 (25) Yes Primary UOM
SECONDARY_QUANTITY NUMBER

Secondary Quantity
SECONDARY_UOM VARCHAR2 (25)
Secondary UOM
ENTITY_ID NUMBER
Yes Entity Identifier
Query Text

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


SELECT TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      CATEGORY
,      CATEGORY_ID
,      WAREHOUSE
,      ORGANIZATION_ID
,      ITEM
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_ID
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      TRANSFER_WAREHOUSE
,      TRANSFER_SUBINVENTORY
,      TRANSFER_LOCATOR
,      LPN
,      TRANSFER_LPN
,      CONTENT_LPN
,      TRANSACTION_TYPE
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE
,      CREATION_DATE
,      TRANSACTION_EXTRACTED
,      XML_DOCUMENT_ID
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      ENTITY_ID
FROM INV.MTL_ADJUSTMENT_SYNC_TEMP;

Dependencies

[top of page]

INV.MTL_ADJUSTMENT_SYNC_TEMP does not reference any database object

INV.MTL_ADJUSTMENT_SYNC_TEMP is referenced by following:

SchemaINV
ViewMTL_ADJUSTMENT_SYNC_TEMP#