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'

10 comments:

  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

    ReplyDelete
    Replies
    1. 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. Hello!There is a on track hard drive recoverysoftware for you .You can find your lost memory,just in case !

    ReplyDelete
  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

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

    ReplyDelete
  5. 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. Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
    erp in chennai

    ReplyDelete
  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"

    ReplyDelete
  8. 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. 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.