VIEW: APPS.EGO_ITEM_MAIN_ATTRS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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