View: GR_ALL_ITEMS_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	View of ITEM CODE + DESCRIPTION
Implementation/DBA Data:	APPS.GR_ALL_ITEMS_V

View Text

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

Columns