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_CONTACT_POINTS

Object Details

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

This table stores the contact details of marketing objects. For ex. it stores the phone number, website URL, address etc. This table also stores the scripts to be used to contact the customer

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_CONTACT_POINTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTACT_POINT_ID
AMS_ACT_CONTACT_POINTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_CONTACT_USED_BY ACT_CONTACT_USED_BY_ID CONTACT_POINT_TYPE
AMS_ACT_CONTACT_POINTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_POINT_VALUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTACT_POINT_ID	NUMBER		Yes	Identifier for the contact points
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)		Standard Who column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Used for locking purpose.
ARC_CONTACT_USED_BY	VARCHAR2	(30)	Yes	Denotes the marketing object which uses the contact point. Refers to lookup type AMS_SYS_ARC_QUALIFIER.
ACT_CONTACT_USED_BY_ID	NUMBER		Yes	Identifies the contact point user. Ex. if ARC_CONTACT_USED_BY is 'CAMP' this would refer to the campaign id.
CONTACT_POINT_TYPE	VARCHAR2	(30)	Yes	Type of the Contact. Can be phone, website, addres etc
CONTACT_POINT_VALUE	VARCHAR2	(256)	Yes	Identifies the value depending on the contact_point_value. Ex. if contact_point_type is phone, this field would store the phone number.
CITY	VARCHAR2	(120)		Denotes the city. Would be valid only of the contact point type is address.
COUNTRY	VARCHAR2	(30)		Denotes the country. Would be valid only of the contact point type is address. Refers to the location hierarchy id from jtf_loc_hierarchies_b.
ZIPCODE	VARCHAR2	(120)		Denotes the zip code. Would be valid only of the contact point type is address.
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Descriptive flexfiled structure defining column .
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield column.
SECURITY_GROUP_ID	NUMBER			Used in Hosted environment.
CONTACT_POINT_VALUE_ID	NUMBER			Contact point value identifier

Query Text

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


SELECT CONTACT_POINT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ARC_CONTACT_USED_BY
,      ACT_CONTACT_USED_BY_ID
,      CONTACT_POINT_TYPE
,      CONTACT_POINT_VALUE
,      CITY
,      COUNTRY
,      ZIPCODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CONTACT_POINT_VALUE_ID
FROM AMS.AMS_ACT_CONTACT_POINTS;

Dependencies

[top of page]

AMS.AMS_ACT_CONTACT_POINTS does not reference any database object

AMS.AMS_ACT_CONTACT_POINTS is referenced by following:

APPS: AMS_ACT_CONTACT_POINTS