SELECT MIC.ORGANIZATION_ID , MIC.INVENTORY_ITEM_ID , MIC.CATEGORY_ID , MCK.CONCATENATED_SEGMENTS CATEGORY_NAME , MIC.RN FROM MTL_CATEGORIES_KFV MCK , MRP_AP_ITEM_CATGS_SN MIC WHERE MCK.CATEGORY_ID= MIC.CATEGORY_ID AND EXISTS ( SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS MDCS WHERE MIC.CATEGORY_SET_ID= MDCS.CATEGORY_SET_ID AND MDCS.FUNCTIONAL_AREA_ID= 3 )