[Home] [Help]
View: PMI_WHSE_CLS_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | Warehouse Class view |
Implementation/DBA Data: |
APPS.PMI_WHSE_CLS_V
|
View Text
SELECT DISTINCT ITEM_ID
, ITEM_NO
, ITEM_DESC1 FROM IC_ITEM_MST
WHERE ITEM_ID IN (SELECT WHSE_ITEM_ID
FROM IC_ITEM_MST )
Columns
Name |
ITEM_ID |
ITEM_NO |
ITEM_DESC1 |