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_PARTNERS

Object Details

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

AMS_ACT_PARTNERS stores information about Partners associated with any marketing activity like a Campaign or an Event. The table stores the keys to Campaign/Event table and the Partners table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_PARTNERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_PARTNER_ID
AMS_ACT_PARTNERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_ACT_PARTNER_USED_BY ACT_PARTNER_USED_BY_ID
AMS_ACT_PARTNERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_ID
AMS_ACT_PARTNERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREFERRED_VAD_ID
AMS_ACT_PARTNERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_CONTACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_PARTNER_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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
ACT_PARTNER_USED_BY_ID	NUMBER			Unique identifier for the marketing activity e.g. CAMPAIGN_ID
ARC_ACT_PARTNER_USED_BY	VARCHAR2	(30)	Yes	Arc qualifier for the marketing activity type e.g. CAMP for Campaigns.
PARTNER_ID	NUMBER		Yes	Unique identifier for the partner table.
PARTNER_TYPE	VARCHAR2	(240)		Categories the partner for the marketing activity e.g. Global Alliance partner.
DESCRIPTION	VARCHAR2	(4000)		Description attached to the partnership.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PREFERRED_VAD_ID	NUMBER			Preferred VAD Identifier
PARTNER_ADDRESS_ID	NUMBER			Partner address identifier
PRIMARY_FLAG	VARCHAR2	(1)		Indicates if the partner is primary
PRIMARY_CONTACT_ID	NUMBER			Primary Contact Identifier

Query Text

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


SELECT ACTIVITY_PARTNER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACT_PARTNER_USED_BY_ID
,      ARC_ACT_PARTNER_USED_BY
,      PARTNER_ID
,      PARTNER_TYPE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      PREFERRED_VAD_ID
,      PARTNER_ADDRESS_ID
,      PRIMARY_FLAG
,      PRIMARY_CONTACT_ID
FROM AMS.AMS_ACT_PARTNERS;

Dependencies

[top of page]

AMS.AMS_ACT_PARTNERS does not reference any database object

AMS.AMS_ACT_PARTNERS is referenced by following:

AMS: AMS_ACT_PARTNERS#