View: AMS_METRICS_VL

Product:	AMS - Marketing
Description:	This view returns the details of Metrics measures that can be used by an activity.
Implementation/DBA Data:	APPS.AMS_METRICS_VL

View Text

SELECT B.ROWID ROW_ID
, B.METRIC_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.APPLICATION_ID
, B.ARC_METRIC_USED_FOR_OBJECT
, B.METRIC_CALCULATION_TYPE
, B.METRIC_CATEGORY
, B.ACCRUAL_TYPE
, B.VALUE_TYPE
, B.SENSITIVE_DATA_FLAG
, B.ENABLED_FLAG
, B.METRIC_SUB_CATEGORY
, B.FUNCTION_NAME
, B.METRIC_PARENT_ID
, B.SUMMARY_METRIC_ID
, B.COMPUTE_USING_FUNCTION
, B.DEFAULT_UOM_CODE
, B.UOM_TYPE
, B.FORMULA
, T.METRICS_NAME
, T.DESCRIPTION
, B.HIERARCHY_ID
, B.SET_FUNCTION_NAME
, B.FUNCTION_TYPE
, B.DISPLAY_TYPE
, T.FORMULA_DISPLAY
, B.TARGET_TYPE
, B.DENORM_CODE
FROM AMS_METRICS_ALL_TL T
, AMS_METRICS_ALL_B B
WHERE B.METRIC_ID = T.METRIC_ID
AND T.LANGUAGE = USERENV('LANG')

Columns