ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL2

select
x.*
from
(
SELECT eesmt.ecc_spec_id,mcikfv.concatenated_segments item_category
    FROM mtl_item_categories mci,mtl_categories_kfv mcikfv,eam_ecc_stores_mat_temp eesmt
    WHERE mci.inventory_item_id = eesmt.inventory_item_id
    AND mci.organization_id = eesmt.organization_id
    AND mci.category_id = mcikfv.category_id
) x
where
2=2