View: EGO_OBJ_ATTR_GRP_ASSOCS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains Attribute Group to Object Association
Implementation/DBA Data:	APPS.EGO_OBJ_ATTR_GRP_ASSOCS_V

View Text

SELECT A.ASSOCIATION_ID AS ASSOCIATION_ID
, A.OBJECT_ID AS OBJECT_ID
, O.OBJ_NAME AS OBJECT_NAME
, A.CLASSIFICATION_CODE AS CLASSIFICATION_CODE
, DL_VL.USER_DATA_LEVEL_NAME AS DATA_LEVEL
, DL_VL.DATA_LEVEL_NAME AS DATA_LEVEL_INT_NAME
, A.ATTR_GROUP_ID AS ATTR_GROUP_ID
, EXT.APPLICATION_ID AS APPLICATION_ID
, EXT.DESCRIPTIVE_FLEXFIELD_NAME AS ATTR_GROUP_TYPE
, EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE AS ATTR_GROUP_NAME
, TL.DESCRIPTIVE_FLEX_CONTEXT_NAME AS ATTR_GROUP_DISP_NAME
, TL.DESCRIPTION AS ATTR_GROUP_DESCRIPTION
, A.ENABLED_FLAG AS ENABLED_CODE
, EXT.VARIANT AS VARIANT
, A.DATA_LEVEL_ID AS DATA_LEVEL_ID
FROM EGO_OBJ_AG_ASSOCS_B A
, FND_OBJECTS O
, EGO_DATA_LEVEL_VL DL_VL
, EGO_FND_DSC_FLX_CTX_EXT EXT
, FND_DESCR_FLEX_CONTEXTS_TL TL
WHERE A.OBJECT_ID = O.OBJECT_ID AND A.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID AND EXT.APPLICATION_ID = TL.APPLICATION_ID AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = TL.DESCRIPTIVE_FLEX_CONTEXT_CODE AND DL_VL.DATA_LEVEL_ID = A.DATA_LEVEL_ID AND TL.LANGUAGE = USERENV('LANG')

Columns