Wednesday, March 27, 2013

Item Category and Set Details



SELECT
DISTINCT msi.segment1,
                   msi.item_type,
                   mcb.segment1 category_name,
                   mcst.category_set_name,
                   msi.comms_nl_trackable_flag,
                   msi.serviceable_product_flag
  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'
Posted by at

10 comments:

  1. UnknownAugust 27, 2015 at 3:40 PM

    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

    ReplyDelete
    Replies
    1. Pavel Co EbeleMarch 28, 2018 at 5:43 PM

      Thanks for the post, I am techno savvy. I believe you hit the nail right on the head. I am highly impressed with your blog. It is very nicely explained. Your article adds best knowledge to our Java Online Training from India. or learn thru Java Online Training from India Students.

      Delete
  2. asbdioMay 10, 2016 at 10:40 AM

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

    ReplyDelete
  3. AnonymousMay 20, 2016 at 11:52 AM

    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

    ReplyDelete
  4. AnonymousJuly 18, 2016 at 2:53 PM

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

    ReplyDelete
  5. UnknownAugust 1, 2016 at 9:26 AM

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  6. UnknownMarch 22, 2017 at 12:10 PM

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

    ReplyDelete
  7. UnknownNovember 27, 2017 at 1:06 PM

    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"

    ReplyDelete
  8. UnknownMarch 22, 2018 at 11:27 AM

    Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks; from every one of us.


    white label website builder

    mobile website builder

    ReplyDelete
  9. lotusMarch 30, 2018 at 6:14 PM

    Very good and informative article. Thanks for sharing such nice article, keep on updating.
    Best VMware Training Institute in Chennai | Best VMware Training Institute in Velachery

    ReplyDelete

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)