Query to determine reworkable Item

select * from mtl_item_categories a, mtl_category_sets b, mtl_categories c, mtl_system_items_b d

where a.organization_id = 101

and a.category_set_id = b.category_set_id

and b.category_set_name ='PERP-INV'

and a.category_id = c.category_id

and c.segment1= 'RW-Y'

and a.organization_id = d.organization_id

and a.inventory_item_id = d.inventory_item_id

order by d.segment1