VIEW: AMS.AMS_ACT_METRICS_ALL#

Source

View Text - Preformatted

select ACTIVITY_METRIC_ID ACTIVITY_METRIC_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACT_METRIC_USED_BY_ID ACT_METRIC_USED_BY_ID, ARC_ACT_METRIC_USED_BY ARC_ACT_METRIC_USED_BY, PURCHASE_REQ_RAISED_FLAG PURCHASE_REQ_RAISED_FLAG, APPLICATION_ID APPLICATION_ID, SENSITIVE_DATA_FLAG SENSITIVE_DATA_FLAG, BUDGET_ID BUDGET_ID, METRIC_ID METRIC_ID, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, TRANS_FORECASTED_VALUE TRANS_FORECASTED_VALUE, TRANS_COMMITTED_VALUE TRANS_COMMITTED_VALUE, TRANS_ACTUAL_VALUE TRANS_ACTUAL_VALUE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, FUNC_FORECASTED_VALUE FUNC_FORECASTED_VALUE, DIRTY_FLAG DIRTY_FLAG, FUNC_COMMITTED_VALUE FUNC_COMMITTED_VALUE, FUNC_ACTUAL_VALUE FUNC_ACTUAL_VALUE, LAST_CALCULATED_DATE LAST_CALCULATED_DATE, VARIABLE_VALUE VARIABLE_VALUE, COMPUTED_USING_FUNCTION_VALUE COMPUTED_USING_FUNCTION_VALUE, METRIC_UOM_CODE METRIC_UOM_CODE, ORG_ID ORG_ID, DIFFERENCE_SINCE_LAST_CALC DIFFERENCE_SINCE_LAST_CALC, ACTIVITY_METRIC_ORIGIN_ID ACTIVITY_METRIC_ORIGIN_ID, ARC_ACTIVITY_METRIC_ORIGIN ARC_ACTIVITY_METRIC_ORIGIN, DAYS_SINCE_LAST_REFRESH DAYS_SINCE_LAST_REFRESH, SCENARIO_ID SCENARIO_ID, SUMMARIZE_TO_METRIC SUMMARIZE_TO_METRIC, ROLLUP_TO_METRIC ROLLUP_TO_METRIC, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, HIERARCHY_ID HIERARCHY_ID, START_NODE START_NODE, FROM_LEVEL FROM_LEVEL, TO_LEVEL TO_LEVEL, FROM_DATE FROM_DATE, TO_DATE TO_DATE, AMOUNT1 AMOUNT1, AMOUNT2 AMOUNT2, AMOUNT3 AMOUNT3, PERCENT1 PERCENT1, PERCENT2 PERCENT2, PERCENT3 PERCENT3, PUBLISHED_FLAG PUBLISHED_FLAG, PRE_FUNCTION_NAME PRE_FUNCTION_NAME, POST_FUNCTION_NAME POST_FUNCTION_NAME, SECURITY_GROUP_ID SECURITY_GROUP_ID, DESCRIPTION DESCRIPTION, ACT_METRIC_DATE ACT_METRIC_DATE, DEPEND_ACT_METRIC DEPEND_ACT_METRIC, FUNCTION_USED_BY_ID FUNCTION_USED_BY_ID, ARC_FUNCTION_USED_BY ARC_FUNCTION_USED_BY, STATUS_CODE STATUS_CODE, ACTION_CODE ACTION_CODE, METHOD_CODE METHOD_CODE, BASIS_YEAR BASIS_YEAR, EX_START_NODE EX_START_NODE, HIERARCHY_TYPE HIERARCHY_TYPE, FORECASTED_VARIABLE_VALUE FORECASTED_VARIABLE_VALUE from "AMS"."AMS_ACT_METRICS_ALL"

View Text - HTML Formatted

SELECT ACTIVITY_METRIC_ID ACTIVITY_METRIC_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT_METRIC_USED_BY_ID ACT_METRIC_USED_BY_ID
, ARC_ACT_METRIC_USED_BY ARC_ACT_METRIC_USED_BY
, PURCHASE_REQ_RAISED_FLAG PURCHASE_REQ_RAISED_FLAG
, APPLICATION_ID APPLICATION_ID
, SENSITIVE_DATA_FLAG SENSITIVE_DATA_FLAG
, BUDGET_ID BUDGET_ID
, METRIC_ID METRIC_ID
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, TRANS_FORECASTED_VALUE TRANS_FORECASTED_VALUE
, TRANS_COMMITTED_VALUE TRANS_COMMITTED_VALUE
, TRANS_ACTUAL_VALUE TRANS_ACTUAL_VALUE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, FUNC_FORECASTED_VALUE FUNC_FORECASTED_VALUE
, DIRTY_FLAG DIRTY_FLAG
, FUNC_COMMITTED_VALUE FUNC_COMMITTED_VALUE
, FUNC_ACTUAL_VALUE FUNC_ACTUAL_VALUE
, LAST_CALCULATED_DATE LAST_CALCULATED_DATE
, VARIABLE_VALUE VARIABLE_VALUE
, COMPUTED_USING_FUNCTION_VALUE COMPUTED_USING_FUNCTION_VALUE
, METRIC_UOM_CODE METRIC_UOM_CODE
, ORG_ID ORG_ID
, DIFFERENCE_SINCE_LAST_CALC DIFFERENCE_SINCE_LAST_CALC
, ACTIVITY_METRIC_ORIGIN_ID ACTIVITY_METRIC_ORIGIN_ID
, ARC_ACTIVITY_METRIC_ORIGIN ARC_ACTIVITY_METRIC_ORIGIN
, DAYS_SINCE_LAST_REFRESH DAYS_SINCE_LAST_REFRESH
, SCENARIO_ID SCENARIO_ID
, SUMMARIZE_TO_METRIC SUMMARIZE_TO_METRIC
, ROLLUP_TO_METRIC ROLLUP_TO_METRIC
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, HIERARCHY_ID HIERARCHY_ID
, START_NODE START_NODE
, FROM_LEVEL FROM_LEVEL
, TO_LEVEL TO_LEVEL
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, AMOUNT1 AMOUNT1
, AMOUNT2 AMOUNT2
, AMOUNT3 AMOUNT3
, PERCENT1 PERCENT1
, PERCENT2 PERCENT2
, PERCENT3 PERCENT3
, PUBLISHED_FLAG PUBLISHED_FLAG
, PRE_FUNCTION_NAME PRE_FUNCTION_NAME
, POST_FUNCTION_NAME POST_FUNCTION_NAME
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DESCRIPTION DESCRIPTION
, ACT_METRIC_DATE ACT_METRIC_DATE
, DEPEND_ACT_METRIC DEPEND_ACT_METRIC
, FUNCTION_USED_BY_ID FUNCTION_USED_BY_ID
, ARC_FUNCTION_USED_BY ARC_FUNCTION_USED_BY
, STATUS_CODE STATUS_CODE
, ACTION_CODE ACTION_CODE
, METHOD_CODE METHOD_CODE
, BASIS_YEAR BASIS_YEAR
, EX_START_NODE EX_START_NODE
, HIERARCHY_TYPE HIERARCHY_TYPE
, FORECASTED_VARIABLE_VALUE FORECASTED_VARIABLE_VALUE
FROM "AMS"."AMS_ACT_METRICS_ALL"