View: EGO_ATTR_GROUPS_DL_V

Product:	EGO - Advanced Product Catalog
Description:
Implementation/DBA Data:	APPS.EGO_ATTR_GROUPS_DL_V

View Text

SELECT FL_CTX_EXT.ATTR_GROUP_ID AS ATTR_GROUP_ID
, FL_CTX.APPLICATION_ID AS APPLICATION_ID
, FL_CTX.DESCRIPTIVE_FLEXFIELD_NAME AS ATTR_GROUP_TYPE
, FL_CTX.DESCRIPTIVE_FLEX_CONTEXT_CODE AS ATTR_GROUP_NAME
, TL.DESCRIPTIVE_FLEX_CONTEXT_NAME AS ATTR_GROUP_DISP_NAME
, TL.DESCRIPTION AS DESCRIPTION
, FL_CTX_EXT.OWNING_PARTY_ID AS OWNING_PARTY_ID
, FL_CTX.ENABLED_FLAG AS ENABLED_CODE
, L1.MEANING AS ENABLED_MEANING
, FL_CTX_EXT.MULTI_ROW AS MULTI_ROW_CODE
, L2.MEANING AS MULTI_ROW_MEANING
, FL_CTX_EXT.SECURITY_TYPE AS SECURITY_CODE
, L3.MEANING AS SECURITY_MEANING
, DL.VIEW_PRIVILEGE_ID AS VIEW_PRIVILEGE_ID
, DL.EDIT_PRIVILEGE_ID AS EDIT_PRIVILEGE_ID
, FL_CTX_EXT.AGV_NAME AS AGV_NAME
, FL_CTX_EXT.REGION_CODE AS REGION_CODE
, DL.RAISE_PRE_EVENT AS RAISE_PRE_EVENT
, DL.RAISE_POST_EVENT AS RAISE_POST_EVENT
, DL.DATA_LEVEL_ID AS DATA_LEVEL_ID
, DL_B.DATA_LEVEL_NAME AS DATA_LEVEL_INTERNAL_NAME
, DL_TL.USER_DATA_LEVEL_NAME AS DATA_LEVEL_NAME
, FL_CTX_EXT.VARIANT AS VARIANT
, DL.DEFAULTING AS BEHAVIOR
FROM FND_DESCR_FLEX_CONTEXTS FL_CTX
, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
, FND_DESCR_FLEX_CONTEXTS_TL TL
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
, EGO_ATTR_GROUP_DL DL
, EGO_DATA_LEVEL_B DL_B
, EGO_DATA_LEVEL_TL DL_TL
WHERE FL_CTX.APPLICATION_ID = FL_CTX_EXT.APPLICATION_ID
AND FL_CTX.APPLICATION_ID = TL.APPLICATION_ID
AND FL_CTX.DESCRIPTIVE_FLEXFIELD_NAME = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
AND FL_CTX.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME
AND FL_CTX.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FL_CTX.DESCRIPTIVE_FLEX_CONTEXT_CODE = TL.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND DL.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
AND DL_B.DATA_LEVEL_ID = DL.DATA_LEVEL_ID
AND DL_B.DATA_LEVEL_ID = DL_TL.DATA_LEVEL_ID
AND DL_TL.LANGUAGE = USERENV('LANG')
AND TL.LANGUAGE = USERENV('LANG')
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = FL_CTX.ENABLED_FLAG
AND L1.LANGUAGE = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID = 0
AND L2.LOOKUP_TYPE = 'YES_NO'
AND L2.LOOKUP_CODE = FL_CTX_EXT.MULTI_ROW
AND L2.LANGUAGE = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID = 0
AND L3.LOOKUP_TYPE = UPPER('EGO_EF_SECURITY_TYPE')
AND L3.LOOKUP_CODE = FL_CTX_EXT.SECURITY_TYPE
AND L3.LANGUAGE = USERENV('LANG')
AND L3.VIEW_APPLICATION_ID = 0

Columns