SELECT MIA.ATTRIBUTE_NAME , MIA.USER_ATTRIBUTE_NAME_GUI , MIA.ATTRIBUTE_GROUP_ID_GUI , MFG.MEANING , MIA.SEQUENCE_GUI FROM MTL_ITEM_ATTRIBUTES MIA , MFG_LOOKUPS MFG WHERE MFG.LOOKUP_TYPE = 'ITEM_CHOICES_GUI' AND MFG.LOOKUP_CODE = MIA.ATTRIBUTE_GROUP_ID_GUI AND USER_ATTRIBUTE_NAME_GUI IS NOT NULL