VIEW: MTH.MTH_RESOURCES_ERR#

Source

View Text - Preformatted

select RESOURCE_PK RESOURCE_PK, RESOURCE_TYPE RESOURCE_TYPE, EBS_RESOURCE_ID EBS_RESOURCE_ID, EBS_DEPARTMENT_ID EBS_DEPARTMENT_ID, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID, USAGE_UOM USAGE_UOM, CAPACITY_UNITS CAPACITY_UNITS, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG, SYSTEM_FK SYSTEM_FK, DISABLE_DATE DISABLE_DATE, RESOURCE_NAME RESOURCE_NAME, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_ATTR6 USER_ATTR6, USER_ATTR7 USER_ATTR7, USER_ATTR8 USER_ATTR8, USER_ATTR9 USER_ATTR9, USER_ATTR10 USER_ATTR10, USER_ATTR11 USER_ATTR11, USER_ATTR12 USER_ATTR12, USER_ATTR13 USER_ATTR13, USER_ATTR14 USER_ATTR14, USER_ATTR15 USER_ATTR15, USER_ATTR16 USER_ATTR16, USER_ATTR17 USER_ATTR17, USER_ATTR18 USER_ATTR18, USER_ATTR19 USER_ATTR19, USER_ATTR20 USER_ATTR20, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, REPROCESS_READY_YN REPROCESS_READY_YN, SOURCE_ORG_CODE SOURCE_ORG_CODE, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION, 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, STD_UTILIZATION STD_UTILIZATION, STD_EFFICIENCY STD_EFFICIENCY, ERR_CODE ERR_CODE, PRODUCTION_RESOURCE PRODUCTION_RESOURCE, STATUS STATUS, BUSINESS_FUNCTION BUSINESS_FUNCTION from "MTH"."MTH_RESOURCES_ERR"

View Text - HTML Formatted

SELECT RESOURCE_PK RESOURCE_PK
, RESOURCE_TYPE RESOURCE_TYPE
, EBS_RESOURCE_ID EBS_RESOURCE_ID
, EBS_DEPARTMENT_ID EBS_DEPARTMENT_ID
, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID
, USAGE_UOM USAGE_UOM
, CAPACITY_UNITS CAPACITY_UNITS
, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG
, SYSTEM_FK SYSTEM_FK
, DISABLE_DATE DISABLE_DATE
, RESOURCE_NAME RESOURCE_NAME
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_ATTR6 USER_ATTR6
, USER_ATTR7 USER_ATTR7
, USER_ATTR8 USER_ATTR8
, USER_ATTR9 USER_ATTR9
, USER_ATTR10 USER_ATTR10
, USER_ATTR11 USER_ATTR11
, USER_ATTR12 USER_ATTR12
, USER_ATTR13 USER_ATTR13
, USER_ATTR14 USER_ATTR14
, USER_ATTR15 USER_ATTR15
, USER_ATTR16 USER_ATTR16
, USER_ATTR17 USER_ATTR17
, USER_ATTR18 USER_ATTR18
, USER_ATTR19 USER_ATTR19
, USER_ATTR20 USER_ATTR20
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, REPROCESS_READY_YN REPROCESS_READY_YN
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION
, 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
, STD_UTILIZATION STD_UTILIZATION
, STD_EFFICIENCY STD_EFFICIENCY
, ERR_CODE ERR_CODE
, PRODUCTION_RESOURCE PRODUCTION_RESOURCE
, STATUS STATUS
, BUSINESS_FUNCTION BUSINESS_FUNCTION
FROM "MTH"."MTH_RESOURCES_ERR"