VIEW: APPS.AMS_P_METRICS_V

Source

View Text - Preformatted

SELECT B.ROW_ID 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, C1.CATEGORY_NAME, B.METRIC_SUB_CATEGORY, C2.CATEGORY_NAME, B.ACCRUAL_TYPE, B.VALUE_TYPE, L.MEANING, B.SENSITIVE_DATA_FLAG, B.ENABLED_FLAG, 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.METRICS_NAME, B.DESCRIPTION, B.HIERARCHY_ID, B.SET_FUNCTION_NAME from AMS_METRICS_VL B, AMS_CATEGORIES_VL C1, AMS_CATEGORIES_VL C2, AMS_LOOKUPS L WHERE 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.ROW_ID 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
, C1.CATEGORY_NAME
, B.METRIC_SUB_CATEGORY
, C2.CATEGORY_NAME
, B.ACCRUAL_TYPE
, B.VALUE_TYPE
, L.MEANING
, B.SENSITIVE_DATA_FLAG
, B.ENABLED_FLAG
, 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.METRICS_NAME
, B.DESCRIPTION
, B.HIERARCHY_ID
, B.SET_FUNCTION_NAME
FROM AMS_METRICS_VL B
, AMS_CATEGORIES_VL C1
, AMS_CATEGORIES_VL C2
, AMS_LOOKUPS L
WHERE 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