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_OBJECT_ASSOCIATIONS

Object Details

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

AMS_OBJECT_ASSOCIATIONS is the cross reference between the Deliverables (ads, collateral etc.) and the Promotions or Events we are running. As part of the Promotion set-up the Promotion manager must decide on what deliverablesl are required for the Promotion.
If a Deliverable is created for a specific Activity (Promotion, Event) the CREATED_FOR will be used as value for column USAGE_TYPE. Hence, all costs accrued for creating the Deliverable will be carried by the Activity. The activity can set a max value it is prepared to accept. If an activity is only using an existing Deliverable, USED_BY will be the value for column USAGE_TYPE.
Some examples could be 'Whitney Houston ad for True Voice' created for Promotion X , 'Garth Brooks ad in Radio' created for Event Y, 'Brochure Z for Mailings' used by Promotion Channel 'Mail House W'.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_OBJECT_ASSOCIATIONS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	OBJECT_ASSOCIATION_ID
AMS_OBJECT_ASSOCIATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	MASTER_OBJECT_ID
AMS_OBJECT_ASSOCIATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	USING_OBJECT_ID
AMS_OBJECT_ASSOCIATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	MAX_COST_CURRENCY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ASSOCIATION_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. A way to implement Optimistic locking.
MASTER_OBJECT_TYPE	VARCHAR2	(30)	Yes	Object Type of the Master Object. The object relationship is FROM this type of object. For example, when an Event Header has to associate Campaigns with it, the Event Header is the MASTER OBJECT TYPE.
MASTER_OBJECT_ID	NUMBER		Yes	Object ID of the object defined by Master Object Type.
USING_OBJECT_TYPE	VARCHAR2	(30)	Yes	Object Type of the Object which is being associated with the Master Object. For example, when we associate Campaigns with an Event Header. Campaign is the Using Object Type.
USING_OBJECT_ID	NUMBER		Yes	Object ID of the type of object defined by Using Object Type.
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Whether it is the primary association.
USAGE_TYPE	VARCHAR2	(30)	Yes	Whether the USING_OBJECT was created or just USED_BY the Master Object. Type of usage.
QUANTITY_NEEDED	NUMBER	(15)		Quantity of the Using Object needed.
QUANTITY_NEEDED_BY_DATE	DATE			Quantity needed by date.
COST_FROZEN_FLAG	VARCHAR2	(1)		Whether the cost is frozen.
PCT_OF_COST_TO_CHARGE_USED_BY	NUMBER	(15)		Used for cost approtioning.
MAX_COST_TO_CHARGE_USED_BY	NUMBER	(15)		Estimated cost of production
MAX_COST_CURRENCY_CODE	VARCHAR2	(15)		Currency Code associated with MAX_COST_TO_CHARGE_USED_BY
FULFILL_ON_TYPE_CODE	VARCHAR2	(30)		Fulfill On Type code. The values are seeded.
METRIC_CLASS	VARCHAR2	(30)		Metric class of the tracked Metrics.
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
SEQUENCE_NO	NUMBER			Sequence no for the deliverables used in eBlast.
CONTENT_TYPE	VARCHAR2	(30)		Content type of the deliverable used for eBlast

Query Text

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


SELECT OBJECT_ASSOCIATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      MASTER_OBJECT_TYPE
,      MASTER_OBJECT_ID
,      USING_OBJECT_TYPE
,      USING_OBJECT_ID
,      PRIMARY_FLAG
,      USAGE_TYPE
,      QUANTITY_NEEDED
,      QUANTITY_NEEDED_BY_DATE
,      COST_FROZEN_FLAG
,      PCT_OF_COST_TO_CHARGE_USED_BY
,      MAX_COST_TO_CHARGE_USED_BY
,      MAX_COST_CURRENCY_CODE
,      FULFILL_ON_TYPE_CODE
,      METRIC_CLASS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      SEQUENCE_NO
,      CONTENT_TYPE
FROM AMS.AMS_OBJECT_ASSOCIATIONS;

Dependencies

[top of page]

AMS.AMS_OBJECT_ASSOCIATIONS does not reference any database object

AMS.AMS_OBJECT_ASSOCIATIONS is referenced by following:

APPS: AMS_OBJECT_ASSOCIATIONS