[Home] [Help]
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
Name |
INVENTORY_ITEM_ID |
ITEM_DESCRIPTION |
ORGANIZATION_ID |
SHIPPABLE_ITEM_FLAG |
PRICE_LIST_NAME |
PRICE_LIST_ID |
PRICE_LIST_LINE_ID |