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.OKI_PROD_OLTP_V

Source

View Text - Preformatted


SELECT STAR.INVENTORY_ITEM_ID , DECODE( STAR.ORGANIZATION_ID, -99, TO_NUMBER(NULL), STAR.ORGANIZATION_ID ) ORGANIZATION_ID , STAR.VALUE ITEM_NAME , DECODE( STAR.INVENTORY_ITEM_ID, -1, FLV.DESCRIPTION, MTI_TL.DESCRIPTION ) ITEM_DESCRIPTION FROM ENI_OLTP_ITEM_STAR STAR , MTL_SYSTEM_ITEMS_TL MTI_TL , FND_LOOKUP_VALUES FLV WHERE STAR.INVENTORY_ITEM_ID = MTI_TL.INVENTORY_ITEM_ID AND STAR.ORGANIZATION_ID = MTI_TL.ORGANIZATION_ID AND MTI_TL.LANGUAGE = USERENV( 'LANG' ) AND FLV.LOOKUP_TYPE = 'ITEM' AND FLV.LOOKUP_CODE = '-1' AND FLV.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT STAR.INVENTORY_ITEM_ID
, DECODE( STAR.ORGANIZATION_ID
, -99
, TO_NUMBER(NULL)
, STAR.ORGANIZATION_ID ) ORGANIZATION_ID
, STAR.VALUE ITEM_NAME
, DECODE( STAR.INVENTORY_ITEM_ID
, -1
, FLV.DESCRIPTION
, MTI_TL.DESCRIPTION ) ITEM_DESCRIPTION
FROM ENI_OLTP_ITEM_STAR STAR
, MTL_SYSTEM_ITEMS_TL MTI_TL
, FND_LOOKUP_VALUES FLV
WHERE STAR.INVENTORY_ITEM_ID = MTI_TL.INVENTORY_ITEM_ID
AND STAR.ORGANIZATION_ID = MTI_TL.ORGANIZATION_ID
AND MTI_TL.LANGUAGE = USERENV( 'LANG' )
AND FLV.LOOKUP_TYPE = 'ITEM'
AND FLV.LOOKUP_CODE = '-1'
AND FLV.LANGUAGE = USERENV('LANG')