Search 800 + 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;

2 comments:

  1. This blog is very much helpful to us. Thanks for your information

    Guest posting sites
    Technology

    ReplyDelete
  2. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete