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_LIST_CONT_RESTRICTIONS

Object Details

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

Do not Contact List Information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_LIST_CONT_RESTRICTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_CONTACT_RESTRICTIONS_ID
AMS_LIST_CONT_RESTRICTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIA_ID
AMS_LIST_CONT_RESTRICTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID
AMS_LIST_CONT_RESTRICTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_USED_BY_ID LIST_USED_BY

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_CONTACT_RESTRICTIONS_ID	NUMBER		Yes	Primary Key
LIST_HEADER_ID	NUMBER		Yes	List Header id which store the entries which should not be targeted
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER			Object version number is used by API's to check if the record has been modfied
DO_NOT_CONTACT_FLAG	VARCHAR2	(1)		Valid Values are Y and N
MEDIA_ID	NUMBER			Media Id
LIST_USED_BY	VARCHAR2	(30)		Arc qualifier for the marketing activity type e.g. CSCH for schedules
LIST_USED_BY_ID	NUMBER			Schedule Id for Target group.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT LIST_CONTACT_RESTRICTIONS_ID
,      LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DO_NOT_CONTACT_FLAG
,      MEDIA_ID
,      LIST_USED_BY
,      LIST_USED_BY_ID
,      SECURITY_GROUP_ID
FROM AMS.AMS_LIST_CONT_RESTRICTIONS;

Dependencies

[top of page]

AMS.AMS_LIST_CONT_RESTRICTIONS does not reference any database object

AMS.AMS_LIST_CONT_RESTRICTIONS is referenced by following:

APPS: AMS_LIST_CONT_RESTRICTIONS