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'

4 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
  2. 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
  3. 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
  4. 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.