View: GR_ITEM_CODES_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	Contains the Item Code Description in GR_ITEM_GENERAL & IC_ITEM_MST
Implementation/DBA Data:	APPS.GR_ITEM_CODES_V

View Text

SELECT NVL(A.ITEM_DESC1
, 'REGULATORY ITEM')
, B.ITEM_CODE
FROM IC_ITEM_MST A
, GR_ITEM_GENERAL B
WHERE A.ITEM_NO = B.ITEM_CODE (+)

Columns