VIEW: APPS.PMI_WHSE_CLS_V

Source

View Text - Preformatted

SELECT distinct item_id,item_no,item_desc1 FROM ic_item_mst WHERE item_id IN (SELECT whse_item_id FROM ic_item_mst )

View Text - HTML Formatted

SELECT DISTINCT ITEM_ID
, ITEM_NO
, ITEM_DESC1
FROM IC_ITEM_MST
WHERE ITEM_ID IN (SELECT WHSE_ITEM_ID
FROM IC_ITEM_MST )