Mapping between Inventory item categories and i procurement item categories

Below query gives Mapping between inv item categories and iproc item categories using mapping table ICX_POR_CATEGORY_ORDER_MAP

SELECT

MC . SEGMENT1 ,

MC . DESCRIPTION ,

MCT . CATEGORY_ID ,

ICCT . CATEGORY_NAME ,

ICCT . RT_CATEGORY_ID

FROM 

MTL_CATEGORIES_TL MCT ,

MTL_CATEGORIES_KFV MCK ,

ICX_POR_CATEGORY_ORDER_MAP IPCO ,

ICX_CAT_CATEGORIES_TL ICCT ,

MTL_CATEGORIES MC ,

MTL_CATEGORY_SET_VALID_CATS mcsv

WHERE MCT . CATEGORY_ID = MCK . CATEGORY_ID

AND MCT . CATEGORY_ID = MC . CATEGORY_ID

AND mct . CATEGORY_ID = mcsv . CATEGORY_ID

AND IPCO . EXTERNAL_SOURCE_KEY = MCK . CATEGORY_ID

AND ICCT . RT_CATEGORY_ID = IPCO . RT_CATEGORY_ID