VIEW: APPS.GR_ITEM_CODES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)