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_TRANSACTION_LOTS_INTERFACE

Object Details

Object Name:	MTL_TRANSACTION_LOTS_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_TRANSACTION_LOTS_INTERFACE
Subobject Name:
Status:	VALID

This is the open interface table of lot information corresponding to
material transactions posted to Oracle Inventory.
The records in this table have a corresponding
parent record in MTL_TRANSACTIONS_INTERFACE. The records in this table
will be picked up and validated by the Transaction Manager and
then transferred to their respective temporary table for processing.
Scope: public
Lifecycle: active
Display Name: Lot Transactions Interface
Product: INV
Category: BUSINESS_ENTITY INV_MATERIAL_TRANSACTION

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_TRANSACTION_LOTS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_INTERFACE_ID
MTL_TRANSACTION_LOTS_INT_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PRODUCT_CODE PRODUCT_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_INTERFACE_ID	NUMBER		Yes	Transaction identifier
SOURCE_CODE	VARCHAR2	(30)		Source identifier
SOURCE_LINE_ID	NUMBER			Source line 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
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
LOT_NUMBER	VARCHAR2	(80)	Yes	Lot number
LOT_EXPIRATION_DATE	DATE			Expiration date
TRANSACTION_QUANTITY	NUMBER		Yes	Transaction Quantity
PRIMARY_QUANTITY	NUMBER			Quantity
SERIAL_TRANSACTION_TEMP_ID	NUMBER			Serial transaction identifier
ERROR_CODE	VARCHAR2	(240)		Error code
PROCESS_FLAG	VARCHAR2	(1)		Row Process Flag (Not used currently)
DESCRIPTION	VARCHAR2	(256)		- Used By WMS Only
VENDOR_NAME	VARCHAR2	(240)		Vendor Name- Used By WMS Only
SUPPLIER_LOT_NUMBER	VARCHAR2	(150)		Supplier Lot Number- Used By WMS Only
COUNTRY_OF_ORIGIN	VARCHAR2	(30)
ORIGINATION_DATE	DATE			Origination date of the lot- Used By WMS Only
DATE_CODE	VARCHAR2	(150)		A code identifying the date of packaging or assembly- Used By WMS Only
GRADE_CODE	VARCHAR2	(150)		The sublabeling of items, lots and sublots to identify their particular makeup and to separate one lot from other production lots of the same item .- Used By WMS Only
CHANGE_DATE	DATE			A user entered attribute that defines the date on which an attribute of the lot or sublot was last changed.- Used By WMS Only
MATURITY_DATE	DATE			The date on which the lot matures- Used By WMS Only
STATUS_ID	NUMBER			Identifier for the status of lot - Used by WMS only
RETEST_DATE	DATE			Restest Date- Used By WMS Only
AGE	NUMBER			The age of the lot or sublot in days after the creation date.- Used By WMS Only
ITEM_SIZE	NUMBER			Item size- Used By WMS Only
COLOR	VARCHAR2	(150)		Color- Used By WMS Only
VOLUME	NUMBER			volume- Used By WMS Only
VOLUME_UOM	VARCHAR2	(3)		UOM for measuring Volume- Used By WMS Only
PLACE_OF_ORIGIN	VARCHAR2	(150)		A value indicating the place the inventory originated- Used By WMS Only
KILL_DATE	DATE
BEST_BY_DATE	DATE			The date on or before which the lot or sublot is best used- Used By WMS Only
LENGTH	NUMBER			length- Used By WMS Only
LENGTH_UOM	VARCHAR2	(3)		UOM to measure lenght- Used By WMS Only
RECYCLED_CONTENT	NUMBER			The content, usually expressed as a percentage, of the product that is made up of recycled materials- Used By WMS Only
THICKNESS	NUMBER			Thickness- Used By WMS Only
THICKNESS_UOM	VARCHAR2	(3)		UOM to measure thickness- Used By WMS Only
WIDTH	NUMBER			width- Used By WMS Only
WIDTH_UOM	VARCHAR2	(3)		UOM to measure width- Used By WMS Only
CURL_WRINKLE_FOLD	VARCHAR2	(150)		This attribute is used in the pulp and paper industry to identify potential problems when feeding the paper through machinery.- Used By WMS Only
LOT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Lot attributes descriptive flexfield structure defining column- 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
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
VENDOR_ID	NUMBER			Identification for Vendor- Used By WMS Only
TERRITORY_CODE	VARCHAR2	(30)		Territory code for country of Origin
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
SECONDARY_TRANSACTION_QUANTITY	NUMBER			Stores the secondary transaction quantity
SUBLOT_NUM	VARCHAR2	(32)		Sub-lot number
REASON_CODE	VARCHAR2	(4)		Reason Code
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
EXPIRATION_ACTION_CODE	VARCHAR2	(32)		Expiration Action Code
EXPIRATION_ACTION_DATE	DATE			Expiration Action Date
HOLD_DATE	DATE			Hold Date
ORIGINATION_TYPE	NUMBER			Origination Type
PARENT_LOT_NUMBER	VARCHAR2	(80)		Parent Lot Number
REASON_ID	NUMBER			Reason ID
PARENT_OBJECT_TYPE	NUMBER			Parent Object Type
PARENT_OBJECT_ID	NUMBER			Genealogy Object Identifier of the Parent entity
PARENT_OBJECT_NUMBER	VARCHAR2	(240)		Parent Object Number
PARENT_ITEM_ID	NUMBER			Parent Item Identifier
PARENT_OBJECT_TYPE2	NUMBER			Parent Object Type2
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_INTERFACE_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      SERIAL_TRANSACTION_TEMP_ID
,      ERROR_CODE
,      PROCESS_FLAG
,      DESCRIPTION
,      VENDOR_NAME
,      SUPPLIER_LOT_NUMBER
,      COUNTRY_OF_ORIGIN
,      ORIGINATION_DATE
,      DATE_CODE
,      GRADE_CODE
,      CHANGE_DATE
,      MATURITY_DATE
,      STATUS_ID
,      RETEST_DATE
,      AGE
,      ITEM_SIZE
,      COLOR
,      VOLUME
,      VOLUME_UOM
,      PLACE_OF_ORIGIN
,      KILL_DATE
,      BEST_BY_DATE
,      LENGTH
,      LENGTH_UOM
,      RECYCLED_CONTENT
,      THICKNESS
,      THICKNESS_UOM
,      WIDTH
,      WIDTH_UOM
,      CURL_WRINKLE_FOLD
,      LOT_ATTRIBUTE_CATEGORY
,      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
,      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
,      VENDOR_ID
,      TERRITORY_CODE
,      PRODUCT_CODE
,      PRODUCT_TRANSACTION_ID
,      SECONDARY_TRANSACTION_QUANTITY
,      SUBLOT_NUM
,      REASON_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXPIRATION_ACTION_CODE
,      EXPIRATION_ACTION_DATE
,      HOLD_DATE
,      ORIGINATION_TYPE
,      PARENT_LOT_NUMBER
,      REASON_ID
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_NUMBER
,      PARENT_ITEM_ID
,      PARENT_OBJECT_TYPE2
,      PARENT_OBJECT_ID2
,      PARENT_OBJECT_NUMBER2
FROM INV.MTL_TRANSACTION_LOTS_INTERFACE;

Dependencies

[top of page]

INV.MTL_TRANSACTION_LOTS_INTERFACE does not reference any database object

INV.MTL_TRANSACTION_LOTS_INTERFACE is referenced by following:

APPS: MTL_TRANSACTION_LOTS_INTERFACE