ITEM CATEGORY QUERY

select a.segment1 ITEM_ID,
       a.INVENTORY_ITEM_STATUS_CODE ,
     --  a.attribute20 NPC,
       b.CONCATENATED_SEGMENTS CATEGORY
  from mtl_system_items_b a,
       mtl_categories_kfv b,
       mtl_item_categories c
       where c.inventory_item_id = a.inventory_item_id
       and c.category_id = b.category_id
      -- and a.attribute20 = 'GNU'
      and a.organization_id =c.organization_id
     and a.organization_id = 86
     and b.CONCATENATED_SEGMENTS like '%PP%'
    and a.INVENTORY_ITEM_STATUS_CODE = 'Not 4 Sale'