VIEW: CS.CS_SR_CONTACTS_EXT_B#

Source

View Text - Preformatted

select EXTENSION_ID EXTENSION_ID, INCIDENT_ID INCIDENT_ID, CONTEXT CONTEXT, ATTR_GROUP_ID ATTR_GROUP_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, C_EXT_ATTR1 C_EXT_ATTR1, C_EXT_ATTR2 C_EXT_ATTR2, C_EXT_ATTR3 C_EXT_ATTR3, C_EXT_ATTR4 C_EXT_ATTR4, C_EXT_ATTR5 C_EXT_ATTR5, C_EXT_ATTR6 C_EXT_ATTR6, C_EXT_ATTR7 C_EXT_ATTR7, C_EXT_ATTR8 C_EXT_ATTR8, C_EXT_ATTR9 C_EXT_ATTR9, C_EXT_ATTR10 C_EXT_ATTR10, C_EXT_ATTR11 C_EXT_ATTR11, C_EXT_ATTR12 C_EXT_ATTR12, C_EXT_ATTR13 C_EXT_ATTR13, C_EXT_ATTR14 C_EXT_ATTR14, C_EXT_ATTR15 C_EXT_ATTR15, C_EXT_ATTR16 C_EXT_ATTR16, C_EXT_ATTR17 C_EXT_ATTR17, C_EXT_ATTR18 C_EXT_ATTR18, C_EXT_ATTR19 C_EXT_ATTR19, C_EXT_ATTR20 C_EXT_ATTR20, C_EXT_ATTR21 C_EXT_ATTR21, C_EXT_ATTR22 C_EXT_ATTR22, C_EXT_ATTR23 C_EXT_ATTR23, C_EXT_ATTR24 C_EXT_ATTR24, C_EXT_ATTR25 C_EXT_ATTR25, C_EXT_ATTR26 C_EXT_ATTR26, C_EXT_ATTR27 C_EXT_ATTR27, C_EXT_ATTR28 C_EXT_ATTR28, C_EXT_ATTR29 C_EXT_ATTR29, C_EXT_ATTR30 C_EXT_ATTR30, C_EXT_ATTR31 C_EXT_ATTR31, C_EXT_ATTR32 C_EXT_ATTR32, C_EXT_ATTR33 C_EXT_ATTR33, C_EXT_ATTR34 C_EXT_ATTR34, C_EXT_ATTR35 C_EXT_ATTR35, C_EXT_ATTR36 C_EXT_ATTR36, C_EXT_ATTR37 C_EXT_ATTR37, C_EXT_ATTR38 C_EXT_ATTR38, C_EXT_ATTR39 C_EXT_ATTR39, C_EXT_ATTR40 C_EXT_ATTR40, C_EXT_ATTR41 C_EXT_ATTR41, C_EXT_ATTR42 C_EXT_ATTR42, C_EXT_ATTR43 C_EXT_ATTR43, C_EXT_ATTR44 C_EXT_ATTR44, C_EXT_ATTR45 C_EXT_ATTR45, C_EXT_ATTR46 C_EXT_ATTR46, C_EXT_ATTR47 C_EXT_ATTR47, C_EXT_ATTR48 C_EXT_ATTR48, C_EXT_ATTR49 C_EXT_ATTR49, C_EXT_ATTR50 C_EXT_ATTR50, N_EXT_ATTR1 N_EXT_ATTR1, N_EXT_ATTR2 N_EXT_ATTR2, N_EXT_ATTR3 N_EXT_ATTR3, N_EXT_ATTR4 N_EXT_ATTR4, N_EXT_ATTR5 N_EXT_ATTR5, N_EXT_ATTR6 N_EXT_ATTR6, N_EXT_ATTR7 N_EXT_ATTR7, N_EXT_ATTR8 N_EXT_ATTR8, N_EXT_ATTR9 N_EXT_ATTR9, N_EXT_ATTR10 N_EXT_ATTR10, N_EXT_ATTR11 N_EXT_ATTR11, N_EXT_ATTR12 N_EXT_ATTR12, N_EXT_ATTR13 N_EXT_ATTR13, N_EXT_ATTR14 N_EXT_ATTR14, N_EXT_ATTR15 N_EXT_ATTR15, N_EXT_ATTR16 N_EXT_ATTR16, N_EXT_ATTR17 N_EXT_ATTR17, N_EXT_ATTR18 N_EXT_ATTR18, N_EXT_ATTR19 N_EXT_ATTR19, N_EXT_ATTR20 N_EXT_ATTR20, N_EXT_ATTR21 N_EXT_ATTR21, N_EXT_ATTR22 N_EXT_ATTR22, N_EXT_ATTR23 N_EXT_ATTR23, N_EXT_ATTR24 N_EXT_ATTR24, N_EXT_ATTR25 N_EXT_ATTR25, D_EXT_ATTR1 D_EXT_ATTR1, D_EXT_ATTR2 D_EXT_ATTR2, D_EXT_ATTR3 D_EXT_ATTR3, D_EXT_ATTR4 D_EXT_ATTR4, D_EXT_ATTR5 D_EXT_ATTR5, D_EXT_ATTR6 D_EXT_ATTR6, D_EXT_ATTR7 D_EXT_ATTR7, D_EXT_ATTR8 D_EXT_ATTR8, D_EXT_ATTR9 D_EXT_ATTR9, D_EXT_ATTR10 D_EXT_ATTR10, D_EXT_ATTR11 D_EXT_ATTR11, D_EXT_ATTR12 D_EXT_ATTR12, D_EXT_ATTR13 D_EXT_ATTR13, D_EXT_ATTR14 D_EXT_ATTR14, D_EXT_ATTR15 D_EXT_ATTR15, D_EXT_ATTR16 D_EXT_ATTR16, D_EXT_ATTR17 D_EXT_ATTR17, D_EXT_ATTR18 D_EXT_ATTR18, D_EXT_ATTR19 D_EXT_ATTR19, D_EXT_ATTR20 D_EXT_ATTR20, D_EXT_ATTR21 D_EXT_ATTR21, D_EXT_ATTR22 D_EXT_ATTR22, D_EXT_ATTR23 D_EXT_ATTR23, D_EXT_ATTR24 D_EXT_ATTR24, D_EXT_ATTR25 D_EXT_ATTR25, UOM_EXT_ATTR1 UOM_EXT_ATTR1, UOM_EXT_ATTR2 UOM_EXT_ATTR2, UOM_EXT_ATTR3 UOM_EXT_ATTR3, UOM_EXT_ATTR4 UOM_EXT_ATTR4, UOM_EXT_ATTR5 UOM_EXT_ATTR5, UOM_EXT_ATTR6 UOM_EXT_ATTR6, UOM_EXT_ATTR7 UOM_EXT_ATTR7, UOM_EXT_ATTR8 UOM_EXT_ATTR8, UOM_EXT_ATTR9 UOM_EXT_ATTR9, UOM_EXT_ATTR10 UOM_EXT_ATTR10, UOM_EXT_ATTR11 UOM_EXT_ATTR11, UOM_EXT_ATTR12 UOM_EXT_ATTR12, UOM_EXT_ATTR13 UOM_EXT_ATTR13, UOM_EXT_ATTR14 UOM_EXT_ATTR14, UOM_EXT_ATTR15 UOM_EXT_ATTR15, UOM_EXT_ATTR16 UOM_EXT_ATTR16, UOM_EXT_ATTR17 UOM_EXT_ATTR17, UOM_EXT_ATTR18 UOM_EXT_ATTR18, UOM_EXT_ATTR19 UOM_EXT_ATTR19, UOM_EXT_ATTR20 UOM_EXT_ATTR20, UOM_EXT_ATTR21 UOM_EXT_ATTR21, UOM_EXT_ATTR22 UOM_EXT_ATTR22, UOM_EXT_ATTR23 UOM_EXT_ATTR23, UOM_EXT_ATTR24 UOM_EXT_ATTR24, UOM_EXT_ATTR25 UOM_EXT_ATTR25, PARTY_ID PARTY_ID, CONTACT_TYPE CONTACT_TYPE, PARTY_ROLE_CODE PARTY_ROLE_CODE from "CS"."CS_SR_CONTACTS_EXT_B"

View Text - HTML Formatted

SELECT EXTENSION_ID EXTENSION_ID
, INCIDENT_ID INCIDENT_ID
, CONTEXT CONTEXT
, ATTR_GROUP_ID ATTR_GROUP_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, C_EXT_ATTR1 C_EXT_ATTR1
, C_EXT_ATTR2 C_EXT_ATTR2
, C_EXT_ATTR3 C_EXT_ATTR3
, C_EXT_ATTR4 C_EXT_ATTR4
, C_EXT_ATTR5 C_EXT_ATTR5
, C_EXT_ATTR6 C_EXT_ATTR6
, C_EXT_ATTR7 C_EXT_ATTR7
, C_EXT_ATTR8 C_EXT_ATTR8
, C_EXT_ATTR9 C_EXT_ATTR9
, C_EXT_ATTR10 C_EXT_ATTR10
, C_EXT_ATTR11 C_EXT_ATTR11
, C_EXT_ATTR12 C_EXT_ATTR12
, C_EXT_ATTR13 C_EXT_ATTR13
, C_EXT_ATTR14 C_EXT_ATTR14
, C_EXT_ATTR15 C_EXT_ATTR15
, C_EXT_ATTR16 C_EXT_ATTR16
, C_EXT_ATTR17 C_EXT_ATTR17
, C_EXT_ATTR18 C_EXT_ATTR18
, C_EXT_ATTR19 C_EXT_ATTR19
, C_EXT_ATTR20 C_EXT_ATTR20
, C_EXT_ATTR21 C_EXT_ATTR21
, C_EXT_ATTR22 C_EXT_ATTR22
, C_EXT_ATTR23 C_EXT_ATTR23
, C_EXT_ATTR24 C_EXT_ATTR24
, C_EXT_ATTR25 C_EXT_ATTR25
, C_EXT_ATTR26 C_EXT_ATTR26
, C_EXT_ATTR27 C_EXT_ATTR27
, C_EXT_ATTR28 C_EXT_ATTR28
, C_EXT_ATTR29 C_EXT_ATTR29
, C_EXT_ATTR30 C_EXT_ATTR30
, C_EXT_ATTR31 C_EXT_ATTR31
, C_EXT_ATTR32 C_EXT_ATTR32
, C_EXT_ATTR33 C_EXT_ATTR33
, C_EXT_ATTR34 C_EXT_ATTR34
, C_EXT_ATTR35 C_EXT_ATTR35
, C_EXT_ATTR36 C_EXT_ATTR36
, C_EXT_ATTR37 C_EXT_ATTR37
, C_EXT_ATTR38 C_EXT_ATTR38
, C_EXT_ATTR39 C_EXT_ATTR39
, C_EXT_ATTR40 C_EXT_ATTR40
, C_EXT_ATTR41 C_EXT_ATTR41
, C_EXT_ATTR42 C_EXT_ATTR42
, C_EXT_ATTR43 C_EXT_ATTR43
, C_EXT_ATTR44 C_EXT_ATTR44
, C_EXT_ATTR45 C_EXT_ATTR45
, C_EXT_ATTR46 C_EXT_ATTR46
, C_EXT_ATTR47 C_EXT_ATTR47
, C_EXT_ATTR48 C_EXT_ATTR48
, C_EXT_ATTR49 C_EXT_ATTR49
, C_EXT_ATTR50 C_EXT_ATTR50
, N_EXT_ATTR1 N_EXT_ATTR1
, N_EXT_ATTR2 N_EXT_ATTR2
, N_EXT_ATTR3 N_EXT_ATTR3
, N_EXT_ATTR4 N_EXT_ATTR4
, N_EXT_ATTR5 N_EXT_ATTR5
, N_EXT_ATTR6 N_EXT_ATTR6
, N_EXT_ATTR7 N_EXT_ATTR7
, N_EXT_ATTR8 N_EXT_ATTR8
, N_EXT_ATTR9 N_EXT_ATTR9
, N_EXT_ATTR10 N_EXT_ATTR10
, N_EXT_ATTR11 N_EXT_ATTR11
, N_EXT_ATTR12 N_EXT_ATTR12
, N_EXT_ATTR13 N_EXT_ATTR13
, N_EXT_ATTR14 N_EXT_ATTR14
, N_EXT_ATTR15 N_EXT_ATTR15
, N_EXT_ATTR16 N_EXT_ATTR16
, N_EXT_ATTR17 N_EXT_ATTR17
, N_EXT_ATTR18 N_EXT_ATTR18
, N_EXT_ATTR19 N_EXT_ATTR19
, N_EXT_ATTR20 N_EXT_ATTR20
, N_EXT_ATTR21 N_EXT_ATTR21
, N_EXT_ATTR22 N_EXT_ATTR22
, N_EXT_ATTR23 N_EXT_ATTR23
, N_EXT_ATTR24 N_EXT_ATTR24
, N_EXT_ATTR25 N_EXT_ATTR25
, D_EXT_ATTR1 D_EXT_ATTR1
, D_EXT_ATTR2 D_EXT_ATTR2
, D_EXT_ATTR3 D_EXT_ATTR3
, D_EXT_ATTR4 D_EXT_ATTR4
, D_EXT_ATTR5 D_EXT_ATTR5
, D_EXT_ATTR6 D_EXT_ATTR6
, D_EXT_ATTR7 D_EXT_ATTR7
, D_EXT_ATTR8 D_EXT_ATTR8
, D_EXT_ATTR9 D_EXT_ATTR9
, D_EXT_ATTR10 D_EXT_ATTR10
, D_EXT_ATTR11 D_EXT_ATTR11
, D_EXT_ATTR12 D_EXT_ATTR12
, D_EXT_ATTR13 D_EXT_ATTR13
, D_EXT_ATTR14 D_EXT_ATTR14
, D_EXT_ATTR15 D_EXT_ATTR15
, D_EXT_ATTR16 D_EXT_ATTR16
, D_EXT_ATTR17 D_EXT_ATTR17
, D_EXT_ATTR18 D_EXT_ATTR18
, D_EXT_ATTR19 D_EXT_ATTR19
, D_EXT_ATTR20 D_EXT_ATTR20
, D_EXT_ATTR21 D_EXT_ATTR21
, D_EXT_ATTR22 D_EXT_ATTR22
, D_EXT_ATTR23 D_EXT_ATTR23
, D_EXT_ATTR24 D_EXT_ATTR24
, D_EXT_ATTR25 D_EXT_ATTR25
, UOM_EXT_ATTR1 UOM_EXT_ATTR1
, UOM_EXT_ATTR2 UOM_EXT_ATTR2
, UOM_EXT_ATTR3 UOM_EXT_ATTR3
, UOM_EXT_ATTR4 UOM_EXT_ATTR4
, UOM_EXT_ATTR5 UOM_EXT_ATTR5
, UOM_EXT_ATTR6 UOM_EXT_ATTR6
, UOM_EXT_ATTR7 UOM_EXT_ATTR7
, UOM_EXT_ATTR8 UOM_EXT_ATTR8
, UOM_EXT_ATTR9 UOM_EXT_ATTR9
, UOM_EXT_ATTR10 UOM_EXT_ATTR10
, UOM_EXT_ATTR11 UOM_EXT_ATTR11
, UOM_EXT_ATTR12 UOM_EXT_ATTR12
, UOM_EXT_ATTR13 UOM_EXT_ATTR13
, UOM_EXT_ATTR14 UOM_EXT_ATTR14
, UOM_EXT_ATTR15 UOM_EXT_ATTR15
, UOM_EXT_ATTR16 UOM_EXT_ATTR16
, UOM_EXT_ATTR17 UOM_EXT_ATTR17
, UOM_EXT_ATTR18 UOM_EXT_ATTR18
, UOM_EXT_ATTR19 UOM_EXT_ATTR19
, UOM_EXT_ATTR20 UOM_EXT_ATTR20
, UOM_EXT_ATTR21 UOM_EXT_ATTR21
, UOM_EXT_ATTR22 UOM_EXT_ATTR22
, UOM_EXT_ATTR23 UOM_EXT_ATTR23
, UOM_EXT_ATTR24 UOM_EXT_ATTR24
, UOM_EXT_ATTR25 UOM_EXT_ATTR25
, PARTY_ID PARTY_ID
, CONTACT_TYPE CONTACT_TYPE
, PARTY_ROLE_CODE PARTY_ROLE_CODE
FROM "CS"."CS_SR_CONTACTS_EXT_B"