Query to get item attributes NOT under status control :

select meaning1 attrib_group,user_attribute_name_gui,
-- ,control_level, status_control_code,attribute_name,
-- attribute_group_id,data_type,
-- user_attribute_name,level_updateable_flag,
-- validation_code ,lookup_type1,
-- lookup_code1,enabled_flag1,lookup_type2,lookup_code2,
meaning2 control_level,
-- ,enabled_flag2,
-- lookup_type3,lookup_code3,
meaning3 status_control,
-- enabled_flag3,lookup_type4,lookup_code4,
meaning4 validation
-- ,enabled_flag4
from
mtl_item_attributes_v
where control_level in (1,2)
and status_control_code is null
and user_attribute_name_gui is not null
and attribute_name in (
select attribute_name from mtl_item_attr_appl_inst_v )
order by
attribute_group_id_gui, sequence_gui
/