VIEW: MTH.MTH_PLANTS_ERR#

Source

View Text - Preformatted

select PLANT_PK PLANT_PK, CURRENCY_CODE CURRENCY_CODE, SOURCE SOURCE, PLANT_NAME PLANT_NAME, FROM_DATE FROM_DATE, GRAVEYARD_SHIFT_FLAG GRAVEYARD_SHIFT_FLAG, PRODUCTION_SITE PRODUCTION_SITE, EFFECTIVE_DATE EFFECTIVE_DATE, ADDRESS ADDRESS, CITY CITY, STATE STATE, ZIP_CODE ZIP_CODE, COUNTRY COUNTRY, IDEAL_TEMPERATURE IDEAL_TEMPERATURE, E_GRID_ZONE E_GRID_ZONE, POWER_RATING_UOM POWER_RATING_UOM, AREA AREA, HEAD_COUNT HEAD_COUNT, TO_DATE TO_DATE, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, 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_PLANTS_ERR"

View Text - HTML Formatted

SELECT PLANT_PK PLANT_PK
, CURRENCY_CODE CURRENCY_CODE
, SOURCE SOURCE
, PLANT_NAME PLANT_NAME
, FROM_DATE FROM_DATE
, GRAVEYARD_SHIFT_FLAG GRAVEYARD_SHIFT_FLAG
, PRODUCTION_SITE PRODUCTION_SITE
, EFFECTIVE_DATE EFFECTIVE_DATE
, ADDRESS ADDRESS
, CITY CITY
, STATE STATE
, ZIP_CODE ZIP_CODE
, COUNTRY COUNTRY
, IDEAL_TEMPERATURE IDEAL_TEMPERATURE
, E_GRID_ZONE E_GRID_ZONE
, POWER_RATING_UOM POWER_RATING_UOM
, AREA AREA
, HEAD_COUNT HEAD_COUNT
, TO_DATE TO_DATE
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, 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_PLANTS_ERR"