[Home] [Help] [Dependency Information]
Object Name: | AMS_MET_TPL_ASSOCS |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_MET_TPL_ASSOCS |
Subobject Name: | |
Status: | VALID |
AMS_MET_TPL_ASSOCS contains object types and custom setups to associate metrics to on creation of an object. Any object that uses metrics can have metrics automatically included on creation. For example, when creating a campaign all metric templates that contain the object type of campaign will have all campaign metrics associated with that new object. See AMS_MET_TPL_DETAILS for a list of metrics to copy. See AMS_METRICS_ALL_B and AMS_METRICS_ALL_TL for metric definitions. See AMS_ACT_METRICS_ALL for metrics assigned to objects.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_MET_TPL_ASSOCS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | METRIC_TPL_HEADER_ID |
AMS_MET_TPL_ASSOCS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
ASSOCIATION_TYPE
USED_BY_ID |
AMS_MET_TPL_ASSOCS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED |
ASSOCIATION_TYPE
USED_BY_CODE |
AMS_MET_TPL_ASSOCS_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED | METRIC_TPL_ASSOC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
METRIC_TPL_ASSOC_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. | |
METRIC_TPL_HEADER_ID | NUMBER | Yes | The id for the template this association is attached to. | |
ASSOCIATION_TYPE | VARCHAR2 | (30) | Yes | Whether an object or custom setup association. |
USED_BY_ID | NUMBER | Id of a custom setup, or other numeric id. | ||
USED_BY_CODE | VARCHAR2 | (30) | Object type code or other code to associate. | |
ENABLED_FLAG | VARCHAR2 | (1) | Active flag. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments. |
Cut, paste (and edit) the following text to query this object:
SELECT METRIC_TPL_ASSOC_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, METRIC_TPL_HEADER_ID
, ASSOCIATION_TYPE
, USED_BY_ID
, USED_BY_CODE
, ENABLED_FLAG
, SECURITY_GROUP_ID
FROM AMS.AMS_MET_TPL_ASSOCS;
AMS.AMS_MET_TPL_ASSOCS does not reference any database object
AMS.AMS_MET_TPL_ASSOCS is referenced by following:
|
|
|