View: EGO_ITEM_MAIN_ATTRS_V

Product:	EGO - Advanced Product Catalog
Description:	View for getting the Primary Item Attributes
Implementation/DBA Data:	APPS.EGO_ITEM_MAIN_ATTRS_V

View Text

SELECT TO_CHAR(B.ATTRIBUTE_GROUP_ID_GUI) ATTRIBUTE_GROUP_ID
, DECODE(B.ATTRIBUTE_GROUP_ID_GUI
, 20
, 'MAIN'
, 'ERROR') ATTRIBUTE_GROUP_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, B.USER_ATTRIBUTE_NAME_GUI ATTRIBUTE_DISPLAY_NAME
, B.SEQUENCE_GUI GUI_SEQUENCE_NUM
FROM MTL_ITEM_ATTR_APPL_INST_V A
, MTL_ITEM_ATTRIBUTES_V B
WHERE B.ATTRIBUTE_GROUP_ID_GUI = 20
AND A.ATTRIBUTE_NAME = B.ATTRIBUTE_NAME
AND A.ATTRIBUTE_NAME NOT IN ('MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL'
, 'MTL_SYSTEM_ITEMS.DESC_FLEX'
, 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION')
AND CONTROL_LEVEL IN (1
, 2) UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 21 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_CATALOG_GROUP'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.LIFECYCLE_ID' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 22 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_LIFECYCLE'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.CURRENT_PHASE_ID' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 23 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_LIFECYCLE_PHASE'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.APPROVAL_STATUS' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 24 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_APPROVAL_STATUS'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.TRADE_ITEM_DESCRIPTOR' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 25 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_TRADE_ITEM_DESCRIPTOR'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.STYLE_ITEM_FLAG' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 26 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_STYLE_FLAG'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.STYLE_ITEM_ID' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 27 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_STYLE_ITEM'
AND MSG.LANGUAGE_CODE = USERENV('LANG') UNION SELECT '20' ATTRIBUTE_GROUP_ID
, 'MAIN' ATTRIBUTE_GROUP_NAME
, 'MTL_SYSTEM_ITEMS.ITEM_DETAIL_LINK' ATTRIBUTE_NAME
, MSG.MESSAGE_TEXT ATTRIBUTE_DISPLAY_NAME
, 28 GUI_SEQUENCE_NUM
FROM FND_NEW_MESSAGES MSG
WHERE MSG.MESSAGE_NAME = 'EGO_ITEM_DETAIL'
AND MSG.LANGUAGE_CODE = USERENV('LANG') ORDER BY GUI_SEQUENCE_NUM

Columns