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_ACT_METRIC_HST

Object Details

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

AMS_ACT_METRIC_HST store daily changes to the AMS_ACT_METRICS_ALL table. The metrics refresh engine determines which records have changed and records the entire AMS_ACT_METRICS_ALL record. The data in this table can be used to analyze the historic variation of metrics.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_METRIC_HST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACT_MET_HST_ID
AMS_ACT_METRIC_HST_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
AMS_ACT_METRIC_HST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_ACT_METRIC_USED_BY ACT_METRIC_USED_BY_ID
AMS_ACT_METRIC_HST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	METRIC_ID
AMS_ACT_METRIC_HST_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CURRENCY_CODE
AMS_ACT_METRIC_HST_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTIONAL_CURRENCY_CODE
AMS_ACT_METRIC_HST_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
AMS_ACT_METRIC_HST_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	METRIC_UOM_CODE
AMS_ACT_METRIC_HST_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_METRIC_ID LAST_UPDATE_DATE
AMS_ACT_METRIC_HST_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_FUNCTION_USED_BY FUNCTION_USED_BY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACT_MET_HST_ID	NUMBER		Yes	Unique identifier.
ACTIVITY_METRIC_ID	NUMBER		Yes	Forgien key to AMS_ACT_METRICS_ALL
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 .
ACT_METRIC_USED_BY_ID	NUMBER			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)		Column contains the kind of object using a specific metirc, for example, CAMP for Campaign.
APPLICATION_ID	NUMBER		Yes	Standard column to indicate the application using this 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.
FUNC_COMMITTED_VALUE	NUMBER			Functional commited value for the metric.
DIRTY_FLAG	VARCHAR2	(1)		Flag to indicate that this metric needs to be refreshed.
FUNC_ACTUAL_VALUE	NUMBER			Functional actual value for the metric.
LAST_CALCULATED_DATE	DATE			When this record 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 identifier.
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.
SUMMARIZE_TO_METRIC	NUMBER			References the activity metric to which this metric is summarized.
ROLLUP_TO_METRIC	NUMBER			References the activity metric to which this metric is rolled-up.
SCENARIO_ID	NUMBER			References the metric scenario.
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
FUNC_FORECASTED_DELTA	NUMBER			The difference in the forecasted value since the previous recorded history.
FUNC_ACTUAL_DELTA	NUMBER			The difference in the forecasted value since the previous recorded history.
DESCRIPTION	VARCHAR2	(4000)		User entered description.
ACT_METRIC_DATE	DATE			User indicated transaction date.
ARC_FUNCTION_USED_BY	VARCHAR2	(30)		Object type for reference by function metrics.
FUNCTION_USED_BY_ID	NUMBER			Object id for reference by function metrics.
PURCHASE_REQ_RAISED_FLAG	VARCHAR2	(1)		Flag to indicate if a purchase order was raised for this Cost type metric.
SENSITIVE_DATA_FLAG	VARCHAR2	(1)		Flag to indicate if this is a confidential metric.
BUDGET_ID	NUMBER			Reference for the Budget attached to the metric.
FORECASTED_VARIABLE_VALUE	NUMBER			The per-unit value for a variable type metric used for calculating the forecast value.
HIERARCHY_ID	NUMBER			Foreign key to associated Hierarchy
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.
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.
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.
DEPEND_ACT_METRIC	NUMBER			Depend metrics

Query Text

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


SELECT ACT_MET_HST_ID
,      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
,      APPLICATION_ID
,      METRIC_ID
,      TRANSACTION_CURRENCY_CODE
,      TRANS_FORECASTED_VALUE
,      TRANS_COMMITTED_VALUE
,      TRANS_ACTUAL_VALUE
,      FUNCTIONAL_CURRENCY_CODE
,      FUNC_FORECASTED_VALUE
,      FUNC_COMMITTED_VALUE
,      DIRTY_FLAG
,      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
,      SUMMARIZE_TO_METRIC
,      ROLLUP_TO_METRIC
,      SCENARIO_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      FUNC_FORECASTED_DELTA
,      FUNC_ACTUAL_DELTA
,      DESCRIPTION
,      ACT_METRIC_DATE
,      ARC_FUNCTION_USED_BY
,      FUNCTION_USED_BY_ID
,      PURCHASE_REQ_RAISED_FLAG
,      SENSITIVE_DATA_FLAG
,      BUDGET_ID
,      FORECASTED_VARIABLE_VALUE
,      HIERARCHY_ID
,      PUBLISHED_FLAG
,      PRE_FUNCTION_NAME
,      POST_FUNCTION_NAME
,      START_NODE
,      FROM_LEVEL
,      TO_LEVEL
,      FROM_DATE
,      TO_DATE
,      AMOUNT1
,      AMOUNT2
,      AMOUNT3
,      PERCENT1
,      PERCENT2
,      PERCENT3
,      STATUS_CODE
,      ACTION_CODE
,      METHOD_CODE
,      BASIS_YEAR
,      EX_START_NODE
,      HIERARCHY_TYPE
,      DEPEND_ACT_METRIC
FROM AMS.AMS_ACT_METRIC_HST;

Dependencies

[top of page]

AMS.AMS_ACT_METRIC_HST does not reference any database object

AMS.AMS_ACT_METRIC_HST is referenced by following:

APPS: AMS_ACT_METRICS_MONTHLY_MV; AMS_ACT_METRICS_QTRLY_MV; AMS_ACT_METRICS_WEEKLY_MV; AMS_ACT_METRICS_YEARLY_MV; AMS_ACT_METRIC_HST