Query to Get Inventory Category Set Category Details for Item

SELECT DISTINCT msi.inventory_item_id inventory_item_id,
                msi.segment1 item_number,
                msi.description,
                msi.primary_uom_code primary_uom_code,
                msi.item_type,
                msi.organization_id organization_id,
                ood.organization_code organization_code,
                catsl.category_set_name,
                cat.segment1 family,
                cat.segment2 class,
                cat.segment3 TYPE
  FROM mtl_system_items msi,
       org_organization_definitions ood,
       inv.mtl_categories_b cat,
       inv.mtl_categories_tl cat1,
       inv.mtl_item_categories icat,
       inv.mtl_category_sets_tl catsl
 WHERE     msi.organization_id = ood.organization_id
       AND msi.inventory_item_id = icat.inventory_item_id
       AND icat.category_id = cat.category_id
       AND msi.organization_id = icat.organization_id
       AND icat.category_set_id = catsl.category_set_id
       AND catsl.category_set_id = 1
       AND cat.category_id = cat1.category_id
       -- AND msi.inventory_item_id = 662679
       AND msi.segment1 LIKE 'XRQLFB%'
       AND ood.organization_code = 'MAS';


Thanks
Amar Alam