VIEW: EGO.EGO_ITEMS_ATTRS_CHANGES_TL#

Source

View Text - Preformatted

select EXTENSION_ID EXTENSION_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, ATTR_GROUP_ID ATTR_GROUP_ID, CHANGE_ID CHANGE_ID, CHANGE_LINE_ID CHANGE_LINE_ID, ACD_TYPE ACD_TYPE, SOURCE_LANG SOURCE_LANG, LANGUAGE LANGUAGE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IMPLEMENTATION_DATE IMPLEMENTATION_DATE, REVISION_ID REVISION_ID, 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, DATA_LEVEL_ID DATA_LEVEL_ID, PK1_VALUE PK1_VALUE, PK2_VALUE PK2_VALUE, PK3_VALUE PK3_VALUE, PK4_VALUE PK4_VALUE, PK5_VALUE PK5_VALUE from "EGO"."EGO_ITEMS_ATTRS_CHANGES_TL"

View Text - HTML Formatted

SELECT EXTENSION_ID EXTENSION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, ATTR_GROUP_ID ATTR_GROUP_ID
, CHANGE_ID CHANGE_ID
, CHANGE_LINE_ID CHANGE_LINE_ID
, ACD_TYPE ACD_TYPE
, SOURCE_LANG SOURCE_LANG
, LANGUAGE LANGUAGE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, REVISION_ID REVISION_ID
, 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
, DATA_LEVEL_ID DATA_LEVEL_ID
, PK1_VALUE PK1_VALUE
, PK2_VALUE PK2_VALUE
, PK3_VALUE PK3_VALUE
, PK4_VALUE PK4_VALUE
, PK5_VALUE PK5_VALUE
FROM "EGO"."EGO_ITEMS_ATTRS_CHANGES_TL"