View: ICX_WEBSTORE_CATEGORIES_V

Product:	ICX - Oracle iProcurement
Description:	Web Store Category Page View
Implementation/DBA Data:	APPS.ICX_WEBSTORE_CATEGORIES_V

View Text

SELECT DISTINCT(MIC.CATEGORY_ID) CATEGORY_ID
, NVL( MC.DESCRIPTION
, MC.CONCATENATED_SEGMENTS)
, PLL.PRICE_LIST_ID
, MIC.CATEGORY_SET_ID
, MIC.ORGANIZATION_ID
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES_KFV MC
, SO_PRICE_LIST_LINES PLL
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MC.CATEGORY_ID = MIC.CATEGORY_ID
AND MSI.INVENTORY_ITEM_ID = PLL.INVENTORY_ITEM_ID
AND MSI.BOM_ITEM_TYPE IN (4
, 1)

Columns