Table: MTH_ASSET_MST | Oracle EBS ETRM Search

Table: MTH_ASSET_MST 12.2.2

owner MTH·MTH - Oracle Manufacturing Operations Center·34 columns

This table stores information about assets. It holds information like Asset Number, Asset Group, Maintenance Organization code and other asset attributes.

MTH.MTH_ASSET_MST·Explore MTH module →

Table: MTL_SERIAL_NUMBERS 12.2.2 hub

owner INV·INV - Inventory·187 columns

Serial number definitions

INV.MTL_SERIAL_NUMBERS·Explore INV module →

View: MTL_EAM_ASSET_NUMBERS_V 12.1.1

INV - Inventory·68 columns

View for Asset Numbers

APPS.MTL_EAM_ASSET_NUMBERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CSI_I_ASSETS·Explore INV module →

View: MTL_EAM_ASSET_NUMBERS_V 12.2.2

INV - Inventory·68 columns

View for Asset Numbers

APPS.MTL_EAM_ASSET_NUMBERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CSI_I_ASSETS·Explore INV module →

View: MTL_EAM_ASSET_NUM_INTERFACE_V 12.2.2

INV - Inventory·55 columns

Asset Number Interface View

APPS.MTL_EAM_ASSET_NUM_INTERFACE_V·↳ BOM_DEPARTMENTS·↳ EAM_COMMON_UTILITIES_PVT·↳ MFG_LOOKUPS·Explore INV module →

View: EAM_CHECKED_OUT_ASSETS_V 12.2.2

EAM - Enterprise Asset Management·124 columns

This view provides information of all Checked Out Assets which is used by Oracle Service Management/Depot Repair product.

APPS.EAM_CHECKED_OUT_ASSETS_V·↳ CSI_ITEM_INSTANCES·↳ EAM_ASSET_OPERATION_TXN·↳ MTL_PARAMETERS·Explore EAM module →

View: MTL_EAM_ASSET_NUMBERS_ALL_V 12.2.2

INV - Inventory·114 columns

View for Asset Number details

APPS.MTL_EAM_ASSET_NUMBERS_ALL_V·↳ BOM_DEPARTMENTS·↳ CSI_GIS_INSTANCE_LOC_UTL_PKG·↳ CSI_II_GEOLOCATIONS·Explore INV module →

Table: MTL_EAM_ASSET_NUM_INTERFACE 12.1.1 standalone

owner INV·INV - Inventory·106 columns

Asset Number Interface table

INV.MTL_EAM_ASSET_NUM_INTERFACE·Explore INV module →

Table: CSI_INSTANCE_INTERFACE 12.2.2 standalone

owner CSI·CSI - Install Base·245 columns

Open Interface Instance Interface

CSI.CSI_INSTANCE_INTERFACE·Explore CSI module →

View: MTL_EAM_ASSET_NUM_INTERFACE_V 12.1.1

INV - Inventory·55 columns

Asset Number Interface View

APPS.MTL_EAM_ASSET_NUM_INTERFACE_V·↳ BOM_DEPARTMENTS·↳ EAM_COMMON_UTILITIES_PVT·↳ MFG_LOOKUPS·Explore INV module →

View: MTL_EAM_ASSET_REBUILDS_DTLS_V 12.1.1

INV - Inventory·83 columns

View shows the details of Assets and Rebuilds.

APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CSI_I_ASSETS·Explore INV module →

View: MTL_EAM_ASSET_REBUILDS_DTLS_V 12.2.2

INV - Inventory·83 columns

View shows the details of Assets and Rebuilds.

APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CSI_I_ASSETS·Explore INV module →

View: MTL_EAM_ASSET_NUMBERS_ALL_V 12.1.1

INV - Inventory·99 columns

View for Asset Number details

APPS.MTL_EAM_ASSET_NUMBERS_ALL_V·↳ BOM_DEPARTMENTS·↳ CSI_GIS_INSTANCE_LOC_UTL_PKG·↳ CSI_II_GEOLOCATIONS·Explore INV module →

Table: CSI_INSTANCE_INTERFACE 12.1.1 standalone

owner CSI·CSI - Install Base·245 columns

Open Interface Instance Interface

CSI.CSI_INSTANCE_INTERFACE·Explore CSI module →

Table: MTL_EAM_ASSET_NUM_INTERFACE 12.2.2 standalone

owner INV·INV - Inventory·106 columns

Asset Number Interface table

INV.MTL_EAM_ASSET_NUM_INTERFACE·Explore INV module →

Table: CSI_ITEM_INSTANCES 12.2.2 hub

owner CSI·CSI - Install Base·121 columns

Item Instance details.

CSI.CSI_ITEM_INSTANCES·Explore CSI module →

Table: CSI_ITEM_INSTANCES 12.1.1 hub

owner CSI·CSI - Install Base·121 columns

Item Instance details.

CSI.CSI_ITEM_INSTANCES·Explore CSI module →

Table: MTL_SERIAL_NUMBERS 12.1.1 hub

owner INV·INV - Inventory·187 columns

Serial number definitions

INV.MTL_SERIAL_NUMBERS·Explore INV module →

MATERIALIZED VIEW: APPS.ISC_MAINT_001_MV 12.1.1

VIEW: MTH.MTH_ASSET_MST# 12.2.2

TABLE: APPS.ISC_MAINT_001_MV 12.1.1

TABLE: ISC.MLOG$_ISC_MAINT_ASSET_DOWN 12.1.1

owner ISC

VIEW: MTH.MTH_ASSET_MST# 12.2.2

owner MTH

MATERIALIZED VIEW: APPS.ISC_MAINT_001_MV 12.1.1

VIEW: INV.MTL_EAM_ASSET_NUM_INTERFACE# 12.2.2

VIEW: CSI.CSI_ITEM_INSTANCES# 12.2.2

TABLE: ISC.ISC_MAINT_ASSET_DOWN_F 12.1.1

owner ISC

VIEW: APPS.MTL_EAM_ASSET_NUM_INTERFACE_V 12.1.1

VIEW: APPS.MTL_EAM_ASSET_NUM_INTERFACE_V 12.2.2

TABLE: MTH.MTH_ASSET_MST 12.2.2

owner MTH

PACKAGE BODY: APPS.ISC_MAINT_ASSET_DT_ETL_PKG 12.1.1

VIEW: INV.MTL_EAM_ASSET_NUM_INTERFACE# 12.2.2

owner INV

PACKAGE: APPS.ISC_MAINT_ASSET_DT_ETL_PKG 12.1.1

VIEW: APPS.MTL_EAM_ASSET_NUMBERS_V 12.1.1

VIEW: APPS.MTL_EAM_ASSET_NUMBERS_V 12.2.2

VIEW: INV.MTL_SERIAL_NUMBERS# 12.2.2

VIEW: APPS.MTL_EAM_ASSET_NUM_INTERFACE_V 12.2.2

APPS.ISC_MAINT_ASSET_DT_ETL_PKG SQL Statements 12.1.1

APPS.ISC_MAINT_ASSET_DT_RPT_PKG SQL Statements 12.1.1

VIEW: APPS.MTL_EAM_ASSET_NUM_INTERFACE_V 12.1.1

VIEW: CSI.CSI_INSTANCE_INTERFACE# 12.2.2

VIEW: APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V 12.1.1

VIEW: APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V 12.2.2