VIEW: APPS.EGO_ATTR_GROUPS_DL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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