eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: EGO.EGO_MTL_SY_ITEMS_EXT_B#

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, DATA_LEVEL_ID DATA_LEVEL_ID, 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, REVISION_ID REVISION_ID, PK1_VALUE PK1_VALUE, PK2_VALUE PK2_VALUE, PK3_VALUE PK3_VALUE, PK4_VALUE PK4_VALUE, PK5_VALUE PK5_VALUE, 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, N_EXT_ATTR1 N_EXT_ATTR1, UOM_EXT_ATTR1 UOM_EXT_ATTR1, N_EXT_ATTR2 N_EXT_ATTR2, UOM_EXT_ATTR2 UOM_EXT_ATTR2, N_EXT_ATTR3 N_EXT_ATTR3, UOM_EXT_ATTR3 UOM_EXT_ATTR3, N_EXT_ATTR4 N_EXT_ATTR4, UOM_EXT_ATTR4 UOM_EXT_ATTR4, N_EXT_ATTR5 N_EXT_ATTR5, UOM_EXT_ATTR5 UOM_EXT_ATTR5, N_EXT_ATTR6 N_EXT_ATTR6, UOM_EXT_ATTR6 UOM_EXT_ATTR6, N_EXT_ATTR7 N_EXT_ATTR7, UOM_EXT_ATTR7 UOM_EXT_ATTR7, N_EXT_ATTR8 N_EXT_ATTR8, UOM_EXT_ATTR8 UOM_EXT_ATTR8, N_EXT_ATTR9 N_EXT_ATTR9, UOM_EXT_ATTR9 UOM_EXT_ATTR9, N_EXT_ATTR10 N_EXT_ATTR10, UOM_EXT_ATTR10 UOM_EXT_ATTR10, 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, 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, N_EXT_ATTR11 N_EXT_ATTR11, UOM_EXT_ATTR11 UOM_EXT_ATTR11, N_EXT_ATTR12 N_EXT_ATTR12, UOM_EXT_ATTR12 UOM_EXT_ATTR12, N_EXT_ATTR13 N_EXT_ATTR13, UOM_EXT_ATTR13 UOM_EXT_ATTR13, N_EXT_ATTR14 N_EXT_ATTR14, UOM_EXT_ATTR14 UOM_EXT_ATTR14, N_EXT_ATTR15 N_EXT_ATTR15, UOM_EXT_ATTR15 UOM_EXT_ATTR15, N_EXT_ATTR16 N_EXT_ATTR16, UOM_EXT_ATTR16 UOM_EXT_ATTR16, N_EXT_ATTR17 N_EXT_ATTR17, UOM_EXT_ATTR17 UOM_EXT_ATTR17, N_EXT_ATTR18 N_EXT_ATTR18, UOM_EXT_ATTR18 UOM_EXT_ATTR18, N_EXT_ATTR19 N_EXT_ATTR19, UOM_EXT_ATTR19 UOM_EXT_ATTR19, N_EXT_ATTR20 N_EXT_ATTR20, UOM_EXT_ATTR20 UOM_EXT_ATTR20, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, UNIQUE_VALUE UNIQUE_VALUE from "EGO"."EGO_MTL_SY_ITEMS_EXT_B"

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
, DATA_LEVEL_ID DATA_LEVEL_ID
, 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
, REVISION_ID REVISION_ID
, PK1_VALUE PK1_VALUE
, PK2_VALUE PK2_VALUE
, PK3_VALUE PK3_VALUE
, PK4_VALUE PK4_VALUE
, PK5_VALUE PK5_VALUE
, 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
, N_EXT_ATTR1 N_EXT_ATTR1
, UOM_EXT_ATTR1 UOM_EXT_ATTR1
, N_EXT_ATTR2 N_EXT_ATTR2
, UOM_EXT_ATTR2 UOM_EXT_ATTR2
, N_EXT_ATTR3 N_EXT_ATTR3
, UOM_EXT_ATTR3 UOM_EXT_ATTR3
, N_EXT_ATTR4 N_EXT_ATTR4
, UOM_EXT_ATTR4 UOM_EXT_ATTR4
, N_EXT_ATTR5 N_EXT_ATTR5
, UOM_EXT_ATTR5 UOM_EXT_ATTR5
, N_EXT_ATTR6 N_EXT_ATTR6
, UOM_EXT_ATTR6 UOM_EXT_ATTR6
, N_EXT_ATTR7 N_EXT_ATTR7
, UOM_EXT_ATTR7 UOM_EXT_ATTR7
, N_EXT_ATTR8 N_EXT_ATTR8
, UOM_EXT_ATTR8 UOM_EXT_ATTR8
, N_EXT_ATTR9 N_EXT_ATTR9
, UOM_EXT_ATTR9 UOM_EXT_ATTR9
, N_EXT_ATTR10 N_EXT_ATTR10
, UOM_EXT_ATTR10 UOM_EXT_ATTR10
, 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
, 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
, N_EXT_ATTR11 N_EXT_ATTR11
, UOM_EXT_ATTR11 UOM_EXT_ATTR11
, N_EXT_ATTR12 N_EXT_ATTR12
, UOM_EXT_ATTR12 UOM_EXT_ATTR12
, N_EXT_ATTR13 N_EXT_ATTR13
, UOM_EXT_ATTR13 UOM_EXT_ATTR13
, N_EXT_ATTR14 N_EXT_ATTR14
, UOM_EXT_ATTR14 UOM_EXT_ATTR14
, N_EXT_ATTR15 N_EXT_ATTR15
, UOM_EXT_ATTR15 UOM_EXT_ATTR15
, N_EXT_ATTR16 N_EXT_ATTR16
, UOM_EXT_ATTR16 UOM_EXT_ATTR16
, N_EXT_ATTR17 N_EXT_ATTR17
, UOM_EXT_ATTR17 UOM_EXT_ATTR17
, N_EXT_ATTR18 N_EXT_ATTR18
, UOM_EXT_ATTR18 UOM_EXT_ATTR18
, N_EXT_ATTR19 N_EXT_ATTR19
, UOM_EXT_ATTR19 UOM_EXT_ATTR19
, N_EXT_ATTR20 N_EXT_ATTR20
, UOM_EXT_ATTR20 UOM_EXT_ATTR20
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, UNIQUE_VALUE UNIQUE_VALUE
FROM "EGO"."EGO_MTL_SY_ITEMS_EXT_B"