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_CTD_ASSOCIATIONS

Object Details

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

This table describes the association between marketing object and click through destination

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_CTD_ASSOCIATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_ID
AMS_CTD_ASSOCIATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USED_BY_TYPE USED_BY_VAL1
AMS_CTD_ASSOCIATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CTD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSOCIATION_ID	NUMBER		Yes	Identifier to indicate a unique association
CTD_ID	NUMBER		Yes	Refers to the CTD. Foreign key to AMS_CTDS
USED_BY_TYPE	VARCHAR2	(100)	Yes	Object type that the CTD is associatd to
USED_BY_VAL1	VARCHAR2	(256)	Yes	object id that the CTD is associated to
USED_BY_VAL2	VARCHAR2	(256)		if the associated object has composite key
USED_BY_VAL3	VARCHAR2	(256)		if the associated object has composite key
USED_BY_VAL4	VARCHAR2	(256)		if the associated object has composite key
USED_BY_VAL5	VARCHAR2	(256)		if the associated object has composite key
OBJECT_VERSION_NUMBER	NUMBER		Yes	Used for locking purposes
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER		Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER			standard who column
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER		Yes	standard who column
SECURITY_GROUP_ID	NUMBER			Used for hosting purpose

Query Text

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


SELECT ASSOCIATION_ID
,      CTD_ID
,      USED_BY_TYPE
,      USED_BY_VAL1
,      USED_BY_VAL2
,      USED_BY_VAL3
,      USED_BY_VAL4
,      USED_BY_VAL5
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SECURITY_GROUP_ID
FROM AMS.AMS_CTD_ASSOCIATIONS;

Dependencies

[top of page]

AMS.AMS_CTD_ASSOCIATIONS does not reference any database object

AMS.AMS_CTD_ASSOCIATIONS is referenced by following:

AMS: AMS_CTD_ASSOCIATIONS#