VIEW: MTH.MTH_TAG_MASTER#

Source

View Text - Preformatted

select TAG_CODE TAG_CODE, TAG_ALIAS TAG_ALIAS, TAG_TYPE TAG_TYPE, PLC_IDENTIFIER PLC_IDENTIFIER, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY, PLANT_FK_KEY PLANT_FK_KEY, DESCRIPTION DESCRIPTION, UOM UOM, IS_CUMULATIVE IS_CUMULATIVE, MAX_RESET_VALUE MAX_RESET_VALUE, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_SYSTEM_ID CREATION_SYSTEM_ID, LAST_UPDATE_SYSTEM_ID LAST_UPDATE_SYSTEM_ID, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, RESET_AFTER_JOB RESET_AFTER_JOB, DATA_TYPE DATA_TYPE, INITIAL_VALUE INITIAL_VALUE, ORDER_TYPE ORDER_TYPE, READING_TYPE READING_TYPE, STATUS STATUS, TAG_DATA_SOURCE_FK_KEY TAG_DATA_SOURCE_FK_KEY, FREQUENCY_IN_MINUTES FREQUENCY_IN_MINUTES from "MTH"."MTH_TAG_MASTER"

View Text - HTML Formatted

SELECT TAG_CODE TAG_CODE
, TAG_ALIAS TAG_ALIAS
, TAG_TYPE TAG_TYPE
, PLC_IDENTIFIER PLC_IDENTIFIER
, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
, PLANT_FK_KEY PLANT_FK_KEY
, DESCRIPTION DESCRIPTION
, UOM UOM
, IS_CUMULATIVE IS_CUMULATIVE
, MAX_RESET_VALUE MAX_RESET_VALUE
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_SYSTEM_ID CREATION_SYSTEM_ID
, LAST_UPDATE_SYSTEM_ID LAST_UPDATE_SYSTEM_ID
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, RESET_AFTER_JOB RESET_AFTER_JOB
, DATA_TYPE DATA_TYPE
, INITIAL_VALUE INITIAL_VALUE
, ORDER_TYPE ORDER_TYPE
, READING_TYPE READING_TYPE
, STATUS STATUS
, TAG_DATA_SOURCE_FK_KEY TAG_DATA_SOURCE_FK_KEY
, FREQUENCY_IN_MINUTES FREQUENCY_IN_MINUTES
FROM "MTH"."MTH_TAG_MASTER"