VIEW: APPS.ICX_NONSHIP_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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