View: EGO_ATTR_GROUP_TYPES_V

Product:	EGO - Advanced Product Catalog
Description:	View contains metadata information about User-Defined Attribute Group Types.
Implementation/DBA Data:	APPS.EGO_ATTR_GROUP_TYPES_V

View Text

SELECT FLEX.APPLICATION_ID APPLICATION_ID
, FLEX.DESCRIPTIVE_FLEXFIELD_NAME ATTR_GROUP_TYPE
, FLEX.APPLICATION_TABLE_NAME EXT_TABLE_NAME
, FLEX_EXT.APPLICATION_TL_TABLE_NAME EXT_TL_TABLE_NAME
, FLEX_EXT.APPLICATION_VL_NAME EXT_VL_NAME
, TL.TITLE ATTR_GROUP_TYPE_TITLE
, TL.DESCRIPTION DESCRIPTION
, FLEX_EXT.BUSINESS_EVENT_NAME BUSINESS_EVENT_NAME
, FLEX_EXT.HIERARCHY_NODE_QUERY HIERARCHY_NODE_QUERY
, FLEX_EXT.HIERARCHY_PROPAGATION_API HIERARCHY_PROPAGATION_API
, FLEX_EXT.PRE_BUSINESS_EVENT_NAME PRE_BUSINESS_EVENT_NAME
FROM FND_DESCRIPTIVE_FLEXS FLEX
, FND_DESCRIPTIVE_FLEXS_TL TL
, EGO_FND_DESC_FLEXS_EXT FLEX_EXT
WHERE FLEX.APPLICATION_ID = TL.APPLICATION_ID
AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME
AND TL.LANGUAGE = USERENV('LANG')
AND FLEX.APPLICATION_ID = FLEX_EXT.APPLICATION_ID(+)
AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = FLEX_EXT.DESCRIPTIVE_FLEXFIELD_NAME(+)

Columns