Search from 700 + Posts

Mar 29, 2013

Query to get Item Categories


Query to get Item Categories

SELECT MCB.*
    FROM
        MTL_CATEGORY_SETS_TL CST,
        MTL_ITEM_CATEGORIES MIC,
        MTL_CATEGORIES_B MCB
    WHERE  MIC.CATEGORY_ID = MCB.CATEGORY_ID
    AND MIC.CATEGORY_SET_ID = CST.CATEGORY_SET_ID
    AND MIC.ORGANIZATION_ID = 0
    AND CST.CATEGORY_SET_NAME =  '&item_category_name'
   AND MIC.INVENTORY_ITEM_ID = DL.INVENTORY_ITEM_ID;

No comments:

Post a Comment