Hello all,
I'm a beginner with SQL, can someone tell me how I can add the CLASS subquery to the where clause? I want the user to pick a specific CLASS.
SELECT
DISTINCT (MSIB.SEGMENT1) ITEM_EBS,
MSIB.DESCRIPTION ITEM_DESC_EBS,
MSIB.ITEM_TYPE ITEM_TYPE_EBS,
(SELECT DISTINCT (MCB9.SEGMENT1)
FROM MTL_CATEGORY_SETS_TL CST9,
MTL_ITEM_CATEGORIES MIC9,
MTL_CATEGORIES_B MCB9
WHERE MIC9.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND MIC9.ORGANIZATION_ID =MSIB.ORGANIZATION_ID
AND MIC9.CATEGORY_ID = MCB9.CATEGORY_ID
AND MIC9.CATEGORY_SET_ID = CST9.CATEGORY_SET_ID
AND CST9.CATEGORY_SET_NAME LIKE ' CLASS'
) CLASS
FROM
.MTL_SYSTEM_ITEMS_B MSIB
WHERE
CLASS = X_CLASS--??