VIEW: APPS.EGO_OBJ_ATTR_GRP_ASSOCS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')