[Home] [Help]
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
Name |
ITEM_DESCRIPTION |
ITEM_CODE |