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_ACTIONS_B

Object Details

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

Table EGO_ACTIONS_B stores the definition information required to create actions for attribute groups. The information includes the action name, attribute group for which the action was defined, sequence, function to execute and security privileges required to execute it among others.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ACTIONS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_ID	NUMBER		Yes	Unique identifier for Action
OBJECT_ID	NUMBER		Yes	Object Identifier
CLASSIFICATION_CODE	VARCHAR2	(150)		Classification Code for the objects. Example - Item Catalog Category
ATTR_GROUP_ID	NUMBER	(10)		Attribute group identifier to which this action is assigned to.
SEQUENCE	NUMBER		Yes	It determines the order in which actions associated to a particular attribute group are shown while displaying the actions
ACTION_NAME	VARCHAR2	(60)	Yes	Identifier of the Function that is initiated with this action
FUNCTION_ID	NUMBER		Yes	Identifier of the Function that is assocaited with this action
SECURITY_PRIVILEGE_ID	NUMBER			Function Id (Privilege) associated with this action
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
ENABLE_KEY_ATTRIBUTES	VARCHAR2	(1)		Flag to indicate whether to pass the Key Attributes to the function or not

Query Text

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


SELECT ACTION_ID
,      OBJECT_ID
,      CLASSIFICATION_CODE
,      ATTR_GROUP_ID
,      SEQUENCE
,      ACTION_NAME
,      FUNCTION_ID
,      SECURITY_PRIVILEGE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ENABLE_KEY_ATTRIBUTES
FROM EGO.EGO_ACTIONS_B;

Dependencies

[top of page]

EGO.EGO_ACTIONS_B does not reference any database object

EGO.EGO_ACTIONS_B is referenced by following:

APPS: EGO_ACTIONS_B