VIEW: OKC.OKC_REP_CONTRACTS_ALL_EXT_TL#

Source

View Text - Preformatted

select EXTENSION_ID EXTENSION_ID, ATTR_GROUP_ID ATTR_GROUP_ID, CONTRACT_TYPE CONTRACT_TYPE, CONTRACT_ID CONTRACT_ID, CONTRACT_VERSION_NUM CONTRACT_VERSION_NUM, DATA_LEVEL_ID DATA_LEVEL_ID, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, SOURCE_LANG SOURCE_LANG, LANGUAGE LANGUAGE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TL_EXT_ATTR1 TL_EXT_ATTR1, TL_EXT_ATTR2 TL_EXT_ATTR2, TL_EXT_ATTR3 TL_EXT_ATTR3, TL_EXT_ATTR4 TL_EXT_ATTR4, TL_EXT_ATTR5 TL_EXT_ATTR5, TL_EXT_ATTR6 TL_EXT_ATTR6, TL_EXT_ATTR7 TL_EXT_ATTR7, TL_EXT_ATTR8 TL_EXT_ATTR8, TL_EXT_ATTR9 TL_EXT_ATTR9, TL_EXT_ATTR10 TL_EXT_ATTR10, TL_EXT_ATTR11 TL_EXT_ATTR11, TL_EXT_ATTR12 TL_EXT_ATTR12, TL_EXT_ATTR13 TL_EXT_ATTR13, TL_EXT_ATTR14 TL_EXT_ATTR14, TL_EXT_ATTR15 TL_EXT_ATTR15, TL_EXT_ATTR16 TL_EXT_ATTR16, TL_EXT_ATTR17 TL_EXT_ATTR17, TL_EXT_ATTR18 TL_EXT_ATTR18, TL_EXT_ATTR19 TL_EXT_ATTR19, TL_EXT_ATTR20 TL_EXT_ATTR20, TL_EXT_ATTR21 TL_EXT_ATTR21, TL_EXT_ATTR22 TL_EXT_ATTR22, TL_EXT_ATTR23 TL_EXT_ATTR23, TL_EXT_ATTR24 TL_EXT_ATTR24, TL_EXT_ATTR25 TL_EXT_ATTR25, TL_EXT_ATTR26 TL_EXT_ATTR26, TL_EXT_ATTR27 TL_EXT_ATTR27, TL_EXT_ATTR28 TL_EXT_ATTR28, TL_EXT_ATTR29 TL_EXT_ATTR29, TL_EXT_ATTR30 TL_EXT_ATTR30, TL_EXT_ATTR31 TL_EXT_ATTR31, TL_EXT_ATTR32 TL_EXT_ATTR32, TL_EXT_ATTR33 TL_EXT_ATTR33, TL_EXT_ATTR34 TL_EXT_ATTR34, TL_EXT_ATTR35 TL_EXT_ATTR35, TL_EXT_ATTR36 TL_EXT_ATTR36, TL_EXT_ATTR37 TL_EXT_ATTR37, TL_EXT_ATTR38 TL_EXT_ATTR38, TL_EXT_ATTR39 TL_EXT_ATTR39, TL_EXT_ATTR40 TL_EXT_ATTR40 from "OKC"."OKC_REP_CONTRACTS_ALL_EXT_TL"

View Text - HTML Formatted

SELECT EXTENSION_ID EXTENSION_ID
, ATTR_GROUP_ID ATTR_GROUP_ID
, CONTRACT_TYPE CONTRACT_TYPE
, CONTRACT_ID CONTRACT_ID
, CONTRACT_VERSION_NUM CONTRACT_VERSION_NUM
, DATA_LEVEL_ID DATA_LEVEL_ID
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, SOURCE_LANG SOURCE_LANG
, LANGUAGE LANGUAGE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TL_EXT_ATTR1 TL_EXT_ATTR1
, TL_EXT_ATTR2 TL_EXT_ATTR2
, TL_EXT_ATTR3 TL_EXT_ATTR3
, TL_EXT_ATTR4 TL_EXT_ATTR4
, TL_EXT_ATTR5 TL_EXT_ATTR5
, TL_EXT_ATTR6 TL_EXT_ATTR6
, TL_EXT_ATTR7 TL_EXT_ATTR7
, TL_EXT_ATTR8 TL_EXT_ATTR8
, TL_EXT_ATTR9 TL_EXT_ATTR9
, TL_EXT_ATTR10 TL_EXT_ATTR10
, TL_EXT_ATTR11 TL_EXT_ATTR11
, TL_EXT_ATTR12 TL_EXT_ATTR12
, TL_EXT_ATTR13 TL_EXT_ATTR13
, TL_EXT_ATTR14 TL_EXT_ATTR14
, TL_EXT_ATTR15 TL_EXT_ATTR15
, TL_EXT_ATTR16 TL_EXT_ATTR16
, TL_EXT_ATTR17 TL_EXT_ATTR17
, TL_EXT_ATTR18 TL_EXT_ATTR18
, TL_EXT_ATTR19 TL_EXT_ATTR19
, TL_EXT_ATTR20 TL_EXT_ATTR20
, TL_EXT_ATTR21 TL_EXT_ATTR21
, TL_EXT_ATTR22 TL_EXT_ATTR22
, TL_EXT_ATTR23 TL_EXT_ATTR23
, TL_EXT_ATTR24 TL_EXT_ATTR24
, TL_EXT_ATTR25 TL_EXT_ATTR25
, TL_EXT_ATTR26 TL_EXT_ATTR26
, TL_EXT_ATTR27 TL_EXT_ATTR27
, TL_EXT_ATTR28 TL_EXT_ATTR28
, TL_EXT_ATTR29 TL_EXT_ATTR29
, TL_EXT_ATTR30 TL_EXT_ATTR30
, TL_EXT_ATTR31 TL_EXT_ATTR31
, TL_EXT_ATTR32 TL_EXT_ATTR32
, TL_EXT_ATTR33 TL_EXT_ATTR33
, TL_EXT_ATTR34 TL_EXT_ATTR34
, TL_EXT_ATTR35 TL_EXT_ATTR35
, TL_EXT_ATTR36 TL_EXT_ATTR36
, TL_EXT_ATTR37 TL_EXT_ATTR37
, TL_EXT_ATTR38 TL_EXT_ATTR38
, TL_EXT_ATTR39 TL_EXT_ATTR39
, TL_EXT_ATTR40 TL_EXT_ATTR40
FROM "OKC"."OKC_REP_CONTRACTS_ALL_EXT_TL"