eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	INV.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_UNIT_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERIAL_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID TRANSACTION_DATE
MTL_UNIT_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE_ID
MTL_UNIT_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID SHIP_ID
MTL_UNIT_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID
MTL_UNIT_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TRANSACTION_DATE
MTL_UNIT_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MTL_UNIT_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRODUCT_CODE PRODUCT_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)		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:

APPS: MTL_UNIT_TRANSACTIONS