View: ICX_NONSHIP_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:	Non Shippable Items View
Implementation/DBA Data:	APPS.ICX_NONSHIP_ITEMS_V

View Text

SELECT DISTINCT MSI.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MSI.ORGANIZATION_ID
, MSI.SHIPPABLE_ITEM_FLAG
, PLS.NAME
, PLS.PRICE_LIST_ID
, PLL.PRICE_LIST_LINE_ID
FROM MTL_SYSTEM_ITEMS_KFV MSI
, SO_PRICE_LIST_LINES PLL
, SO_PRICE_LISTS PLS
WHERE MSI.SHIPPABLE_ITEM_FLAG = 'N'
AND MSI.INVENTORY_ITEM_ID = PLL.INVENTORY_ITEM_ID
AND PLL.PRICE_LIST_ID = PLS.PRICE_LIST_ID

Columns