Query to find item status attributes :

select

mis.inventory_item_status_code item_status,

mis.description,

mis.disable_date,

av.attribute_name,

av.attribute_value value

from mtl_item_status mis,

mtl_status_attribute_values av

where mis.inventory_item_status_code=

av.inventory_item_status_code

order by 1

/