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]

TABLE: EGO.EGO_OBJ_AG_ASSOCS_B

Object Details

Object Name:	EGO_OBJ_AG_ASSOCS_B
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_OBJ_AG_ASSOCS_B
Subobject Name:
Status:	VALID

Table contains Object to Attribute group associations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_OBJ_AG_ASSOCS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_ID ZD_EDITION_NAME
EGO_OBJ_AG_ASSOCS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID CLASSIFICATION_CODE ATTR_GROUP_ID DATA_LEVEL_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ASSOCIATION_ID	NUMBER	(15)	Yes	Identifier for the Association
OBJECT_ID	NUMBER	(15)	Yes	Identifier for the Object to which the Attribute Group is to be associated (foreign key to FND_OBJECTS)
CLASSIFICATION_CODE	VARCHAR2	(150)		Additional identifier for the Object (specifically, its classification, category or subtype)
DATA_LEVEL	VARCHAR2	(30)		Lookup indicating the level of granularity at which the Attribute Group is to be associated to the Object
ATTR_GROUP_ID	NUMBER	(10)	Yes	Identifier for the Attribute Group to be associated to the Object (foreign key to EGO_FND_DSC_FLX_CTX_EXT)
ENABLED_FLAG	VARCHAR2	(1)	Yes	Whether the Association is currently active
VIEW_PRIVILEGE_ID	NUMBER	(15)		Identifier for the Data Security privilege necessary to view the Association (foreign key to FND_FORM_FUNCTIONS,FUNCTION_ID)
EDIT_PRIVILEGE_ID	NUMBER	(15)		Identifier for the Data Security privilege necessary to edit the Association (foreign key to FND_FORM_FUNCTIONS,FUNCTION_ID)
CREATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
DATA_LEVEL_ID	NUMBER			Data Level at which the Association is created for Attribute Group
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ASSOCIATION_ID
,      OBJECT_ID
,      CLASSIFICATION_CODE
,      DATA_LEVEL
,      ATTR_GROUP_ID
,      ENABLED_FLAG
,      VIEW_PRIVILEGE_ID
,      EDIT_PRIVILEGE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DATA_LEVEL_ID
,      ZD_EDITION_NAME
FROM EGO.EGO_OBJ_AG_ASSOCS_B;

Dependencies

[top of page]

EGO.EGO_OBJ_AG_ASSOCS_B does not reference any database object

EGO.EGO_OBJ_AG_ASSOCS_B is referenced by following:

EGO: EGO_OBJ_AG_ASSOCS_B#