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_METRICS_ALL

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUMMARIZE_TO_METRIC
AMS_ACT_METRICS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROLLUP_TO_METRIC
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

Columns

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.

Query Text

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;

Dependencies

[top of page]

AMS.AMS_ACT_METRICS_ALL does not reference any database object

AMS.AMS_ACT_METRICS_ALL is referenced by following:

AMS: AMS_ACT_METRICS_ALL#