View: EGO_STAT_ATTRIB_VALUES_V

Product:	EGO - Advanced Product Catalog
Description:	View for getting the status controlled attribute values for Item Attributes.
Implementation/DBA Data:	APPS.EGO_STAT_ATTRIB_VALUES_V

View Text

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

Columns