Product: | INV - Inventory |
---|---|
Description: | View for EAM Asset Routes |
Implementation/DBA Data: | APPS.MTL_EAM_NETWORK_ASSETS_V |
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