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: AMS.AMS_ACT_ACCESS

Object Details

Object Name:	AMS_ACT_ACCESS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_ACT_ACCESS
Subobject Name:
Status:	VALID

AMS_ACT_ACCESS stores users/roles with admin/view privilege for all marketing objects like campaigns, events , collaterals and funds.
The responsibility together with the admin flag on this table handles most of the security in the application. That is, who can update,delete information pertaining to an object.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_ACCESS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_ACCESS_ID
AMS_ACT_ACCESS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACT_ACCESS_TO_OBJECT_ID ARC_ACT_ACCESS_TO_OBJECT USER_OR_ROLE_ID ARC_USER_OR_ROLE_TYPE
AMS_ACT_ACCESS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVE_FROM_DATE
AMS_ACT_ACCESS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVE_TO_DATE
AMS_ACT_ACCESS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_OR_ROLE_ID
AMS_ACT_ACCESS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_USER_OR_ROLE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_ACCESS_ID	NUMBER		Yes	Unique Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ACT_ACCESS_TO_OBJECT_ID	NUMBER		Yes	Unique activity code used across systems.
ARC_ACT_ACCESS_TO_OBJECT	VARCHAR2	(30)	Yes	Unique activity type used across systems.
USER_OR_ROLE_ID	NUMBER		Yes	User Or Group Indentifier.
ARC_USER_OR_ROLE_TYPE	VARCHAR2	(30)	Yes	User or Group Type.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
ACTIVE_FROM_DATE	DATE			Flag to indicate whether this person is active or not
ADMIN_FLAG	VARCHAR2	(1)		Flag to indicate whether this person is the owner
APPROVER_FLAG	VARCHAR2	(1)		Flag to indicate whether this person is the primary contact
ACTIVE_TO_DATE	DATE			Date till which the user or group is active
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
DELETE_FLAG	VARCHAR2	(1)		Access information for users ( user_or_role_type='USER') the deletion is real time. When groups are deleted, they will be market for delete using this column. Access refresh programs perform the actual delete.
OWNER_FLAG	VARCHAR2	(1)		Flag indicating that the resource is owner of the object

Query Text

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


SELECT ACTIVITY_ACCESS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ACT_ACCESS_TO_OBJECT_ID
,      ARC_ACT_ACCESS_TO_OBJECT
,      USER_OR_ROLE_ID
,      ARC_USER_OR_ROLE_TYPE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACTIVE_FROM_DATE
,      ADMIN_FLAG
,      APPROVER_FLAG
,      ACTIVE_TO_DATE
,      SECURITY_GROUP_ID
,      DELETE_FLAG
,      OWNER_FLAG
FROM AMS.AMS_ACT_ACCESS;

Dependencies

[top of page]

AMS.AMS_ACT_ACCESS does not reference any database object

AMS.AMS_ACT_ACCESS is referenced by following:

APPS: AMS_ACT_ACCESS