Wednesday, March 27, 2013

Item Category and Set Details

Your Ad Here

DISTINCT msi.segment1,
                   mcb.segment1 category_name,
  FROM apps.mtl_system_items msi,
       apps.mtl_category_sets mcst,
       apps.mtl_categories_b mcb,
       apps.mtl_item_categories mic
 WHERE     msi.inventory_item_id = mic.inventory_item_id
       AND mic.category_set_id = mcst.category_set_id
       AND mic.category_id = mcb.category_id
       AND msi.organization_id = mic.organization_id
       AND mcst.structure_id = mcb.structure_id
       AND msi.segment1 = '21138299'
Your Ad Here


  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

    Oracle Training
    Oracle Training Center in Chennai

  2. Hello!There is a on track hard drive recoverysoftware for you .You can find your lost memory,just in case !

  3. Can anyone say me what does the column Segment1, segment2, segment3 in MTL_CATEGORIES_B specify?? I want the PO category, PO subcategory and PO category description to display...Thanks in advance

  4. Wow, so thankful! I like your blog very much. By the way, you can choose some discount ray ban sunglasses here.

  5. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.

  6. Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
    erp in chennai

  7. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site."Oracle Training in Bangalore"

  8. Impressive! The content found on this blog is really amazing, I'll be browsing around more! By the way, if you need to register a business, I know the best singapore company incorporation! register a business immediately!