Here is the query to list down all the extensible attribute types, attribute group names and attribute names.
SELECT *
FROM (SELECT --egoattributeeo.attr_id,
egoattributeeo.application_id,
egoattributeeo.attr_group_type,
egoattributeeo.attr_group_name,
egoattributeeo.attr_name,
egoattributeeo.attr_display_name,
decode(egoattributeeo.data_type_code,'C','CHAR','N','NUM','X','DATE') data_type_code,
egoattributeeo.DEFAULT_VALUE,
egoattributeeo.value_set_name,
egoattributeeo.maximum_size,
egoattributeeo.enabled_flag,
egoattributeeo.required_flag,
egoattributeeo.database_column,
egoattributeeo.read_only_flag
FROM ego_attrs_v egoattributeeo, ego_fnd_dsc_flx_ctx_ext ext
WHERE egoattributeeo.application_id = ext.application_id
AND egoattributeeo.attr_group_type =
ext.descriptive_flexfield_name
AND egoattributeeo.attr_group_name =
ext.descriptive_flex_context_code) qrslt
WHERE (application_id = <YOUR APPLI_ID> AND attr_group_type like '%'
)
ORDER BY attr_group_type, attr_group_name