View: EGO_ITEM_ATTRIBUTES_V

Product:	EGO - Advanced Product Catalog
Description:	View for getting the control levels of Item Attributes.
Implementation/DBA Data:	APPS.EGO_ITEM_ATTRIBUTES_V

View Text

SELECT C.USER_ATTRIBUTE_NAME_GUI ATTRIBUTE_DISP_NAME
, MFG1.MEANING CONTROL_LEVEL_MEANING
, MFG1.LOOKUP_CODE CONTROL_LEVEL_CODE
, C.ATTRIBUTE_NAME ATTRIBUTE_NAME
FROM MTL_ITEM_ATTRIBUTES C
, MFG_LOOKUPS MFG1
WHERE MFG1.LOOKUP_TYPE = 'ITEM_STATUS_CONTROL'
AND MFG1.LOOKUP_CODE = C.STATUS_CONTROL_CODE

Columns