[Home] [Help] [Dependency Information]
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'.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
AMS.AMS_OBJECT_ASSOCIATIONS does not reference any database object
AMS.AMS_OBJECT_ASSOCIATIONS is referenced by following:
|
|
|