[Home] [Help]
VIEW: APPS.PMI_WHSE_CLS_LOV_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 )