eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIV_MAINT_ASSET_GROUP_LVL_V

Source

View Text - Preformatted


SELECT STAR.INVENTORY_ITEM_ID ID ,msi.concatenated_segments VALUE FROM ENI_OLTP_ITEM_STAR STAR , mtl_system_items_kfv msi WHERE STAR.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND STAR.ORGANIZATION_ID = msi.ORGANIZATION_ID AND msi.eam_item_type in (1,3) /* Asset Groups and rebuildable items */ GROUP BY STAR.INVENTORY_ITEM_ID ,msi.concatenated_segments union all select -1 id , fnd_message.get_string('BIS','BIS_UNASSIGNED') value from dual

View Text - HTML Formatted

SELECT STAR.INVENTORY_ITEM_ID ID
, MSI.CONCATENATED_SEGMENTS VALUE
FROM ENI_OLTP_ITEM_STAR STAR
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE STAR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND STAR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.EAM_ITEM_TYPE IN (1
, 3) /* ASSET GROUPS
AND REBUILDABLE ITEMS */ GROUP BY STAR.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS UNION ALL SELECT -1 ID
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_UNASSIGNED') VALUE
FROM DUAL