VIEW: MTH.MTH_EQUIP_HIERARCHY_ERR#

Source

View Text - Preformatted

select HIERARCHY_NAME HIERARCHY_NAME, LEVEL_NUM LEVEL_NUM, LEVEL_FK LEVEL_FK, PARENT_FK PARENT_FK, SYSTEM_FK SYSTEM_FK, REPROCESS_READY_YN REPROCESS_READY_YN, EFFECTIVE_DATE EFFECTIVE_DATE, 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 from "MTH"."MTH_EQUIP_HIERARCHY_ERR"

View Text - HTML Formatted

SELECT HIERARCHY_NAME HIERARCHY_NAME
, LEVEL_NUM LEVEL_NUM
, LEVEL_FK LEVEL_FK
, PARENT_FK PARENT_FK
, SYSTEM_FK SYSTEM_FK
, REPROCESS_READY_YN REPROCESS_READY_YN
, EFFECTIVE_DATE EFFECTIVE_DATE
, 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
FROM "MTH"."MTH_EQUIP_HIERARCHY_ERR"