View: EGO_ATTRS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains metadata information about User-Defined Attributes.
Implementation/DBA Data:	APPS.EGO_ATTRS_V

View Text

SELECT EXT.ATTR_ID ATTR_ID
, FL_COL.APPLICATION_ID APPLICATION_ID
, FL_COL.DESCRIPTIVE_FLEXFIELD_NAME ATTR_GROUP_TYPE
, FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME
, FL_COL.END_USER_COLUMN_NAME ATTR_NAME
, TL.FORM_LEFT_PROMPT ATTR_DISPLAY_NAME
, TL.DESCRIPTION DESCRIPTION
, FL_COL.APPLICATION_COLUMN_NAME DATABASE_COLUMN
, EXT.DATA_TYPE DATA_TYPE_CODE
, FL_COL.COLUMN_SEQ_NUM SEQUENCE
, EXT.UNIQUE_KEY_FLAG UNIQUE_KEY_FLAG
, FL_COL.DEFAULT_VALUE DEFAULT_VALUE
, EXT.INFO_1 INFO_1
, EXT.UOM_CLASS UOM_CLASS
, EXT.CONTROL_LEVEL CONTROL_LEVEL
, FL_COL.FLEX_VALUE_SET_ID VALUE_SET_ID
, FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, FFVS.FORMAT_TYPE FORMAT_CODE
, FFVS.MAXIMUM_SIZE MAXIMUM_SIZE
, FFVS.VALIDATION_TYPE VALIDATION_CODE
, FFVS.LONGLIST_FLAG LONGLIST_FLAG
, FL_COL.ENABLED_FLAG ENABLED_FLAG
, L1.MEANING ENABLED_MEANING
, FL_COL.REQUIRED_FLAG REQUIRED_FLAG
, L2.MEANING REQUIRED_MEANING
, EXT.SEARCH_FLAG SEARCH_FLAG
, L3.MEANING SEARCH_MEANING
, FL_COL.DISPLAY_FLAG DISPLAY_CODE
, L4.MEANING DISPLAY_MEANING
, EXT.ATTRIBUTE_CODE ATTRIBUTE_CODE
, EXT.VIEW_IN_HIERARCHY_CODE VIEW_IN_HIERARCHY_CODE
, EXT.EDIT_IN_HIERARCHY_CODE EDIT_IN_HIERARCHY_CODE
, EXT.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, FFVS.MINIMUM_VALUE AS MINIMUM_VALUE
, FFVS.MAXIMUM_VALUE AS MAXIMUM_VALUE
, DECODE(FFVS.VALIDATION_TYPE
, 'X'
, 'I'
, FFVS.VALIDATION_TYPE) AS VALIDATION_CODE_VS
FROM FND_DESCR_FLEX_COLUMN_USAGES FL_COL
, FND_DESCR_FLEX_COL_USAGE_TL TL
, EGO_FND_DF_COL_USGS_EXT EXT
, FND_FLEX_VALUE_SETS FFVS
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
, FND_LOOKUP_VALUES L4
WHERE FL_COL.APPLICATION_ID = TL.APPLICATION_ID
AND FL_COL.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME
AND FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = TL.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FL_COL.APPLICATION_COLUMN_NAME = TL.APPLICATION_COLUMN_NAME
AND FL_COL.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID(+)
AND TL.LANGUAGE = USERENV('LANG')
AND EXT.APPLICATION_ID (+) = FL_COL.APPLICATION_ID
AND EXT.DESCRIPTIVE_FLEXFIELD_NAME (+) = FL_COL.DESCRIPTIVE_FLEXFIELD_NAME
AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND EXT.APPLICATION_COLUMN_NAME (+) = FL_COL.APPLICATION_COLUMN_NAME
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = FL_COL.ENABLED_FLAG
AND L1.LANGUAGE = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID = 0
AND L2.LOOKUP_TYPE = 'YES_NO'
AND L2.LOOKUP_CODE = FL_COL.REQUIRED_FLAG
AND L2.LANGUAGE = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID = 0
AND L3.LOOKUP_TYPE (+) = 'YES_NO'
AND L3.LOOKUP_CODE (+) = EXT.SEARCH_FLAG
AND L3.LANGUAGE (+) = USERENV('LANG')
AND L3.VIEW_APPLICATION_ID (+) = 0
AND L4.LOOKUP_TYPE = 'EGO_EF_DISPLAY_TYPE'
AND L4.LOOKUP_CODE = FL_COL.DISPLAY_FLAG
AND L4.LANGUAGE = USERENV('LANG')
AND L4.VIEW_APPLICATION_ID = 0

Columns