VIEW: APPS.AMS_METRICS_INFO_V

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.METRIC_ID ,T.METRICS_NAME ,B.SENSITIVE_DATA_FLAG ,B.ENABLED_FLAG ,B.CREATION_DATE ,B.CREATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_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 METRIC_CATEGORY_MEANING ,B.METRIC_SUB_CATEGORY ,C2.CATEGORY_NAME METRIC_SUB_CATEGORY_MEANING ,B.ACCRUAL_TYPE ,B.VALUE_TYPE ,L.MEANING VALUE_TYPE_MEANING ,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.HIERARCHY_ID ,B.SET_FUNCTION_NAME ,T.DESCRIPTION FROM AMS_METRICS_ALL_B B ,AMS_METRICS_ALL_TL T ,AMS_CATEGORIES_VL C1 ,AMS_CATEGORIES_VL C2 ,AMS_LOOKUPS L WHERE B.METRIC_ID = T.METRIC_ID and T.LANGUAGE = userenv('LANG') and 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

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.METRIC_ID
, T.METRICS_NAME
, B.SENSITIVE_DATA_FLAG
, B.ENABLED_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_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 METRIC_CATEGORY_MEANING
, B.METRIC_SUB_CATEGORY
, C2.CATEGORY_NAME METRIC_SUB_CATEGORY_MEANING
, B.ACCRUAL_TYPE
, B.VALUE_TYPE
, L.MEANING VALUE_TYPE_MEANING
, 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.HIERARCHY_ID
, B.SET_FUNCTION_NAME
, T.DESCRIPTION
FROM AMS_METRICS_ALL_B B
, AMS_METRICS_ALL_TL T
, AMS_CATEGORIES_VL C1
, AMS_CATEGORIES_VL C2
, AMS_LOOKUPS L
WHERE B.METRIC_ID = T.METRIC_ID
AND T.LANGUAGE = USERENV('LANG')
AND 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