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
/