Skip to content

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

VIEW: INV.MTL_EAM_ASSET_NUM_INTERFACE#

Object Details
Object Name: MTL_EAM_ASSET_NUM_INTERFACE#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
SERIAL_NUMBER VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PARENT_SERIAL_NUMBER VARCHAR2 (30)
VENDOR_SERIAL_NUMBER VARCHAR2 (30)
VENDOR_LOT_NUMBER VARCHAR2 (30)
DESCRIPTIVE_TEXT VARCHAR2 (240)
CURRENT_ORGANIZATION_ID NUMBER

SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORIGINATION_DATE DATE

C_ATTRIBUTE1 VARCHAR2 (150)
C_ATTRIBUTE2 VARCHAR2 (150)
C_ATTRIBUTE3 VARCHAR2 (150)
C_ATTRIBUTE4 VARCHAR2 (150)
C_ATTRIBUTE5 VARCHAR2 (150)
C_ATTRIBUTE6 VARCHAR2 (150)
C_ATTRIBUTE7 VARCHAR2 (150)
C_ATTRIBUTE8 VARCHAR2 (150)
C_ATTRIBUTE9 VARCHAR2 (150)
C_ATTRIBUTE10 VARCHAR2 (150)
C_ATTRIBUTE11 VARCHAR2 (150)
C_ATTRIBUTE12 VARCHAR2 (150)
C_ATTRIBUTE13 VARCHAR2 (150)
C_ATTRIBUTE14 VARCHAR2 (150)
C_ATTRIBUTE15 VARCHAR2 (150)
C_ATTRIBUTE16 VARCHAR2 (150)
C_ATTRIBUTE17 VARCHAR2 (150)
C_ATTRIBUTE18 VARCHAR2 (150)
C_ATTRIBUTE19 VARCHAR2 (150)
C_ATTRIBUTE20 VARCHAR2 (150)
D_ATTRIBUTE1 DATE

D_ATTRIBUTE2 DATE

D_ATTRIBUTE3 DATE

D_ATTRIBUTE4 DATE

D_ATTRIBUTE5 DATE

D_ATTRIBUTE6 DATE

D_ATTRIBUTE7 DATE

D_ATTRIBUTE8 DATE

D_ATTRIBUTE9 DATE

D_ATTRIBUTE10 DATE

N_ATTRIBUTE1 NUMBER

N_ATTRIBUTE2 NUMBER

N_ATTRIBUTE3 NUMBER

N_ATTRIBUTE4 NUMBER

N_ATTRIBUTE5 NUMBER

N_ATTRIBUTE6 NUMBER

N_ATTRIBUTE7 NUMBER

N_ATTRIBUTE8 NUMBER

N_ATTRIBUTE9 NUMBER

N_ATTRIBUTE10 NUMBER

STATUS_ID NUMBER

TERRITORY_CODE VARCHAR2 (30)
TIME_SINCE_NEW NUMBER

CYCLES_SINCE_NEW NUMBER

TIME_SINCE_OVERHAUL NUMBER

CYCLES_SINCE_OVERHAUL NUMBER

TIME_SINCE_REPAIR NUMBER

CYCLES_SINCE_REPAIR NUMBER

TIME_SINCE_VISIT NUMBER

CYCLES_SINCE_VISIT NUMBER

TIME_SINCE_MARK NUMBER

CYCLES_SINCE_MARK NUMBER

WIP_ACCOUNTING_CLASS_CODE VARCHAR2 (10)
MAINTAINABLE_FLAG VARCHAR2 (1)
OWNING_DEPARTMENT_ID NUMBER

NETWORK_ASSET_FLAG VARCHAR2 (1)
FA_ASSET_ID NUMBER

PN_LOCATION_ID NUMBER

EAM_LOCATION_ID NUMBER

ASSET_CRITICALITY_CODE VARCHAR2 (30)
CATEGORY_ID NUMBER

INTERFACE_GROUP_ID NUMBER

INTERFACE_HEADER_ID NUMBER
Yes
BATCH_ID NUMBER

ERROR_CODE NUMBER

ERROR_MESSAGE VARCHAR2 (240)
ORGANIZATION_CODE VARCHAR2 (3)
EQP_SERIAL_NUMBER VARCHAR2 (30)
EQUIPMENT_ITEM_ID NUMBER

PROD_ORGANIZATION_ID NUMBER

FA_ASSET_NUMBER VARCHAR2 (15)
LOCATION_CODES VARCHAR2 (30)
PROCESS_FLAG VARCHAR2 (1)
IMPORT_MODE NUMBER
Yes
IMPORT_SCOPE NUMBER
Yes
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
ASSET_CRITICALITY_ID NUMBER

CURRENT_STATUS NUMBER

PROD_ORGANIZATION_CODE VARCHAR2 (3)
PARENT_INVENTORY_ITEM_ID NUMBER

BATCH_NAME VARCHAR2 (30)
INSTANCE_NUMBER VARCHAR2 (30)
ACTIVE_START_DATE DATE

ACTIVE_END_DATE DATE

PARENT_INSTANCE_NUMBER VARCHAR2 (30)
SUPPLIER_WARRANTY_EXP_DATE DATE

OPERATIONAL_LOG_FLAG VARCHAR2 (1)
CHECKIN_STATUS NUMBER

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# references the following:

SchemaINV
TableMTL_EAM_ASSET_NUM_INTERFACE
INV.MTL_EAM_ASSET_NUM_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMTL_EAM_ASSET_NUM_INTERFACE