eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.EGO_ATTR_GROUPS_DL_V

Object Details

Object Name:	EGO_ATTR_GROUPS_DL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_ATTR_GROUPS_DL_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_ATTR_GROUP_DL provides all the metadata information for attribute groups including the data level information. Some of the pieces of information stored in this view include the attribute group id, name, description, type, view and edit privilegesed, and pre and post raise conditions for business events.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ATTR_GROUP_ID	NUMBER	(10)	Yes	Attribute Group for which the Data Levels are enabled
APPLICATION_ID	NUMBER	(10)	Yes	Application which created the Attribute Group with Data Levels
ATTR_GROUP_TYPE	VARCHAR2	(40)	Yes	Type of the Attribute Group
ATTR_GROUP_NAME	VARCHAR2	(30)	Yes	Internal Name of the Attribute Group
ATTR_GROUP_DISP_NAME	VARCHAR2	(80)	Yes	Display Name of the Attribute Group
DESCRIPTION	VARCHAR2	(240)		Description of the Attribute group
OWNING_PARTY_ID	NUMBER	(15)	Yes	Party owning the Attribute Group
ENABLED_CODE	VARCHAR2	(1)	Yes	Code for the Enable
ENABLED_MEANING	VARCHAR2	(80)	Yes	Meaning of the Enabled Code
MULTI_ROW_CODE	VARCHAR2	(1)	Yes	Code to flag if the Attribute Group is Multi-Row
MULTI_ROW_MEANING	VARCHAR2	(80)	Yes	Meaning of the multi-row code
SECURITY_CODE	VARCHAR2	(30)	Yes	Code for Attribute Group Security
SECURITY_MEANING	VARCHAR2	(80)	Yes	Meaning of the Security Code
VIEW_PRIVILEGE_ID	NUMBER			View Privilege enabled for the Attribute Group at a Data Level
EDIT_PRIVILEGE_ID	NUMBER			Edit Privilege enabled for the Attribute Group at the Data Level
AGV_NAME	VARCHAR2	(30)		Attribute Group View Name
REGION_CODE	VARCHAR2	(30)		Region Code for the Attribute Group
RAISE_PRE_EVENT	VARCHAR2	(1)		Post-event Flag to enable business event of pre- type
RAISE_POST_EVENT	VARCHAR2	(1)		Post-event Flag to enable business event of post- type
DATA_LEVEL_ID	NUMBER		Yes	Data Level Id enabled for the Attribute Group
DATA_LEVEL_INTERNAL_NAME	VARCHAR2	(30)	Yes	Data Level Internal Name enabled for the Attribute Group
DATA_LEVEL_NAME	VARCHAR2	(240)		Data Level Display Name for the Attribute Group
VARIANT	VARCHAR2	(1)		Variant flag to check if the Attribute Group is Variant
BEHAVIOR	VARCHAR2	(30)		Defaulting/Inheritance Behavior at the Data Level

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ATTR_GROUP_ID
,      APPLICATION_ID
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_NAME
,      ATTR_GROUP_DISP_NAME
,      DESCRIPTION
,      OWNING_PARTY_ID
,      ENABLED_CODE
,      ENABLED_MEANING
,      MULTI_ROW_CODE
,      MULTI_ROW_MEANING
,      SECURITY_CODE
,      SECURITY_MEANING
,      VIEW_PRIVILEGE_ID
,      EDIT_PRIVILEGE_ID
,      AGV_NAME
,      REGION_CODE
,      RAISE_PRE_EVENT
,      RAISE_POST_EVENT
,      DATA_LEVEL_ID
,      DATA_LEVEL_INTERNAL_NAME
,      DATA_LEVEL_NAME
,      VARIANT
,      BEHAVIOR
FROM APPS.EGO_ATTR_GROUPS_DL_V;

Dependencies

[top of page]

APPS.EGO_ATTR_GROUPS_DL_V references the following:

APPS: EGO_ATTR_GROUP_DL; EGO_DATA_LEVEL_B; EGO_DATA_LEVEL_TL; EGO_FND_DSC_FLX_CTX_EXT; FND_DESCR_FLEX_CONTEXTS; FND_DESCR_FLEX_CONTEXTS_TL; FND_LOOKUP_VALUES

APPS.EGO_ATTR_GROUPS_DL_V is referenced by following:

APPS: EGO_EXT_FWK_PUB - show dependent code; EGO_IMPORT_BATCH_COMPARE_PVT - show dependent code