VIEW: APPS.AMS_P_ACT_METRICS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)