[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_METRICS_ALL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_ACT_METRICS_ALL |
Subobject Name: | |
Status: | VALID |
AMS_ACT_METRICS_ALL stores the metrics that will be tracked for a particular activity. The forecasted, committed and actual value of the metric will be available here. The metric engine will calculate the actual values(unless manual metric is used). The committed value is set after purchase request/budget is approved. Forecasted is manually entered by the end user.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_ACT_METRICS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACTIVITY_METRIC_ID |
AMS_ACT_METRICS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ARC_ACT_METRIC_USED_BY
ACT_METRIC_USED_BY_ID |
AMS_ACT_METRICS_ALL_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ARC_FUNCTION_USED_BY
FUNCTION_USED_BY_ID |
AMS_ACT_METRICS_ALL_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTIVITY_METRIC_ORIGIN_ID |
AMS_ACT_METRICS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | METRIC_UOM_CODE |
AMS_ACT_METRICS_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CURRENCY_CODE |
AMS_ACT_METRICS_ALL_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
AMS_ACT_METRICS_ALL_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | METRIC_ID |
AMS_ACT_METRICS_ALL_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FUNCTIONAL_CURRENCY_CODE |
AMS_ACT_METRICS_ALL_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_ID |
AMS_ACT_METRICS_ALL_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | APPLICATION_ID |
AMS_ACT_METRICS_ALL_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_METRIC_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) | Standard column for row locking. | |
ACT_METRIC_USED_BY_ID | NUMBER | Yes | Column contains the value Id of the object using a specific metric, for example, the value of Event ID. | |
ARC_ACT_METRIC_USED_BY | VARCHAR2 | (30) | Yes | Column contains the kind of object using a specific metirc, for example, CAMP for Campaign. |
PURCHASE_REQ_RAISED_FLAG | VARCHAR2 | (1) | Flag to indicate if a purchase order was raised for this Cost type metric. | |
APPLICATION_ID | NUMBER | Yes | Standard column to indicate the application using this metric. | |
SENSITIVE_DATA_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this is a confidential metric. |
BUDGET_ID | NUMBER | Reference for the Budget attached to the metric. | ||
METRIC_ID | NUMBER | Yes | Reference for the metric attached to the business object. | |
TRANSACTION_CURRENCY_CODE | VARCHAR2 | (15) | Transactional currency code for the COST type metric. | |
TRANS_FORECASTED_VALUE | NUMBER | Transactional forecast value for the metric. | ||
TRANS_COMMITTED_VALUE | NUMBER | Transactional commited value for the metric. | ||
TRANS_ACTUAL_VALUE | NUMBER | Transactional actual value for the metric. | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code for COST type metric. | |
FUNC_FORECASTED_VALUE | NUMBER | Functional forecast value for the metric. | ||
DIRTY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate that this metric needs to be refreshed. |
FUNC_COMMITTED_VALUE | NUMBER | Functional commited value for the metric. | ||
FUNC_ACTUAL_VALUE | NUMBER | Functional actual value for the metric. | ||
LAST_CALCULATED_DATE | DATE | Date the metric was last refreshed. | ||
VARIABLE_VALUE | NUMBER | The per-unit value for a variable type metric. | ||
COMPUTED_USING_FUNCTION_VALUE | NUMBER | Stores the number of units involved in the computation of a variable metric. | ||
METRIC_UOM_CODE | VARCHAR2 | (3) | Unit of measure for the metric. | |
ORG_ID | NUMBER | (32) | Operating unit which performed this transaction. | |
DIFFERENCE_SINCE_LAST_CALC | NUMBER | Difference in actual value since the metric was last refreshed. | ||
ACTIVITY_METRIC_ORIGIN_ID | NUMBER | References the ID of an associated object for an apportioned metric. | ||
ARC_ACTIVITY_METRIC_ORIGIN | VARCHAR2 | (30) | The type of object involved in the computation of an apportioned metric. | |
DAYS_SINCE_LAST_REFRESH | NUMBER | (15) | Number of days since the metric was refreshed last. | |
SCENARIO_ID | NUMBER | References the metric scenario. | ||
SUMMARIZE_TO_METRIC | NUMBER | References the activity metric to which this metric should be summarized. | ||
ROLLUP_TO_METRIC | NUMBER | References the activity metric to which this metric should be rolled-up. | ||
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. | |
HIERARCHY_ID | NUMBER | Foreign key to associated Hierarchy | ||
START_NODE | NUMBER | The Node on a hierarchy to begin traversal | ||
FROM_LEVEL | NUMBER | The Level of the Hierarchy which the start node belongs to. | ||
TO_LEVEL | NUMBER | The Lowest Level on the hierarchy to stop traversal . | ||
FROM_DATE | DATE | The Start date period to restrict metric calculations. | ||
TO_DATE | DATE | The End date period to restrict metric calcaulations. | ||
AMOUNT1 | NUMBER | A generic Amount which can be used in metric calculations. | ||
AMOUNT2 | NUMBER | A generic Amount which can be used in metric calculations. | ||
AMOUNT3 | NUMBER | A generic Amount which can be used in metric calculations. | ||
PERCENT1 | NUMBER | (3) | A Generic percentage amount which can be used in metric calculations. | |
PERCENT2 | NUMBER | (3) | A Generic percentage amount which can be used in metric calculations. | |
PERCENT3 | NUMBER | (3) | A Generic percentage amount which can be used in metric calculations. | |
PUBLISHED_FLAG | VARCHAR2 | (1) | Indicates if the metric results have been published. | |
PRE_FUNCTION_NAME | VARCHAR2 | (4000) | The Pre Function to execute before metric calculations. | |
POST_FUNCTION_NAME | VARCHAR2 | (4000) | The Post Function to execute after metric calculations. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
DESCRIPTION | VARCHAR2 | (4000) | Description of each metrics | |
ACT_METRIC_DATE | DATE | Metrics transaction date | ||
DEPEND_ACT_METRIC | NUMBER | Depend metrics | ||
FUNCTION_USED_BY_ID | NUMBER | Reference to an object for function metrics to determine unique data. | ||
ARC_FUNCTION_USED_BY | VARCHAR2 | (30) | Reference to an object type for a function metric to determine unique data. | |
STATUS_CODE | VARCHAR2 | (30) | Status Code : Used for Fund Allocation | |
ACTION_CODE | VARCHAR2 | (30) | Action Code : Used for Fund Allocation | |
METHOD_CODE | VARCHAR2 | (30) | Method Code : Used for Fund Allocation | |
BASIS_YEAR | NUMBER | Basis Year : Used for Fund Allocation | ||
EX_START_NODE | VARCHAR2 | (1) | Exclude Start Node Flag : Used for Fund Allocation | |
HIERARCHY_TYPE | VARCHAR2 | (30) | Used for budget allocation; currently supports territory and budget hierarchy. | |
FORECASTED_VARIABLE_VALUE | NUMBER | The per-unit value for a variable type metric used for calculating the forecast value. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_METRIC_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ACT_METRIC_USED_BY_ID
, ARC_ACT_METRIC_USED_BY
, PURCHASE_REQ_RAISED_FLAG
, APPLICATION_ID
, SENSITIVE_DATA_FLAG
, BUDGET_ID
, METRIC_ID
, TRANSACTION_CURRENCY_CODE
, TRANS_FORECASTED_VALUE
, TRANS_COMMITTED_VALUE
, TRANS_ACTUAL_VALUE
, FUNCTIONAL_CURRENCY_CODE
, FUNC_FORECASTED_VALUE
, DIRTY_FLAG
, FUNC_COMMITTED_VALUE
, FUNC_ACTUAL_VALUE
, LAST_CALCULATED_DATE
, VARIABLE_VALUE
, COMPUTED_USING_FUNCTION_VALUE
, METRIC_UOM_CODE
, ORG_ID
, DIFFERENCE_SINCE_LAST_CALC
, ACTIVITY_METRIC_ORIGIN_ID
, ARC_ACTIVITY_METRIC_ORIGIN
, DAYS_SINCE_LAST_REFRESH
, SCENARIO_ID
, SUMMARIZE_TO_METRIC
, ROLLUP_TO_METRIC
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, HIERARCHY_ID
, START_NODE
, FROM_LEVEL
, TO_LEVEL
, FROM_DATE
, TO_DATE
, AMOUNT1
, AMOUNT2
, AMOUNT3
, PERCENT1
, PERCENT2
, PERCENT3
, PUBLISHED_FLAG
, PRE_FUNCTION_NAME
, POST_FUNCTION_NAME
, SECURITY_GROUP_ID
, DESCRIPTION
, ACT_METRIC_DATE
, DEPEND_ACT_METRIC
, FUNCTION_USED_BY_ID
, ARC_FUNCTION_USED_BY
, STATUS_CODE
, ACTION_CODE
, METHOD_CODE
, BASIS_YEAR
, EX_START_NODE
, HIERARCHY_TYPE
, FORECASTED_VARIABLE_VALUE
FROM AMS.AMS_ACT_METRICS_ALL;
AMS.AMS_ACT_METRICS_ALL does not reference any database object
AMS.AMS_ACT_METRICS_ALL is referenced by following:
|
|
|