VIEW: MTH.MTH_DIM_HIERARCHY_ERR#

Source

View Text - Preformatted

select DIMENSION_NAME DIMENSION_NAME, HIERARCHY_NAME HIERARCHY_NAME, CATEGORY_SET_NAME CATEGORY_SET_NAME, HIERARCHY_DISPLAY_NAME HIERARCHY_DISPLAY_NAME, NUMBER_OF_LEVEL NUMBER_OF_LEVEL, PROCESSING_FLAG PROCESSING_FLAG, ERR$$$_AUDIT_RUN_ID ERR$$$_AUDIT_RUN_ID, ERR$$$_AUDIT_DETAIL_ID ERR$$$_AUDIT_DETAIL_ID, ERR$$$_ERROR_ID ERR$$$_ERROR_ID, ERR$$$_ERROR_REASON ERR$$$_ERROR_REASON, ERR$$$_SEVERITY ERR$$$_SEVERITY, ERR$$$_OPERATOR_NAME ERR$$$_OPERATOR_NAME, ERR$$$_ERROR_OBJECT_NAME ERR$$$_ERROR_OBJECT_NAME, ERR_CODE ERR_CODE, REPROCESS_READY_YN REPROCESS_READY_YN from "MTH"."MTH_DIM_HIERARCHY_ERR"

View Text - HTML Formatted

SELECT DIMENSION_NAME DIMENSION_NAME
, HIERARCHY_NAME HIERARCHY_NAME
, CATEGORY_SET_NAME CATEGORY_SET_NAME
, HIERARCHY_DISPLAY_NAME HIERARCHY_DISPLAY_NAME
, NUMBER_OF_LEVEL NUMBER_OF_LEVEL
, PROCESSING_FLAG PROCESSING_FLAG
, ERR$$$_AUDIT_RUN_ID ERR$$$_AUDIT_RUN_ID
, ERR$$$_AUDIT_DETAIL_ID ERR$$$_AUDIT_DETAIL_ID
, ERR$$$_ERROR_ID ERR$$$_ERROR_ID
, ERR$$$_ERROR_REASON ERR$$$_ERROR_REASON
, ERR$$$_SEVERITY ERR$$$_SEVERITY
, ERR$$$_OPERATOR_NAME ERR$$$_OPERATOR_NAME
, ERR$$$_ERROR_OBJECT_NAME ERR$$$_ERROR_OBJECT_NAME
, ERR_CODE ERR_CODE
, REPROCESS_READY_YN REPROCESS_READY_YN
FROM "MTH"."MTH_DIM_HIERARCHY_ERR"