Results for “network_serial_number”
30 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.MTL_EAM_NETWORK_ASSETS_V is a reporting view in the Oracle E-Business Suite Inventory (INV) module that exposes Enterprise Asset Management (EAM) network asset route relationships. It is defined as a join between the EAM network association table and the enterprise asset instance data, resolving both the "network" (parent/route) asset and the "maintenance" (child) asset into human-readable inventory item, serial number, and instance number values. Because it consolidates network association metadata with asset identification, users who search on asset_group will find this view relevant: the asset group value is derived as a concatenated key flexfield segment from MTL_SYSTEM_ITEMS_B_KFV.
The view is commonly used for reporting, integrations, and extraction of asset routing hierarchies, and its output aligns with concurrent program context (it carries REQUEST_ID, PROGRAM_ID, and related audit columns for data created or spawned by EAM processes).
Underlying Base Objects
The view is defined over the following documented base objects in the APPS schema:
MTL_EAM_NETWORK_ASSETS(synonym) — the core EAM table storing the network association between a network object and a maintenance object.CSI_ITEM_INSTANCES(synonym) — the enterprise asset instance table, referenced twice: once aliased asROUTEfor the network/parent asset and once asCHILDfor the maintenance asset.MTL_PARAMETERS(synonym) — referenced twice (MP1,MP2) to resolve the maintenance organization of the route and child assets from their last valid organization.MTL_SYSTEM_ITEMS_B_KFV(view) — the key flexfield value view used in a scalar subquery to return the concatenated segments for theASSET_GROUPcolumn.
The join is restricted to network and maintenance object types equal to 3 (asset instances), ensuring only asset-to-asset route relationships are returned.
Key Columns
NETWORK_ASSOCIATION_ID— surrogate key of the underlying network association record.NETWORK_ITEM_ID,NETWORK_SERIAL_NUMBER,NETWORK_ASSET_NUMBER— the parent/route asset identity derived fromROUTE.INVENTORY_ITEM_ID,SERIAL_NUMBER,ASSET_NUMBER— the maintenance (child) asset identity derived fromCHILD.ASSET_GROUP— the concatenated segment description of the child asset's inventory item, resolved viaMTL_SYSTEM_ITEMS_B_KFV.NETWORK_OBJECT_TYPE,NETWORK_OBJECT_ID,MAINTENANCE_OBJECT_TYPE,MAINTENANCE_OBJECT_ID— raw association pointers.START_DATE_ACTIVE/END_DATE_ACTIVE— the active date range of the route association.ORGANIZATION_IDandMAINT_ORGANIZATION_ID— maintenance organization derived fromMTL_PARAMETERS.- EAM standard audit and DFF columns (
ATTRIBUTE_CATEGORY,ATTRIBUTE1–ATTRIBUTE15,CREATION_DATE,LAST_UPDATE_DATE,REQUEST_ID).
Common Use Cases and Queries
Typical uses include listing all maintenance assets routed under a given network asset, filtering by asset group, and extracting active route associations for integration.
Example — find assets by asset group:
SELECT network_asset_number, asset_number, serial_number, asset_group FROM mtl_eam_network_assets_v WHERE asset_group = :asset_group;
Example — active routes for an organization:
SELECT network_asset_number, asset_number FROM mtl_eam_network_assets_v WHERE organization_id = :org_id AND start_date_active <= SYSDATE AND (end_date_active IS NULL OR end_date_active >= SYSDATE);
Because ASSET_GROUP is produced by a scalar subquery limited with ROWNUM = 1, the value reflects item-level flexfield definition; callers should not depend on organization-specific item definition for this column.
-
View for EAM Asset Routes
APPS.MTL_EAM_NETWORK_ASSETS_V·↳ CSI_ITEM_INSTANCES·↳ MTL_EAM_NETWORK_ASSETS·↳ MTL_PARAMETERS·Explore INV module →
-
Table for association of assets to asset route.
-
View for EAM Asset Routes
APPS.MTL_EAM_NETWORK_ASSETS_V·↳ CSI_ITEM_INSTANCES·↳ MTL_EAM_NETWORK_ASSETS·↳ MTL_PARAMETERS·Explore INV module →
-
Table for association of assets to asset route.
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2