View: MTL_ITEM_ATTRIBUTE_NAMES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_ATTRIBUTE_NAMES_V

View Text

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

Columns