Query to find item Category in oracle apps r12


Here below is the detail sql query to find the item category value in oracle apps.

select MSB.segment1 ITEM_CODE,
  MSB.DESCRIPTION ITEM_DESCRIPTION,
     MCST.category_set_name,
       MCK.CONCATENATED_SEGMENTS CATEGORY
  from apps.mtl_system_items_b MSB,
       apps.mtl_categories_kfv MCK,
       apps.mtl_item_categories MIC,
        apps.mtl_category_sets_tl MCST
       where MIC.inventory_item_id = MSB.inventory_item_id
       and MIC.category_id = MCK.category_id
      and MSB.organization_id =MIC.organization_id
     and MSB.organization_id = :P_INV_ORGANIZATION
     and MCST.category_set_id=MIC.category_set_id