Product: | AMS - Marketing |
---|---|
Description: | This public view returns the metrics that will be tracked for marketing activities. |
Implementation/DBA Data: | APPS.AMS_P_ACT_METRICS_V |
SELECT B.ROWID ROW_ID
, B.ACTIVITY_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.ACT_METRIC_USED_BY_ID
, B.ARC_ACT_METRIC_USED_BY
, B.PURCHASE_REQ_RAISED_FLAG
, B.APPLICATION_ID
, B.SENSITIVE_DATA_FLAG
, B.BUDGET_ID
, B.METRIC_ID
, M.METRICS_NAME
, M.METRIC_CALCULATION_TYPE
, M.METRIC_CATEGORY CATEGORY_ID
, C1.CATEGORY_NAME METRIC_CATEGORY
, M.METRIC_SUB_CATEGORY SUB_CATEGORY_ID
, C2.CATEGORY_NAME METRIC_SUB_CATEGORY
, DECODE(M.ACCRUAL_TYPE
, 'VARIABLE'
, 'Y'
, 'N') VARIABLE_FLAG
, DECODE(M.VALUE_TYPE
, 'R'
, 'Y'
, 'N') RATIO_FLAG
, M.FUNCTION_NAME
, M.METRIC_PARENT_ID
, M.SUMMARY_METRIC_ID
, B.TRANSACTION_CURRENCY_CODE
, B.TRANS_FORECASTED_VALUE
, B.TRANS_COMMITTED_VALUE
, B.TRANS_ACTUAL_VALUE
, B.FUNCTIONAL_CURRENCY_CODE
, B.FUNC_FORECASTED_VALUE
, B.FUNC_COMMITTED_VALUE
, B.FUNC_ACTUAL_VALUE
, B.DIRTY_FLAG
, B.LAST_CALCULATED_DATE
, B.VARIABLE_VALUE
, B.COMPUTED_USING_FUNCTION_VALUE
, B.METRIC_UOM_CODE
, B.ORG_ID
, B.DIFFERENCE_SINCE_LAST_CALC
, B.ACTIVITY_METRIC_ORIGIN_ID
, B.DAYS_SINCE_LAST_REFRESH
, B.SUMMARIZE_TO_METRIC
, B.ROLLUP_TO_METRIC
, B.HIERARCHY_ID
, B.START_NODE
, B.FROM_LEVEL
, B.TO_LEVEL
, B.FROM_DATE
, B.TO_DATE
, B.AMOUNT1
, B.AMOUNT2
, B.AMOUNT3
, B.PERCENT1
, B.PERCENT2
, B.PERCENT3
, B.PUBLISHED_FLAG
, B.PRE_FUNCTION_NAME
, B.POST_FUNCTION_NAME
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.DESCRIPTION
, B.ACT_METRIC_DATE
, M.FUNCTION_TYPE
FROM AMS_ACT_METRICS_ALL B
, AMS_METRICS_VL M
, AMS_CATEGORIES_VL C1
, AMS_CATEGORIES_VL C2
WHERE B.METRIC_ID = M.METRIC_ID
AND M.METRIC_CATEGORY = C1.CATEGORY_ID(+)
AND M.METRIC_SUB_CATEGORY = C2.CATEGORY_ID(+)