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


TABLE: INV.MTL_UNIT_TRANSACTIONS

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


MTL_UNIT_TRANSACTIONS stores a record of every material transaction of
a serialized unit in Inventory. Records are inserted into this table
through the transaction processor.
.
.
.
Many serial numbers may be specified for a given transaction record.
TRANSACTION_ID joins to MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID when
only under serial control. TRANSACTION_ID joins to
MTL_TRANSACTION_LOT_NUMBERS.SERIAL_TRANSACTION_ID when also under lot
control.
.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_UNIT_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERIAL_NUMBER
ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_UNIT_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SOURCE_ID
MTL_UNIT_TRANSACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnSHIP_ID
MTL_UNIT_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
MTL_UNIT_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_UNIT_TRANSACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
MTL_UNIT_TRANSACTIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_CODE
ColumnPRODUCT_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Transaction identifier
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
SERIAL_NUMBER VARCHAR2 (30) Yes Serial number
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
LOCATOR_ID NUMBER

Transaction locator identifier
TRANSACTION_DATE DATE
Yes Transaction date
TRANSACTION_SOURCE_ID NUMBER

Previous disposition (derived from MTL_MATERIAL_TRANSACTIONS)
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes Disposition type code
TRANSACTION_SOURCE_NAME VARCHAR2 (240)
Source name of the transaction
RECEIPT_ISSUE_TYPE NUMBER
Yes Previous receipt/issue code
CUSTOMER_ID NUMBER

Customer code
SHIP_ID NUMBER

Ship code
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Serial Attribute Category
COUNTRY_OF_ORIGIN VARCHAR2 (30)
ORIGINATION_DATE DATE

Creation Date of the serial number such as manufacture date. - Used by WMS only
C_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Segment - Used by WMS only
C_ATTRIBUTE21 VARCHAR2 (150)
C_ATTRIBUTE22 VARCHAR2 (150)
C_ATTRIBUTE23 VARCHAR2 (150)
C_ATTRIBUTE24 VARCHAR2 (150)
C_ATTRIBUTE25 VARCHAR2 (150)
C_ATTRIBUTE26 VARCHAR2 (150)
C_ATTRIBUTE27 VARCHAR2 (150)
C_ATTRIBUTE28 VARCHAR2 (150)
C_ATTRIBUTE29 VARCHAR2 (150)
C_ATTRIBUTE30 VARCHAR2 (150)
D_ATTRIBUTE1 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE2 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE3 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE4 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE5 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE6 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE7 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE8 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE9 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE10 DATE

Descriptive Flexfield Segment - Used by WMS only
D_ATTRIBUTE11 DATE

D_ATTRIBUTE12 DATE

D_ATTRIBUTE13 DATE

D_ATTRIBUTE14 DATE

D_ATTRIBUTE15 DATE

D_ATTRIBUTE16 DATE

D_ATTRIBUTE17 DATE

D_ATTRIBUTE18 DATE

D_ATTRIBUTE19 DATE

D_ATTRIBUTE20 DATE

D_ATTRIBUTE21 DATE

D_ATTRIBUTE22 DATE

D_ATTRIBUTE23 DATE

D_ATTRIBUTE24 DATE

D_ATTRIBUTE25 DATE

D_ATTRIBUTE26 DATE

D_ATTRIBUTE27 DATE

D_ATTRIBUTE28 DATE

D_ATTRIBUTE29 DATE

D_ATTRIBUTE30 DATE

N_ATTRIBUTE1 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE2 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE3 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE4 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE5 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE6 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE7 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE8 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE9 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE10 NUMBER

Descriptive Flexfield Segment - Used by WMS only
N_ATTRIBUTE11 NUMBER

N_ATTRIBUTE12 NUMBER

N_ATTRIBUTE13 NUMBER

N_ATTRIBUTE14 NUMBER

N_ATTRIBUTE15 NUMBER

N_ATTRIBUTE16 NUMBER

N_ATTRIBUTE17 NUMBER

N_ATTRIBUTE18 NUMBER

N_ATTRIBUTE19 NUMBER

N_ATTRIBUTE20 NUMBER

N_ATTRIBUTE21 NUMBER

N_ATTRIBUTE22 NUMBER

N_ATTRIBUTE23 NUMBER

N_ATTRIBUTE24 NUMBER

N_ATTRIBUTE25 NUMBER

N_ATTRIBUTE26 NUMBER

N_ATTRIBUTE27 NUMBER

N_ATTRIBUTE28 NUMBER

N_ATTRIBUTE29 NUMBER

N_ATTRIBUTE30 NUMBER

STATUS_ID NUMBER

Status Identifier - Used by WMS only
TERRITORY_CODE VARCHAR2 (30)
Territory code for Country of Origin-- Usedby WMS only
TIME_SINCE_NEW NUMBER

Time since new - Usedby WMS only
CYCLES_SINCE_NEW NUMBER

Cycle since new - Used by WMS only
TIME_SINCE_OVERHAUL NUMBER

Time since overhaul - Used by WMS only
CYCLES_SINCE_OVERHAUL NUMBER

Cycles since overhaul - Used by WMS only
TIME_SINCE_REPAIR NUMBER

Time since repair - Used by WMS only
CYCLES_SINCE_REPAIR NUMBER

Cycles since repair - Used by WMS only
TIME_SINCE_VISIT NUMBER

Time since visit for MRO - Used by WMS only
CYCLES_SINCE_VISIT NUMBER

Cycles since visit for MRO - Used by WMS only
TIME_SINCE_MARK NUMBER

Time since mark for MRO- Used by WMS only
CYCLES_SINCE_MARK NUMBER

Cycles since mark - Used by WMS only
NUMBER_OF_REPAIRS NUMBER

Total Number of repairs - Used by WMS only
PRODUCT_CODE VARCHAR2 (5)
Stores the product name to identify the source transaction for the record
PRODUCT_TRANSACTION_ID NUMBER

Stores the identifier for the transaction in the table owned by the product specified under PRODUCT_CODE column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attributes descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PARENT_OBJECT_TYPE NUMBER

Parent Object Type
PARENT_OBJECT_ID NUMBER

Genealogy Object Id of the Parent entity
PARENT_OBJECT_NUMBER VARCHAR2 (240)
Object Number of the Parent Entity
PARENT_ITEM_ID NUMBER

Inventory Item Id of the parent Object (lot or serial)
PARENT_OBJECT_TYPE2 NUMBER

Parent Object Type2 (used for lot+serial controlled items and will have value 1=lot)
PARENT_OBJECT_ID2 NUMBER

Parent Object Id2 (used for lot+serial controlled items and will have gen object id of lot number corresponding to serial number in parent object number)
PARENT_OBJECT_NUMBER2 VARCHAR2 (240)
Parent Object Number2 (used for lot+serial controlled items and will have lot number corresponding to serial number in parent object number)
Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_DATE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_NAME
,      RECEIPT_ISSUE_TYPE
,      CUSTOMER_ID
,      SHIP_ID
,      SERIAL_ATTRIBUTE_CATEGORY
,      COUNTRY_OF_ORIGIN
,      ORIGINATION_DATE
,      C_ATTRIBUTE1
,      C_ATTRIBUTE2
,      C_ATTRIBUTE3
,      C_ATTRIBUTE4
,      C_ATTRIBUTE5
,      C_ATTRIBUTE6
,      C_ATTRIBUTE7
,      C_ATTRIBUTE8
,      C_ATTRIBUTE9
,      C_ATTRIBUTE10
,      C_ATTRIBUTE11
,      C_ATTRIBUTE12
,      C_ATTRIBUTE13
,      C_ATTRIBUTE14
,      C_ATTRIBUTE15
,      C_ATTRIBUTE16
,      C_ATTRIBUTE17
,      C_ATTRIBUTE18
,      C_ATTRIBUTE19
,      C_ATTRIBUTE20
,      C_ATTRIBUTE21
,      C_ATTRIBUTE22
,      C_ATTRIBUTE23
,      C_ATTRIBUTE24
,      C_ATTRIBUTE25
,      C_ATTRIBUTE26
,      C_ATTRIBUTE27
,      C_ATTRIBUTE28
,      C_ATTRIBUTE29
,      C_ATTRIBUTE30
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      D_ATTRIBUTE11
,      D_ATTRIBUTE12
,      D_ATTRIBUTE13
,      D_ATTRIBUTE14
,      D_ATTRIBUTE15
,      D_ATTRIBUTE16
,      D_ATTRIBUTE17
,      D_ATTRIBUTE18
,      D_ATTRIBUTE19
,      D_ATTRIBUTE20
,      D_ATTRIBUTE21
,      D_ATTRIBUTE22
,      D_ATTRIBUTE23
,      D_ATTRIBUTE24
,      D_ATTRIBUTE25
,      D_ATTRIBUTE26
,      D_ATTRIBUTE27
,      D_ATTRIBUTE28
,      D_ATTRIBUTE29
,      D_ATTRIBUTE30
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      N_ATTRIBUTE11
,      N_ATTRIBUTE12
,      N_ATTRIBUTE13
,      N_ATTRIBUTE14
,      N_ATTRIBUTE15
,      N_ATTRIBUTE16
,      N_ATTRIBUTE17
,      N_ATTRIBUTE18
,      N_ATTRIBUTE19
,      N_ATTRIBUTE20
,      N_ATTRIBUTE21
,      N_ATTRIBUTE22
,      N_ATTRIBUTE23
,      N_ATTRIBUTE24
,      N_ATTRIBUTE25
,      N_ATTRIBUTE26
,      N_ATTRIBUTE27
,      N_ATTRIBUTE28
,      N_ATTRIBUTE29
,      N_ATTRIBUTE30
,      STATUS_ID
,      TERRITORY_CODE
,      TIME_SINCE_NEW
,      CYCLES_SINCE_NEW
,      TIME_SINCE_OVERHAUL
,      CYCLES_SINCE_OVERHAUL
,      TIME_SINCE_REPAIR
,      CYCLES_SINCE_REPAIR
,      TIME_SINCE_VISIT
,      CYCLES_SINCE_VISIT
,      TIME_SINCE_MARK
,      CYCLES_SINCE_MARK
,      NUMBER_OF_REPAIRS
,      PRODUCT_CODE
,      PRODUCT_TRANSACTION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_NUMBER
,      PARENT_ITEM_ID
,      PARENT_OBJECT_TYPE2
,      PARENT_OBJECT_ID2
,      PARENT_OBJECT_NUMBER2
FROM INV.MTL_UNIT_TRANSACTIONS;

Dependencies

[top of page]

INV.MTL_UNIT_TRANSACTIONS does not reference any database object

INV.MTL_UNIT_TRANSACTIONS is referenced by following:

SchemaINV
ViewMTL_UNIT_TRANSACTIONS#