VIEW: APPS.FND_OAM_METVAL_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.METRIC_SHORT_NAME, B.METRIC_VALUE, B.STATUS_CODE, B.GROUP_ID, B.SEQUENCE, B.NODE_NAME, B.METRIC_TYPE, B.THRESHOLD_OPERATOR, B.THRESHOLD_VALUE, B.ALERT_ENABLED_FLAG, B.COLLECTION_ENABLED_FLAG, B.LAST_COLLECTED_DATE, B.IS_SUPPORTED, B.IS_CUSTOMIZED, B.INTERVAL_COUNTER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.METRIC_DISPLAY_NAME, T.DESCRIPTION FROM FND_OAM_METS_TL T, FND_OAM_METVAL B WHERE B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.METRIC_SHORT_NAME
, B.METRIC_VALUE
, B.STATUS_CODE
, B.GROUP_ID
, B.SEQUENCE
, B.NODE_NAME
, B.METRIC_TYPE
, B.THRESHOLD_OPERATOR
, B.THRESHOLD_VALUE
, B.ALERT_ENABLED_FLAG
, B.COLLECTION_ENABLED_FLAG
, B.LAST_COLLECTED_DATE
, B.IS_SUPPORTED
, B.IS_CUSTOMIZED
, B.INTERVAL_COUNTER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.METRIC_DISPLAY_NAME
, T.DESCRIPTION
FROM FND_OAM_METS_TL T
, FND_OAM_METVAL B
WHERE B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME
AND T.LANGUAGE = USERENV('LANG')