DBA Data[Home] [Help]

VIEW: MTH.MTH_ITEM_HIERARCHY_ERR#

Source

View Text - Preformatted

select LEVEL_FK LEVEL_FK, PARENT_FK PARENT_FK, HIERARCHY_NAME HIERARCHY_NAME, LEVEL_NUM LEVEL_NUM, SYSTEM_FK SYSTEM_FK, REPROCESS_READY_YN REPROCESS_READY_YN, 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_ITEM_HIERARCHY_ERR"
View Text - HTML Formatted

SELECT LEVEL_FK LEVEL_FK
, PARENT_FK PARENT_FK
, HIERARCHY_NAME HIERARCHY_NAME
, LEVEL_NUM LEVEL_NUM
, SYSTEM_FK SYSTEM_FK
, REPROCESS_READY_YN REPROCESS_READY_YN
, 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_ITEM_HIERARCHY_ERR"