[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_SERIAL_NUMBERS_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_SERIAL_NUMBERS_TEMP_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 TRANSACTION_TEMP_ID
|
| MTL_SERIAL_NUMBERS_TEMP_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FM_SERIAL_NUMBER
|
| MTL_SERIAL_NUMBERS_TEMP_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRODUCT_CODE
PRODUCT_TRANSACTION_ID
|
| 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 | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| 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) | 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) | Flag to Control displaying the DFF (Geerally used for Serial Ranges) | |
| 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) |
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;
INV.MTL_SERIAL_NUMBERS_TEMP does not reference any database object
INV.MTL_SERIAL_NUMBERS_TEMP is referenced by following:
APPS
MTL_SERIAL_NUMBERS_TEMP
|
|
|
|