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_LIST_GROUPS

Object Details

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

Target Groups could be subdivided into many small groups. This table stores the information regarding them.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_LIST_GROUPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACT_LIST_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACT_LIST_GROUP_ID	NUMBER		Yes	Unique Identifer
ACT_LIST_USED_BY_ID	NUMBER		Yes	Schedule Id in case of Taget Groups / Event header Id in case of Invite Lists
ARC_ACT_LIST_USED_BY	VARCHAR2	(30)	Yes	Valid values are CSCH, EVEH,EONE
GROUP_CODE	VARCHAR2	(10)	Yes	Target group could be divided into may groups. The group code will
GROUP_PRIORITY	NUMBER			Group Priority
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
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Used for locking purpose
STATUS_CODE	VARCHAR2	(30)		Status Code for the group.
USER_STATUS_ID	NUMBER			Status Id for the group.
SECURITY_GROUP_ID	NUMBER			Used in hosting enviroments
CALLING_CALENDAR_ID	NUMBER			Calling Calendar Identifier
RELEASE_CONTROL_ALG_ID	NUMBER			Release Control Algorithm Identifier
RELEASE_STRATEGY	VARCHAR2	(30)		Release Strategy
RECYCLING_ALG_ID	NUMBER			Recycling Algorith Identifier
CALLBACK_PRIORITY_FLAG	VARCHAR2	(1)		Call Back Priority Flag
CALL_CENTER_READY_FLAG	VARCHAR2	(1)		Call Center Ready Flag
DIALING_METHOD	VARCHAR2	(30)		Dialing Method
QUANTUM	NUMBER			Which Quantum It belongs to
QUOTA	NUMBER			Quota
QUOTA_RESET	NUMBER			Quota Reset

Query Text

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


SELECT ACT_LIST_GROUP_ID
,      ACT_LIST_USED_BY_ID
,      ARC_ACT_LIST_USED_BY
,      GROUP_CODE
,      GROUP_PRIORITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      STATUS_CODE
,      USER_STATUS_ID
,      SECURITY_GROUP_ID
,      CALLING_CALENDAR_ID
,      RELEASE_CONTROL_ALG_ID
,      RELEASE_STRATEGY
,      RECYCLING_ALG_ID
,      CALLBACK_PRIORITY_FLAG
,      CALL_CENTER_READY_FLAG
,      DIALING_METHOD
,      QUANTUM
,      QUOTA
,      QUOTA_RESET
FROM AMS.AMS_ACT_LIST_GROUPS;

Dependencies

[top of page]

AMS.AMS_ACT_LIST_GROUPS does not reference any database object

AMS.AMS_ACT_LIST_GROUPS is referenced by following:

APPS: AMS_ACT_LIST_GROUPS