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

TABLE: INV.MTL_TRANSACTION_LOTS_TEMP

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


MTL_TRANSACTION_LOTS_TEMP stores lot number information for
transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table.
.
.
.
Many lot number records may be specified for a given transaction
record. TRANSACTION_TEMP_ID joins to TRANSACTION_TEMP_ID in
MTL_MATERIAL_TRANSACTIONS_TEMP. SERIAL_TRANSACTION_TEMP_ID joins to
TRANSACTION_TEMP_ID in MTL_SERIAL_NUMBERS_TEMP when also under serial
control
.
.
.
It is possible to have child records in this table without a parent
record due to the autocommit feature of the Lot Entry window.
Periodic deletion of irrelevant data from this table is desired.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_TRANSACTION_LOTS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_TEMP_ID
MTL_TRANSACTION_LOTS_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_CODE
ColumnPRODUCT_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TEMP_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
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
TRANSACTION_QUANTITY NUMBER
Yes Transaction Quantity, in the userr's preferred unit of measure
PRIMARY_QUANTITY NUMBER
Yes Transaction quantity, in the item's primary unit of measure
LOT_NUMBER VARCHAR2 (80) Yes Transaction lot number
LOT_EXPIRATION_DATE DATE

Lot expiration date
ERROR_CODE VARCHAR2 (240)
Lot number transaction error code
SERIAL_TRANSACTION_TEMP_ID NUMBER

connects the corresponding rows in MTL_SERIAL_NUMBERS_TEMP to this table through the TRANSACTION_TEMP_ID
GROUP_HEADER_ID NUMBER

Group identifier
PUT_AWAY_RULE_ID NUMBER

Put Away Rule ID
PICK_RULE_ID NUMBER

Pick Rule ID
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 (150)
ORIGINATION_DATE DATE

Originaion Code- Used By WMS Only
DATE_CODE VARCHAR2 (150)
Date Code- Used By WMS Only
GRADE_CODE VARCHAR2 (150)
Grade Code- Used By WMS Only
CHANGE_DATE DATE

Change Date- Used By WMS Only
MATURITY_DATE DATE

Maturity Date- Used By WMS Only
STATUS_ID NUMBER

Status Identifier - Used by WMS only
RETEST_DATE DATE

Retest Date- Used By WMS Only
AGE NUMBER

Age- 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)
Volume UOM- Used By WMS Only
PLACE_OF_ORIGIN VARCHAR2 (150)
Place of Origin- Used By WMS Only
KILL_DATE DATE

BEST_BY_DATE DATE

Best By Date- Used By WMS Only
LENGTH NUMBER

Length- Used By WMS Only
LENGTH_UOM VARCHAR2 (3)
Length UOM- Used By WMS Only
RECYCLED_CONTENT NUMBER

Recycled Content- Used By WMS Only
THICKNESS NUMBER

Thickness- Used By WMS Only
THICKNESS_UOM VARCHAR2 (3)
Thickness UOM- Used By WMS Only
WIDTH NUMBER

Width- Used By WMS Only
WIDTH_UOM VARCHAR2 (3)
Width UOM- Used By WMS Only
CURL_WRINKLE_FOLD VARCHAR2 (150)
Curl Wrinkle Fold- Used By WMS Only
LOT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Lot Attribute Category- 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
SUBLOT_NUM VARCHAR2 (32)
SubLot Number.
SECONDARY_QUANTITY NUMBER

Dual UOM Secondary Quantity
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
Secondary UOM
QC_GRADE VARCHAR2 (25)
Dual UOM. Quality Control Grade
REASON_CODE VARCHAR2 (4)
Reason Code - This column is added for Teva Enhancement - OPM Reason Code Project
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
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 Id of the Parent entity
PARENT_OBJECT_NUMBER VARCHAR2 (240)
Object Number of the Parent Entity
PARENT_OBJECT_TYPE2 NUMBER

Parent Object Type2
PARENT_OBJECT_ID2 NUMBER

Genealogy Object Identifier of the Lot for Lot-Serial Assembly Item
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)
PARENT_ITEM_ID NUMBER

Inventory Item Id of the parent Object (lot or serial)
Query Text

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


SELECT TRANSACTION_TEMP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      ERROR_CODE
,      SERIAL_TRANSACTION_TEMP_ID
,      GROUP_HEADER_ID
,      PUT_AWAY_RULE_ID
,      PICK_RULE_ID
,      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
,      SUBLOT_NUM
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      REASON_CODE
,      PRODUCT_CODE
,      PRODUCT_TRANSACTION_ID
,      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_OBJECT_TYPE2
,      PARENT_OBJECT_ID2
,      PARENT_OBJECT_NUMBER2
,      PARENT_ITEM_ID
FROM INV.MTL_TRANSACTION_LOTS_TEMP;

Dependencies

[top of page]

INV.MTL_TRANSACTION_LOTS_TEMP does not reference any database object

INV.MTL_TRANSACTION_LOTS_TEMP is referenced by following:

SchemaAPPS
SynonymMTL_TRANSACTION_LOTS_TEMP