Monday, October 03, 2011

inv item categories and iproc 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

No comments: