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

TABLE: INV.MTL_EAM_ASSET_NUM_INTERFACE

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


Interface table for Asset Number Import program. Users load this table with asset data from their legacy system. Asset Number Import concurrent program processes rows in this table and imports assets into Oracle Applications.
This table is used to populate data before executing EAM_AST_NUM_INTERFACE concurrent program.
Scope: public
Product: EAM
Lifecycle: active
Display Name: MTL_EAM_ASSET_NUM_INTERFACE
Category: OPEN_INTERFACE EAM_AST_NUM_INTERFACE 1
Category: BUSINESS_ENTITY EAM_ASSET_NUMBER


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_EAM_ASSET_NUM_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_HEADER_ID
MTL_EAM_ASSET_NUM_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_GROUP_ID
ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Asset Group identifier
SERIAL_NUMBER VARCHAR2 (30) Yes Asset Serial Number
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
PARENT_SERIAL_NUMBER VARCHAR2 (30)
Parent Asset Serial Number
VENDOR_SERIAL_NUMBER VARCHAR2 (30)
Supplier serial number
VENDOR_LOT_NUMBER VARCHAR2 (30)
Supplier lot number
DESCRIPTIVE_TEXT VARCHAR2 (240)
Asset Description
CURRENT_ORGANIZATION_ID NUMBER

Current organization identifier
SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ORIGINATION_DATE DATE

Creation Date of the serial number such as manufacture date -- Used by WMS only
C_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield
C_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield
D_ATTRIBUTE1 DATE

Descriptive Flexfield
D_ATTRIBUTE2 DATE

Descriptive Flexfield
D_ATTRIBUTE3 DATE

Descriptive Flexfield
D_ATTRIBUTE4 DATE

Descriptive Flexfield
D_ATTRIBUTE5 DATE

Descriptive Flexfield
D_ATTRIBUTE6 DATE

Descriptive Flexfield
D_ATTRIBUTE7 DATE

Descriptive Flexfield
D_ATTRIBUTE8 DATE

Descriptive Flexfield
D_ATTRIBUTE9 DATE

Descriptive Flexfield
D_ATTRIBUTE10 DATE

Descriptive Flexfield
N_ATTRIBUTE1 NUMBER

Descriptive Flexfield
N_ATTRIBUTE2 NUMBER

Descriptive Flexfield
N_ATTRIBUTE3 NUMBER

Descriptive Flexfield
N_ATTRIBUTE4 NUMBER

Descriptive Flexfield
N_ATTRIBUTE5 NUMBER

Descriptive Flexfield
N_ATTRIBUTE6 NUMBER

Descriptive Flexfield
N_ATTRIBUTE7 NUMBER

Descriptive Flexfield
N_ATTRIBUTE8 NUMBER

Descriptive Flexfield
N_ATTRIBUTE9 NUMBER

Descriptive Flexfield
N_ATTRIBUTE10 NUMBER

Descriptive Flexfield
STATUS_ID NUMBER

Status Id -- Used by WMS only
TERRITORY_CODE VARCHAR2 (30)
Territory Code -- Used by 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 visit -- Used by WMS only
CYCLES_SINCE_VISIT NUMBER

Cycles since visit -- Used by WMS only
TIME_SINCE_MARK NUMBER

Time since mark -- Used by WMS only
CYCLES_SINCE_MARK NUMBER

Cycles since mark -- Used by WMS only
WIP_ACCOUNTING_CLASS_CODE VARCHAR2 (10)
WIP Accounting class code
MAINTAINABLE_FLAG VARCHAR2 (1)
Maintainable Flag
OWNING_DEPARTMENT_ID NUMBER

Owning Department Identifier
NETWORK_ASSET_FLAG VARCHAR2 (1)
Asset Route Flag (Y/N)
FA_ASSET_ID NUMBER

Fixed asset identifier
PN_LOCATION_ID NUMBER

Property management location identifier
EAM_LOCATION_ID NUMBER

EAM Area identifier
ASSET_CRITICALITY_CODE VARCHAR2 (30)
Asset Criticality Code
CATEGORY_ID NUMBER

Category identifier
INTERFACE_GROUP_ID NUMBER

Interface Group identifier
INTERFACE_HEADER_ID NUMBER
Yes Interface Header identifier
BATCH_ID NUMBER

Batch identifier
ERROR_CODE NUMBER

Error Code
ERROR_MESSAGE VARCHAR2 (240)
Error Message
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
EQP_SERIAL_NUMBER VARCHAR2 (30)
Equipment Serial Number
EQUIPMENT_ITEM_ID NUMBER

Equipment Item identifier
PROD_ORGANIZATION_ID NUMBER

Production Organization identifier
FA_ASSET_NUMBER VARCHAR2 (15)
Fixed Asset Number
LOCATION_CODES VARCHAR2 (30)
Area Code
PROCESS_FLAG VARCHAR2 (1)
Process Flag
IMPORT_MODE NUMBER
Yes Import Mode
IMPORT_SCOPE NUMBER
Yes Import Scope
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
Owing Department Code
ASSET_CRITICALITY_ID NUMBER

Asset Criticality Code
CURRENT_STATUS NUMBER

Current Status
PROD_ORGANIZATION_CODE VARCHAR2 (3)
Production Organization Code
PARENT_INVENTORY_ITEM_ID NUMBER

Parent Inventory Item Id
BATCH_NAME VARCHAR2 (30)
Batch Name
INSTANCE_NUMBER VARCHAR2 (30)
Asset Number
ACTIVE_START_DATE DATE

Active Start Date
ACTIVE_END_DATE DATE

Active End Date
PARENT_INSTANCE_NUMBER VARCHAR2 (30)
Parent Asset Number
SUPPLIER_WARRANTY_EXP_DATE DATE

Supplier Warranty Expiration Date
OPERATIONAL_LOG_FLAG VARCHAR2 (1)
Operational Log Flag
CHECKIN_STATUS NUMBER

Check in Status
Query Text

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


SELECT INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARENT_SERIAL_NUMBER
,      VENDOR_SERIAL_NUMBER
,      VENDOR_LOT_NUMBER
,      DESCRIPTIVE_TEXT
,      CURRENT_ORGANIZATION_ID
,      SERIAL_ATTRIBUTE_CATEGORY
,      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
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      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
,      WIP_ACCOUNTING_CLASS_CODE
,      MAINTAINABLE_FLAG
,      OWNING_DEPARTMENT_ID
,      NETWORK_ASSET_FLAG
,      FA_ASSET_ID
,      PN_LOCATION_ID
,      EAM_LOCATION_ID
,      ASSET_CRITICALITY_CODE
,      CATEGORY_ID
,      INTERFACE_GROUP_ID
,      INTERFACE_HEADER_ID
,      BATCH_ID
,      ERROR_CODE
,      ERROR_MESSAGE
,      ORGANIZATION_CODE
,      EQP_SERIAL_NUMBER
,      EQUIPMENT_ITEM_ID
,      PROD_ORGANIZATION_ID
,      FA_ASSET_NUMBER
,      LOCATION_CODES
,      PROCESS_FLAG
,      IMPORT_MODE
,      IMPORT_SCOPE
,      OWNING_DEPARTMENT_CODE
,      ASSET_CRITICALITY_ID
,      CURRENT_STATUS
,      PROD_ORGANIZATION_CODE
,      PARENT_INVENTORY_ITEM_ID
,      BATCH_NAME
,      INSTANCE_NUMBER
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      PARENT_INSTANCE_NUMBER
,      SUPPLIER_WARRANTY_EXP_DATE
,      OPERATIONAL_LOG_FLAG
,      CHECKIN_STATUS
FROM INV.MTL_EAM_ASSET_NUM_INTERFACE;

Dependencies

[top of page]

INV.MTL_EAM_ASSET_NUM_INTERFACE does not reference any database object

INV.MTL_EAM_ASSET_NUM_INTERFACE is referenced by following:

SchemaAPPS
SynonymMTL_EAM_ASSET_NUM_INTERFACE