VIEW: APPS.AMS_METRICS_VL

Source

View Text - Preformatted

SELECT B.ROWID 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, B.ACCRUAL_TYPE, B.VALUE_TYPE, B.SENSITIVE_DATA_FLAG, B.ENABLED_FLAG, B.METRIC_SUB_CATEGORY, B.FUNCTION_NAME, B.METRIC_PARENT_ID, B.SUMMARY_METRIC_ID, B.COMPUTE_USING_FUNCTION, B.DEFAULT_UOM_CODE, B.UOM_TYPE, B.FORMULA, T.METRICS_NAME, T.DESCRIPTION, B.HIERARCHY_ID, B.SET_FUNCTION_NAME, B.FUNCTION_TYPE, B.DISPLAY_TYPE, T.FORMULA_DISPLAY, B.TARGET_TYPE, B.DENORM_CODE from AMS_METRICS_ALL_TL T, AMS_METRICS_ALL_B B WHERE B.METRIC_ID = T.METRIC_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID 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
, B.ACCRUAL_TYPE
, B.VALUE_TYPE
, B.SENSITIVE_DATA_FLAG
, B.ENABLED_FLAG
, B.METRIC_SUB_CATEGORY
, B.FUNCTION_NAME
, B.METRIC_PARENT_ID
, B.SUMMARY_METRIC_ID
, B.COMPUTE_USING_FUNCTION
, B.DEFAULT_UOM_CODE
, B.UOM_TYPE
, B.FORMULA
, T.METRICS_NAME
, T.DESCRIPTION
, B.HIERARCHY_ID
, B.SET_FUNCTION_NAME
, B.FUNCTION_TYPE
, B.DISPLAY_TYPE
, T.FORMULA_DISPLAY
, B.TARGET_TYPE
, B.DENORM_CODE
FROM AMS_METRICS_ALL_TL T
, AMS_METRICS_ALL_B B
WHERE B.METRIC_ID = T.METRIC_ID
AND T.LANGUAGE = USERENV('LANG')