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

Source

View Text - Preformatted


SELECT I.SEGMENT1 ITEM_CODE, I.DESCRIPTION DESCRIPTION FROM MTL_SYSTEM_ITEMS I, HR_ALL_ORGANIZATION_UNITS O WHERE I.ENABLED_FLAG = 'Y' AND I.SEGMENT1 NOT IN (SELECT ITEM_CODE FROM GR_ITEM_GENERAL) AND I.ORGANIZATION_ID = O.ORGANIZATION_ID AND O.NAME = FND_PROFILE.Value('GR_WHSE_DEFAULT') UNION SELECT ITEM_CODE ITEM_CODE, NAME_DESCRIPTION DESCRIPTION FROM GR_MULTILINGUAL_NAME_TL WHERE LABEL_CODE = '11007' AND LANGUAGE = USERENV('LANG') ORDER BY 1

View Text - HTML Formatted

SELECT I.SEGMENT1 ITEM_CODE
, I.DESCRIPTION DESCRIPTION
FROM MTL_SYSTEM_ITEMS I
, HR_ALL_ORGANIZATION_UNITS O
WHERE I.ENABLED_FLAG = 'Y'
AND I.SEGMENT1 NOT IN (SELECT ITEM_CODE
FROM GR_ITEM_GENERAL)
AND I.ORGANIZATION_ID = O.ORGANIZATION_ID
AND O.NAME = FND_PROFILE.VALUE('GR_WHSE_DEFAULT') UNION SELECT ITEM_CODE ITEM_CODE
, NAME_DESCRIPTION DESCRIPTION
FROM GR_MULTILINGUAL_NAME_TL
WHERE LABEL_CODE = '11007'
AND LANGUAGE = USERENV('LANG') ORDER BY 1