Product: | AMS - Marketing |
---|---|
Description: | This public view returns the details of Metrics measures that can be used by an activity. |
Implementation/DBA Data: | APPS.AMS_P_METRICS_V |
SELECT B.ROW_ID 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
, C1.CATEGORY_NAME
, B.METRIC_SUB_CATEGORY
, C2.CATEGORY_NAME
, B.ACCRUAL_TYPE
, B.VALUE_TYPE
, L.MEANING
, B.SENSITIVE_DATA_FLAG
, B.ENABLED_FLAG
, B.FUNCTION_NAME
, B.METRIC_PARENT_ID
, B.SUMMARY_METRIC_ID
, B.COMPUTE_USING_FUNCTION
, B.DEFAULT_UOM_CODE
, B.UOM_TYPE
, B.FORMULA
, B.METRICS_NAME
, B.DESCRIPTION
, B.HIERARCHY_ID
, B.SET_FUNCTION_NAME
FROM AMS_METRICS_VL B
, AMS_CATEGORIES_VL C1
, AMS_CATEGORIES_VL C2
, AMS_LOOKUPS L
WHERE C1.CATEGORY_ID(+) = B.METRIC_CATEGORY
AND C2.CATEGORY_ID(+) = B.METRIC_SUB_CATEGORY
AND L.LOOKUP_TYPE = 'AMS_METRIC_VALUE_TYPE'
AND L.LOOKUP_CODE = B.VALUE_TYPE