View: GR_ITEM_REPORT_V1

Product:	GR - Process Manufacturing Regulatory Management
Description:	View of valid Regulatory Items which can be used for Reports.
Implementation/DBA Data:	APPS.GR_ITEM_REPORT_V1

View Text

SELECT ITEM_NO
, ITEM_DESC1
FROM IC_ITEM_MST UNION ALL SELECT L.ITEM_CODE ITEM_NO
, NAME_DESCRIPTION ITEM_DESC1
FROM GR_ITEM_GENERAL L
, GR_MULTILINGUAL_NAME_TL M
WHERE M.ITEM_CODE (+) = L.ITEM_CODE
AND M.LABEL_CODE (+) = '11007'
AND M.LANGUAGE (+) = USERENV('LANG')
AND L.ITEM_CODE NOT IN (SELECT ITEM_NO
FROM IC_ITEM_MST) ORDER BY 1

Columns