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]

VIEW: APPS.AMS_METRICS_VL

Object Details

Object Name:	AMS_METRICS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_METRICS_VL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
METRIC_ID	NUMBER		Yes	Metrics ID
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATED_BY	NUMBER	(15)	Yes	last update by
CREATION_DATE	DATE		Yes	creation date
CREATED_BY	NUMBER	(15)	Yes	created by
LAST_UPDATE_LOGIN	NUMBER	(15)		last updated user
OBJECT_VERSION_NUMBER	NUMBER	(9)		object version number
APPLICATION_ID	NUMBER		Yes	Application ID
ARC_METRIC_USED_FOR_OBJECT	VARCHAR2	(30)	Yes	Metrics is being used by which object
METRIC_CALCULATION_TYPE	VARCHAR2	(30)	Yes	Metrics calculation type
METRIC_CATEGORY	NUMBER			category of metrics definition
ACCRUAL_TYPE	VARCHAR2	(30)	Yes	Metrics accural type
VALUE_TYPE	VARCHAR2	(30)	Yes	metrics value type
SENSITIVE_DATA_FLAG	VARCHAR2	(1)	Yes	Is it sensitive data
ENABLED_FLAG	VARCHAR2	(1)	Yes	is it enabled
METRIC_SUB_CATEGORY	NUMBER			Sub category of the metrics
FUNCTION_NAME	VARCHAR2	(4000)		For function metrics, the function name
METRIC_PARENT_ID	NUMBER			For metrics hierarchy, the parent metrics
SUMMARY_METRIC_ID	NUMBER			The metrics could be summary to another metrics
COMPUTE_USING_FUNCTION	VARCHAR2	(4000)		Compute the metrics using this function
DEFAULT_UOM_CODE	VARCHAR2	(3)		Defult unit of measure code
UOM_TYPE	VARCHAR2	(10)		Unit of measure type
FORMULA	VARCHAR2	(4000)		Formula used to define the metrics
METRICS_NAME	VARCHAR2	(120)	Yes	The metrics name
DESCRIPTION	VARCHAR2	(4000)		The description of the metrics
HIERARCHY_ID	NUMBER			Hierarchy ID for the metrics
SET_FUNCTION_NAME	VARCHAR2	(4000)		Function name for metrics
FUNCTION_TYPE	VARCHAR2	(1)		is it a function or a procedure
DISPLAY_TYPE	VARCHAR2	(30)
FORMULA_DISPLAY	VARCHAR2	(4000)
TARGET_TYPE	VARCHAR2	(30)
DENORM_CODE	VARCHAR2	(30)

Query Text

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


SELECT ROW_ID
,      METRIC_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      ARC_METRIC_USED_FOR_OBJECT
,      METRIC_CALCULATION_TYPE
,      METRIC_CATEGORY
,      ACCRUAL_TYPE
,      VALUE_TYPE
,      SENSITIVE_DATA_FLAG
,      ENABLED_FLAG
,      METRIC_SUB_CATEGORY
,      FUNCTION_NAME
,      METRIC_PARENT_ID
,      SUMMARY_METRIC_ID
,      COMPUTE_USING_FUNCTION
,      DEFAULT_UOM_CODE
,      UOM_TYPE
,      FORMULA
,      METRICS_NAME
,      DESCRIPTION
,      HIERARCHY_ID
,      SET_FUNCTION_NAME
,      FUNCTION_TYPE
,      DISPLAY_TYPE
,      FORMULA_DISPLAY
,      TARGET_TYPE
,      DENORM_CODE
FROM APPS.AMS_METRICS_VL;

Dependencies

[top of page]

APPS.AMS_METRICS_VL references the following:

APPS: AMS_METRICS_ALL_B; AMS_METRICS_ALL_TL

APPS.AMS_METRICS_VL is referenced by following:

APPS: AMS_ACTMETRIC_PVT - show dependent code; AMS_METRIC_FORMULA_PVT - show dependent code; AMS_METRIC_PVT - show dependent code; AMS_METRIC_TEMPLATE_PVT - show dependent code; AMS_P_ACT_METRICS_V; AMS_P_METRICS_V; AMS_REFRESHMETRIC_PVT - show dependent code; AMS_WFTRIG_PVT - show dependent code