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

TABLE: INV.MTL_SERIAL_NUMBERS_INTERFACE

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


This is the open interface table of serial 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: Serial Number Transactions Interface
Product: INV
Category: BUSINESS_ENTITY INV_MATERIAL_TRANSACTION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_SERIAL_NUMBERS_INTRFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_INTERFACE_ID
MTL_SERIAL_NUMBERS_INTRFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPRODUCT_CODE
ColumnPRODUCT_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_INTERFACE_ID NUMBER
Yes Joins to MTL_TRANSACTION_LOTS_INTERFACE OR MTL_TRANSACTIONS_INTERFACE
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

Concurrent who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent who column
PROGRAM_ID NUMBER

Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
VENDOR_SERIAL_NUMBER VARCHAR2 (30)
Supplier serial number
VENDOR_LOT_NUMBER VARCHAR2 (30)
Supplier lot number
FM_SERIAL_NUMBER VARCHAR2 (30)
Single serial number or beginning serial number in range
TO_SERIAL_NUMBER VARCHAR2 (30)
Ending serial number in a range
ERROR_CODE VARCHAR2 (240)
Error code
PROCESS_FLAG NUMBER

Row process flag (not currently used)
PARENT_SERIAL_NUMBER VARCHAR2 (30)
Parent serial number
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Structure Defining column for Serial Attributes flex field - Used by 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_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

STATUS_ID NUMBER

Status identifier - Used by WMS only
TERRITORY_CODE VARCHAR2 (30)
Territory code for Country of Origin - Used by WMS only
TIME_SINCE_NEW NUMBER

Time since new for MRO industry - Used by WMS only
CYCLES_SINCE_NEW NUMBER

Cycles since new for MRO industry - Used by WMS only
TIME_SINCE_OVERHAUL NUMBER

Time Since overhaul for MRO industry - Used by WMS only
CYCLES_SINCE_OVERHAUL NUMBER

Cycles since overhaul for MRO industry - Used by WMS only
TIME_SINCE_REPAIR NUMBER

Time Since repair for MRO industry - Used by WMS only
CYCLES_SINCE_REPAIR NUMBER

Cycles Since repair for MRO industry - Used by WMS only
TIME_SINCE_VISIT NUMBER

Time since Visit for MRO industry - Used by WMS only
CYCLES_SINCE_VISIT NUMBER

Cycles since visit for MRO industry - Used by WMS only
TIME_SINCE_MARK NUMBER

Time since the serial Number is marked for MRO Industry - Used by WMS only
CYCLES_SINCE_MARK NUMBER

Number of Cycles since the serial Number is marked, for MRO Industry - Used by WMS only
NUMBER_OF_REPAIRS NUMBER

Number of repairs for MRO industry - Used by WMS only
STATUS_NAME VARCHAR2 (30)
STATUS of the Serial Number
C_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment - Used by WMS only
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
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
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
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

Genealogy Object Identifier of the Lot for Lot-Serial Assembly Item
PARENT_OBJECT_NUMBER2 VARCHAR2 (240)
Lot Number for a Lot-Serial Assembly Item
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
,      VENDOR_SERIAL_NUMBER
,      VENDOR_LOT_NUMBER
,      FM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      ERROR_CODE
,      PROCESS_FLAG
,      PARENT_SERIAL_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_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
,      NUMBER_OF_REPAIRS
,      STATUS_NAME
,      C_ATTRIBUTE17
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRODUCT_CODE
,      PRODUCT_TRANSACTION_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_SERIAL_NUMBERS_INTERFACE;

Dependencies

[top of page]

INV.MTL_SERIAL_NUMBERS_INTERFACE does not reference any database object

INV.MTL_SERIAL_NUMBERS_INTERFACE is referenced by following:

SchemaAPPS
SynonymMTL_SERIAL_NUMBERS_INTERFACE