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_METRIC_FORMULAS

Object Details

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

AMS_METRIC_FORMULAS Describes the elements that make up formula type metric. Formula metrics require the definition of the components of the formula. These include the a description of the variables and operators used to compute the results. The formulas are saved in two formats. One: Infix notation for user editing and easy comprehension. Two: Postfix notation to use when computing the values for the simplest and fast processing.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_METRIC_FORMULAS_U1	NORMAL	UNIQUE	APPS_TS_SEED	METRIC_FORMULA_ID
AMS_METRIC_FORMULAS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	METRIC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
METRIC_FORMULA_ID	NUMBER		Yes	Unique Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column.
CREATION_DATE	DATE		Yes	Standard WHO Column.
CREATED_BY	NUMBER		Yes	Standard WHO Column.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO Column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number used for record locking.
METRIC_ID	NUMBER		Yes	Reference to the metric which the formula elements are associated.
SOURCE_TYPE	VARCHAR2	(30)	Yes	The source of data from which the formula elements are coming.
SOURCE_ID	NUMBER			Reference to the source data.
SOURCE_SUB_ID	NUMBER			References the sub-category ID if the source is a category.
USE_SUB_ID_FLAG	VARCHAR2	(1)		Indicates whether to use the sub-category ID.
TOKEN	VARCHAR2	(120)		The source value for an operator.
SOURCE_VALUE	NUMBER			The value for a numeric source.
SEQUENCE	NUMBER	(15)	Yes	The sequence in which the formula elements are used to calculate the formula.
NOTATION_TYPE	VARCHAR2	(30)	Yes	Indicates postfix or infix notation.
SECURITY_GROUP_ID	NUMBER			Used in a hosting environment.

Query Text

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


SELECT METRIC_FORMULA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      METRIC_ID
,      SOURCE_TYPE
,      SOURCE_ID
,      SOURCE_SUB_ID
,      USE_SUB_ID_FLAG
,      TOKEN
,      SOURCE_VALUE
,      SEQUENCE
,      NOTATION_TYPE
,      SECURITY_GROUP_ID
FROM AMS.AMS_METRIC_FORMULAS;

Dependencies

[top of page]

AMS.AMS_METRIC_FORMULAS does not reference any database object

AMS.AMS_METRIC_FORMULAS is referenced by following:

APPS: AMS_METRIC_FORMULAS