VIEW: APPS.MTL_EAM_NETWORK_ASSETS_V

Source

View Text - Preformatted

SELECT mena.rowid row_id, mena.network_association_id, route.inventory_item_id network_item_id, route.serial_number network_serial_number, route.instance_number network_asset_number, mena.network_object_type, mena.network_object_id, mena.maintenance_object_type, mena.maintenance_object_id, child.inventory_item_id inventory_item_id, child.serial_number serial_number, child.instance_number asset_number, mena.start_date_active, mena.end_date_active, mena.last_update_date, mena.last_updated_by, mena.creation_date, mena.created_by, mena.last_update_login, mena.attribute_category, mena.attribute1, mena.attribute2, mena.attribute3, mena.attribute4, mena.attribute5, mena.attribute6, mena.attribute7, mena.attribute8, mena.attribute9, mena.attribute10, mena.attribute11, mena.attribute12, mena.attribute13, mena.attribute14, mena.attribute15, mena.request_id, mena.program_application_id, mena.program_id, mena.program_update_date, mp1.maint_organization_id organization_id, mp2.maint_organization_id, (SELECT msi.concatenated_segments FROM mtl_system_items_b_kfv msi WHERE msi.inventory_item_id = mena.inventory_item_id AND rownum = 1) as asset_group FROM mtl_eam_network_assets mena, csi_item_instances route, csi_item_instances child, mtl_parameters mp1, mtl_parameters mp2 WHERE mena.network_object_id = route.instance_id AND mena.network_object_type = 3 AND mena.maintenance_object_id = child.instance_id AND mena.maintenance_object_type = 3 AND route.last_vld_organization_id = mp1.organization_id AND child.last_vld_organization_id = mp2.organization_id

View Text - HTML Formatted

SELECT MENA.ROWID ROW_ID
, MENA.NETWORK_ASSOCIATION_ID
, ROUTE.INVENTORY_ITEM_ID NETWORK_ITEM_ID
, ROUTE.SERIAL_NUMBER NETWORK_SERIAL_NUMBER
, ROUTE.INSTANCE_NUMBER NETWORK_ASSET_NUMBER
, MENA.NETWORK_OBJECT_TYPE
, MENA.NETWORK_OBJECT_ID
, MENA.MAINTENANCE_OBJECT_TYPE
, MENA.MAINTENANCE_OBJECT_ID
, CHILD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CHILD.SERIAL_NUMBER SERIAL_NUMBER
, CHILD.INSTANCE_NUMBER ASSET_NUMBER
, MENA.START_DATE_ACTIVE
, MENA.END_DATE_ACTIVE
, MENA.LAST_UPDATE_DATE
, MENA.LAST_UPDATED_BY
, MENA.CREATION_DATE
, MENA.CREATED_BY
, MENA.LAST_UPDATE_LOGIN
, MENA.ATTRIBUTE_CATEGORY
, MENA.ATTRIBUTE1
, MENA.ATTRIBUTE2
, MENA.ATTRIBUTE3
, MENA.ATTRIBUTE4
, MENA.ATTRIBUTE5
, MENA.ATTRIBUTE6
, MENA.ATTRIBUTE7
, MENA.ATTRIBUTE8
, MENA.ATTRIBUTE9
, MENA.ATTRIBUTE10
, MENA.ATTRIBUTE11
, MENA.ATTRIBUTE12
, MENA.ATTRIBUTE13
, MENA.ATTRIBUTE14
, MENA.ATTRIBUTE15
, MENA.REQUEST_ID
, MENA.PROGRAM_APPLICATION_ID
, MENA.PROGRAM_ID
, MENA.PROGRAM_UPDATE_DATE
, MP1.MAINT_ORGANIZATION_ID ORGANIZATION_ID
, MP2.MAINT_ORGANIZATION_ID
, (SELECT MSI.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE MSI.INVENTORY_ITEM_ID = MENA.INVENTORY_ITEM_ID
AND ROWNUM = 1) AS ASSET_GROUP
FROM MTL_EAM_NETWORK_ASSETS MENA
, CSI_ITEM_INSTANCES ROUTE
, CSI_ITEM_INSTANCES CHILD
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
WHERE MENA.NETWORK_OBJECT_ID = ROUTE.INSTANCE_ID
AND MENA.NETWORK_OBJECT_TYPE = 3
AND MENA.MAINTENANCE_OBJECT_ID = CHILD.INSTANCE_ID
AND MENA.MAINTENANCE_OBJECT_TYPE = 3
AND ROUTE.LAST_VLD_ORGANIZATION_ID = MP1.ORGANIZATION_ID
AND CHILD.LAST_VLD_ORGANIZATION_ID = MP2.ORGANIZATION_ID