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_ACTIVITY_LVL_V

Source

View Text - Preformatted


SELECT STAR.ID id , STAR.VALUE value , null DESCRIPTION , STAR.INVENTORY_ITEM_ID , STAR.ORGANIZATION_ID FROM ENI_OLTP_ITEM_STAR STAR , mtl_system_items_b msi WHERE STAR.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND STAR.ORGANIZATION_ID = msi.ORGANIZATION_ID AND msi.eam_item_type = 2 /* Activity */ union all select '-1' id , fnd_message.get_string('BIS','BIS_UNASSIGNED') value , null description , null inventory_item_id , null organization_id from dual

View Text - HTML Formatted

SELECT STAR.ID ID
, STAR.VALUE VALUE
, NULL DESCRIPTION
, STAR.INVENTORY_ITEM_ID
, STAR.ORGANIZATION_ID
FROM ENI_OLTP_ITEM_STAR STAR
, MTL_SYSTEM_ITEMS_B MSI
WHERE STAR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND STAR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.EAM_ITEM_TYPE = 2 /* ACTIVITY */ UNION ALL SELECT '-1' ID
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_UNASSIGNED') VALUE
, NULL DESCRIPTION
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
FROM DUAL