View: AMS_ACT_METRIC_FORMULAS_V

Product:	AMS - Marketing
Description:	This View returns all formula details for an activity metric.
Implementation/DBA Data:	APPS.AMS_ACT_METRIC_FORMULAS_V

View Text

SELECT AMC.ACTIVITY_METRIC_ID
, AMC.ARC_ACT_METRIC_USED_BY
, AMC.ACT_METRIC_USED_BY_ID
, AMC.METRIC_ID
, MFM.FORMULA_ID
, MFM.PARENT_FORMULA_ID
, MFM.FORMULA_TYPE
, MFM.LEVEL_DEPTH
, MFE.FORMULA_ENTRY_ID
, MFE.ORDER_NUMBER
, MFE.FORMULA_ENTRY_TYPE
, MFE.FORMULA_ENTRY_VALUE
, MFE.FORMULA_ENTRY_OPERATOR
, MFE.METRIC_COLUMN_VALUE
FROM AMS_ACT_METRICS_ALL AMC
, AMS_ACT_METRIC_FORMULAS MFM
, AMS_ACT_METRIC_FORM_ENT MFE
WHERE AMC.ACTIVITY_METRIC_ID = MFM.ACTIVITY_METRIC_ID
AND MFM.FORMULA_ID = MFE.FORMULA_ID

Columns