VIEW: APPS.EGO_ATTR_GROUP_TYPES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)