VIEW: APPS.ICX_WEBSTORE_CATEGORIES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)