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

TABLE: INV.MTL_SERIAL_NUMBERS_TEMP

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


MTL_SERIAL_NUMBERS_TEMP holds temporary serial number transaction
records for a parent record in MTL_MATERIAL_TRANSACTIONS_TEMP. Data
in this table will eventually reside in MTL_UNIT_TRANSACTIONS after
processing by the transaction processor. TRANSACTION_TEMP_ID
joins to TRANSACTION_TEMP_ID in MTL_MATERIAL_TRANSACTIONS_TEMP when
under serial control. If also under lot control it joins to
MTL_TRANSACTION_LOTS_TEMP.SERIAL_TRANSACTION_TEMP_ID.
.
.
.
It is possible to have child records in this table without a parent
record due to the autocommit feature of the Serial Number Entry form.
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_SERIAL_NUMBERS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_TEMP_ID
MTL_SERIAL_NUMBERS_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFM_SERIAL_NUMBER
MTL_SERIAL_NUMBERS_TEMP_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_CODE
ColumnPRODUCT_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TEMP_ID NUMBER
Yes Serial number temporary transactions 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

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program application identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program update date
VENDOR_SERIAL_NUMBER VARCHAR2 (30)
Vendor Serial Number
VENDOR_LOT_NUMBER VARCHAR2 (30)
Vednor Lot Number
FM_SERIAL_NUMBER VARCHAR2 (30)
From' serial number
TO_SERIAL_NUMBER VARCHAR2 (30)
'To' serial number
SERIAL_PREFIX VARCHAR2 (30)
Number of serial numbers in range
ERROR_CODE VARCHAR2 (30)
Serial number transaction error code
PARENT_SERIAL_NUMBER VARCHAR2 (30)
Parent serial number
GROUP_HEADER_ID NUMBER

Group identifier used in serial number marking and unmarking routines
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Model unit number
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column - Usedby WMS only
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 (30)
C_ATTRIBUTE22 VARCHAR2 (30)
C_ATTRIBUTE23 VARCHAR2 (30)
C_ATTRIBUTE24 VARCHAR2 (30)
C_ATTRIBUTE25 VARCHAR2 (30)
C_ATTRIBUTE26 VARCHAR2 (30)
C_ATTRIBUTE27 VARCHAR2 (30)
C_ATTRIBUTE28 VARCHAR2 (30)
C_ATTRIBUTE29 VARCHAR2 (30)
C_ATTRIBUTE30 VARCHAR2 (30)
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 (30)
N_ATTRIBUTE12 NUMBER (30)
N_ATTRIBUTE13 NUMBER (30)
N_ATTRIBUTE14 NUMBER (30)
N_ATTRIBUTE15 NUMBER (30)
N_ATTRIBUTE16 NUMBER (30)
N_ATTRIBUTE17 NUMBER (30)
N_ATTRIBUTE18 NUMBER (30)
N_ATTRIBUTE19 NUMBER (30)
N_ATTRIBUTE20 NUMBER (30)
N_ATTRIBUTE21 NUMBER (30)
N_ATTRIBUTE22 NUMBER (30)
N_ATTRIBUTE23 NUMBER (30)
N_ATTRIBUTE24 NUMBER (30)
N_ATTRIBUTE25 NUMBER (30)
N_ATTRIBUTE26 NUMBER (30)
N_ATTRIBUTE27 NUMBER (30)
N_ATTRIBUTE28 NUMBER (30)
N_ATTRIBUTE29 NUMBER (30)
N_ATTRIBUTE30 NUMBER (30)
STATUS_ID NUMBER (30)
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 - Used by WMS only
CYCLES_SINCE_NEW NUMBER

Cycles 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 last visit - Used by WMS only
CYCLES_SINCE_VISIT NUMBER

Cycled Since last visit - Used by WMS only
TIME_SINCE_MARK NUMBER

Time since last Mark - Used by WMS only
CYCLES_SINCE_MARK NUMBER

Cycles since mark - Used by WMS only
NUMER_OF_REPAIRS VARCHAR2 (30)
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
DFF_UPDATED_FLAG VARCHAR2 (1)
Descriptive flexfield Updated column
PARENT_OBJECT_TYPE NUMBER

Parent Object Type
PARENT_OBJECT_ID NUMBER

Genealogy Object Identifier 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
PARENT_OBJECT_ID2 NUMBER

Genealogy Object Identifier of the Lot for Lot-Serial Assembly Item
PARENT_OBJECT_NUMBER2 VARCHAR2 (240)
Lot Number
OBJECT_TYPE2 NUMBER

Object Type2 (used for lot+serial controlled items and will have value 1=lot)
OBJECT_NUMBER2 VARCHAR2 (240)
Object Number2 (used for lot+serial controlled items and will have lot number corresponding to serial number)
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
,      VENDOR_SERIAL_NUMBER
,      VENDOR_LOT_NUMBER
,      FM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      SERIAL_PREFIX
,      ERROR_CODE
,      PARENT_SERIAL_NUMBER
,      GROUP_HEADER_ID
,      END_ITEM_UNIT_NUMBER
,      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
,      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
,      NUMER_OF_REPAIRS
,      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
,      DFF_UPDATED_FLAG
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_NUMBER
,      PARENT_ITEM_ID
,      PARENT_OBJECT_TYPE2
,      PARENT_OBJECT_ID2
,      PARENT_OBJECT_NUMBER2
,      OBJECT_TYPE2
,      OBJECT_NUMBER2
FROM INV.MTL_SERIAL_NUMBERS_TEMP;

Dependencies

[top of page]

INV.MTL_SERIAL_NUMBERS_TEMP does not reference any database object

INV.MTL_SERIAL_NUMBERS_TEMP is referenced by following:

SchemaINV
ViewMTL_SERIAL_NUMBERS_TEMP#