INV Item Attributes

select
xxen_util.meaning(mia.attribute_group_id_gui,'ITEM_CHOICES_GUI',700) attribute_group_gui,
mia.user_attribute_name_gui,
mia.sequence_gui,
--
mia.attribute_name,
miasi.attribute_code,
mia.data_type,
mia.mandatory_flag,
--
-- Control Level:  1 = Item, 2 = Item/Organization, 3 = Viewable
-- Status Control Code: 1 = Under status control, 2 = Default control, 3 = No status control
-- Item Attribute Validation: 1 = No QuickPick, 2 = QuickPick with hidden code, 3 = QuickPick with no hidden code, 4 = Y/N QuickPick, 5 = Flexfield
--
mia.control_level,
xxen_util.meaning(nvl(mia.control_level,-999),'ITEM_CONTROL_LEVEL',700) control_level_dsp,
case mia.control_level when 1 then 'Master Level' when 2 then 'Org Level' else null end controlled_at_form,
mia.status_control_code,
xxen_util.meaning(nvl(mia.status_control_code,-999),'ITEM_STATUS_CONTROL',700) status_control_dsp,
case mia.control_level when 1 then 'Sets Value' when 2 then 'Defaults Value' when 3 then 'Not Used' else null end status_setting_form,
xxen_util.meaning(nvl(mia.validation_code,-999),'ITEM_ATTRIBUTE_VALIDATION',700) validation,
--
case
when mia.control_level in (1,2)
and  mia.status_control_code is null
and  mia.user_attribute_name_gui is not null
and  mia.attribute_name in (select miaaiv.attribute_name from mtl_item_attr_appl_inst_v miaaiv)
then 'Item Attribute'
when mia.control_level in (1,2)
and  mia.status_control_code is not null
and  mia.user_attribute_name_gui is not null
and  mia.attribute_name in (select miaaiv.attribute_name from mtl_item_attr_appl_inst_v miaaiv)
then 'Status Control'
else 'Excluded'
end form_group,
(select 'Y' from mtl_item_attr_appl_inst_v miaaiv where miaaiv.attribute_name = mia.attribute_name) installed_flag
from
mtl_item_attributes mia,
mtl_item_attributes_seed_info miasi
where
     substr(mia.attribute_name,18) = miasi.attribute_code (+)
order by
mia.attribute_group_id_gui,
mia.user_attribute_name_gui nulls last,
mia.sequence_gui