ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D818E84DCF9BE06362FB0905CAA3 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 Y US INV Item Attributes