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_V

Object Details

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

View Type

A Business Intelligence System view

View EGO_ATTR_GROUPS_V provides all the metadata information for attribute groups. 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 identifier
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
ATTR_GROUP_TYPE	VARCHAR2	(40)	Yes	Attribute Group Type
ATTR_GROUP_NAME	VARCHAR2	(30)	Yes	Attribute group internal name
ATTR_GROUP_DISP_NAME	VARCHAR2	(80)	Yes	Attribute group display name
DESCRIPTION	VARCHAR2	(240)		Description for the attribute group
OWNING_PARTY_ID	NUMBER	(15)	Yes	Owner of this attribute group
ENABLED_CODE	VARCHAR2	(1)	Yes	Enabled Y or N
ENABLED_MEANING	VARCHAR2	(80)	Yes	Meaning for Enabled_Flag Yes or No
MULTI_ROW_CODE	VARCHAR2	(1)	Yes	Is this a multi row attribute group
MULTI_ROW_MEANING	VARCHAR2	(80)	Yes	Meaning of Multi Row Yes or No
SECURITY_CODE	VARCHAR2	(30)	Yes	Security level (Obsolete column)
SECURITY_MEANING	VARCHAR2	(80)	Yes	Meaning of security like public etc(Obsolete column)
VIEW_PRIVILEGE_ID	NUMBER	(15)		Name of the Data Security privilege necessary to view the attribute group value(foreign key to FND_FORM_FUNCTIONS)
EDIT_PRIVILEGE_ID	NUMBER	(15)		Name of the Data Security privilege necessary to edit the attribute group value(foreign key to FND_FORM_FUNCTIONS)
AGV_NAME	VARCHAR2	(30)		Attribute group Database View Name
REGION_CODE	VARCHAR2	(30)		Used for displaying the attributes in sections, used only for seeded attributes
BUSINESS_EVENT_FLAG	VARCHAR2	(1)		Depicts if post Business event is raised on change of Attribute group data or not
PRE_BUSINESS_EVENT_FLAG	VARCHAR2	(1)		Flag indicating whether or not a Business Event will be raised before changes to data for this Attribute Group
VARIANT	VARCHAR2	(1)		Flag indicating the Attribute Group is Variant or not
NUM_OF_COLS	NUMBER	(15)		Holds the Number of columns shown in pagelayout for single-Row AG or Number of columns in the table for multi-Row AG
NUM_OF_ROWS	NUMBER	(15)		Holds the Number of Rows shown in the table for each page for a multi-Row Attribute Group

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
,      BUSINESS_EVENT_FLAG
,      PRE_BUSINESS_EVENT_FLAG
,      VARIANT
,      NUM_OF_COLS
,      NUM_OF_ROWS
FROM APPS.EGO_ATTR_GROUPS_V;

Dependencies

[top of page]

APPS.EGO_ATTR_GROUPS_V references the following:

APPS: EGO_FND_DSC_FLX_CTX_EXT; FND_DESCR_FLEX_CONTEXTS; FND_DESCR_FLEX_CONTEXTS_TL; FND_LOOKUP_VALUES

APPS.EGO_ATTR_GROUPS_V is referenced by following:

APPS: BOM_ATTRS_V; BOM_BULKLOAD_PVT_PKG - show dependent code; BOM_COMPUTE_FUNCTIONS - show dependent code; BOM_IMPORT_PUB - show dependent code; CS_SR_EXTATTRIBUTES_PVT - show dependent code; CZ_EXV_APC_PROPERTIES; CZ_EXV_ITEM_APC_PROP_VALUES; EGO_ALL_ATTR_BASE_V; EGO_ALL_ATTR_LANG_V; EGO_ATTR_GROUP_OBJ_IDS_V; EGO_EXT_FWK_PUB - show dependent code; EGO_GTIN_ATTRS_PVT - show dependent code; EGO_GTIN_BARCODE_ATTRS_V; EGO_GTIN_COLOR_ATTRS_V; EGO_GTIN_COUNTRY_ORGN_V; EGO_GTIN_DELIVERY_METHOD_V; EGO_GTIN_HAND_INF_ATTRS_V; EGO_GTIN_HARMONIZED_ID_V; EGO_GTIN_HAZMAT_ATTRS_V; EGO_GTIN_MFG_ATTRS_V; EGO_GTIN_PVT - show dependent code; EGO_GTIN_SIZE_DESC_V; EGO_IMPORT_UTIL_PVT - show dependent code; EGO_ITEM_BULKLOAD_PKG - show dependent code; EGO_ITEM_COMPARE_PKG - show dependent code; EGO_ITEM_PUB - show dependent code; EGO_ITEM_PVT - show dependent code; EGO_TEMPL_ATTRS_PUB - show dependent code; EGO_UPGRADE_USER_ATTR_VAL_PUB - show dependent code; EGO_USER_ATTRS_DATA_PVT - show dependent code; ENGPKIMP - show dependent code; INVNIRIS - show dependent code; MTH_UDA_PKG - show dependent code; RRS_BULKLOAD_ENTITIES - show dependent code