VIEW: APPS.EGO_ITEM_TP_ATTRS_EXT_VL

Source

View Text - Preformatted

SELECT B.EXTENSION_ID EXTENSION_ID, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, B.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, B.PARTY_SITE_ID PARTY_SITE_ID, B.ATTR_GROUP_ID ATTR_GROUP_ID, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.SOURCE_LANG SOURCE_LANG, TL.LANGUAGE LANGUAGE, B.C_EXT_ATTR1 C_EXT_ATTR1, B.C_EXT_ATTR2 C_EXT_ATTR2, B.C_EXT_ATTR3 C_EXT_ATTR3, B.C_EXT_ATTR4 C_EXT_ATTR4, B.C_EXT_ATTR5 C_EXT_ATTR5, B.C_EXT_ATTR6 C_EXT_ATTR6, B.C_EXT_ATTR7 C_EXT_ATTR7, B.C_EXT_ATTR8 C_EXT_ATTR8, B.C_EXT_ATTR9 C_EXT_ATTR9, B.C_EXT_ATTR10 C_EXT_ATTR10, B.C_EXT_ATTR11 C_EXT_ATTR11, B.C_EXT_ATTR12 C_EXT_ATTR12, B.C_EXT_ATTR13 C_EXT_ATTR13, B.C_EXT_ATTR14 C_EXT_ATTR14, B.C_EXT_ATTR15 C_EXT_ATTR15, B.C_EXT_ATTR16 C_EXT_ATTR16, B.C_EXT_ATTR17 C_EXT_ATTR17, B.C_EXT_ATTR18 C_EXT_ATTR18, B.C_EXT_ATTR19 C_EXT_ATTR19, B.C_EXT_ATTR20 C_EXT_ATTR20, B.C_EXT_ATTR21 C_EXT_ATTR21, B.C_EXT_ATTR22 C_EXT_ATTR22, B.C_EXT_ATTR23 C_EXT_ATTR23, B.C_EXT_ATTR24 C_EXT_ATTR24, B.C_EXT_ATTR25 C_EXT_ATTR25, B.C_EXT_ATTR26 C_EXT_ATTR26, B.C_EXT_ATTR27 C_EXT_ATTR27, B.C_EXT_ATTR28 C_EXT_ATTR28, B.C_EXT_ATTR29 C_EXT_ATTR29, B.C_EXT_ATTR30 C_EXT_ATTR30, B.C_EXT_ATTR31 C_EXT_ATTR31, B.C_EXT_ATTR32 C_EXT_ATTR32, B.C_EXT_ATTR33 C_EXT_ATTR33, B.C_EXT_ATTR34 C_EXT_ATTR34, B.C_EXT_ATTR35 C_EXT_ATTR35, B.C_EXT_ATTR36 C_EXT_ATTR36, B.C_EXT_ATTR37 C_EXT_ATTR37, B.C_EXT_ATTR38 C_EXT_ATTR38, B.C_EXT_ATTR39 C_EXT_ATTR39, B.C_EXT_ATTR40 C_EXT_ATTR40, B.N_EXT_ATTR1 N_EXT_ATTR1, B.UOM_EXT_ATTR1 UOM_EXT_ATTR1, B.N_EXT_ATTR2 N_EXT_ATTR2, B.UOM_EXT_ATTR2 UOM_EXT_ATTR2, B.N_EXT_ATTR3 N_EXT_ATTR3, B.UOM_EXT_ATTR3 UOM_EXT_ATTR3, B.N_EXT_ATTR4 N_EXT_ATTR4, B.UOM_EXT_ATTR4 UOM_EXT_ATTR4, B.N_EXT_ATTR5 N_EXT_ATTR5, B.UOM_EXT_ATTR5 UOM_EXT_ATTR5, B.N_EXT_ATTR6 N_EXT_ATTR6, B.UOM_EXT_ATTR6 UOM_EXT_ATTR6, B.N_EXT_ATTR7 N_EXT_ATTR7, B.UOM_EXT_ATTR7 UOM_EXT_ATTR7, B.N_EXT_ATTR8 N_EXT_ATTR8, B.UOM_EXT_ATTR8 UOM_EXT_ATTR8, B.N_EXT_ATTR9 N_EXT_ATTR9, B.UOM_EXT_ATTR9 UOM_EXT_ATTR9, B.N_EXT_ATTR10 N_EXT_ATTR10, B.UOM_EXT_ATTR10 UOM_EXT_ATTR10, B.N_EXT_ATTR11 N_EXT_ATTR11, B.UOM_EXT_ATTR11 UOM_EXT_ATTR11, B.N_EXT_ATTR12 N_EXT_ATTR12, B.UOM_EXT_ATTR12 UOM_EXT_ATTR12, B.N_EXT_ATTR13 N_EXT_ATTR13, B.UOM_EXT_ATTR13 UOM_EXT_ATTR13, B.N_EXT_ATTR14 N_EXT_ATTR14, B.UOM_EXT_ATTR14 UOM_EXT_ATTR14, B.N_EXT_ATTR15 N_EXT_ATTR15, B.UOM_EXT_ATTR15 UOM_EXT_ATTR15, B.N_EXT_ATTR16 N_EXT_ATTR16, B.UOM_EXT_ATTR16 UOM_EXT_ATTR16, B.N_EXT_ATTR17 N_EXT_ATTR17, B.UOM_EXT_ATTR17 UOM_EXT_ATTR17, B.N_EXT_ATTR18 N_EXT_ATTR18, B.UOM_EXT_ATTR18 UOM_EXT_ATTR18, B.N_EXT_ATTR19 N_EXT_ATTR19, B.UOM_EXT_ATTR19 UOM_EXT_ATTR19, B.N_EXT_ATTR20 N_EXT_ATTR20, B.UOM_EXT_ATTR20 UOM_EXT_ATTR20, B.D_EXT_ATTR1 D_EXT_ATTR1, B.D_EXT_ATTR2 D_EXT_ATTR2, B.D_EXT_ATTR3 D_EXT_ATTR3, B.D_EXT_ATTR4 D_EXT_ATTR4, B.D_EXT_ATTR5 D_EXT_ATTR5, B.D_EXT_ATTR6 D_EXT_ATTR6, B.D_EXT_ATTR7 D_EXT_ATTR7, B.D_EXT_ATTR8 D_EXT_ATTR8, B.D_EXT_ATTR9 D_EXT_ATTR9, B.D_EXT_ATTR10 D_EXT_ATTR10, TL.TL_EXT_ATTR1 TL_EXT_ATTR1, TL.TL_EXT_ATTR2 TL_EXT_ATTR2, TL.TL_EXT_ATTR3 TL_EXT_ATTR3, TL.TL_EXT_ATTR4 TL_EXT_ATTR4, TL.TL_EXT_ATTR5 TL_EXT_ATTR5, TL.TL_EXT_ATTR6 TL_EXT_ATTR6, TL.TL_EXT_ATTR7 TL_EXT_ATTR7, TL.TL_EXT_ATTR8 TL_EXT_ATTR8, TL.TL_EXT_ATTR9 TL_EXT_ATTR9, TL.TL_EXT_ATTR10 TL_EXT_ATTR10, TL.TL_EXT_ATTR11 TL_EXT_ATTR11, TL.TL_EXT_ATTR12 TL_EXT_ATTR12, TL.TL_EXT_ATTR13 TL_EXT_ATTR13, TL.TL_EXT_ATTR14 TL_EXT_ATTR14, TL.TL_EXT_ATTR15 TL_EXT_ATTR15, TL.TL_EXT_ATTR16 TL_EXT_ATTR16, TL.TL_EXT_ATTR17 TL_EXT_ATTR17, TL.TL_EXT_ATTR18 TL_EXT_ATTR18, TL.TL_EXT_ATTR19 TL_EXT_ATTR19, TL.TL_EXT_ATTR20 TL_EXT_ATTR20, TL.TL_EXT_ATTR21 TL_EXT_ATTR21, TL.TL_EXT_ATTR22 TL_EXT_ATTR22, TL.TL_EXT_ATTR23 TL_EXT_ATTR23, TL.TL_EXT_ATTR24 TL_EXT_ATTR24, TL.TL_EXT_ATTR25 TL_EXT_ATTR25, TL.TL_EXT_ATTR26 TL_EXT_ATTR26, TL.TL_EXT_ATTR27 TL_EXT_ATTR27, TL.TL_EXT_ATTR28 TL_EXT_ATTR28, TL.TL_EXT_ATTR29 TL_EXT_ATTR29, TL.TL_EXT_ATTR30 TL_EXT_ATTR30, TL.TL_EXT_ATTR31 TL_EXT_ATTR31, TL.TL_EXT_ATTR32 TL_EXT_ATTR32, TL.TL_EXT_ATTR33 TL_EXT_ATTR33, TL.TL_EXT_ATTR34 TL_EXT_ATTR34, TL.TL_EXT_ATTR35 TL_EXT_ATTR35, TL.TL_EXT_ATTR36 TL_EXT_ATTR36, TL.TL_EXT_ATTR37 TL_EXT_ATTR37, TL.TL_EXT_ATTR38 TL_EXT_ATTR38, TL.TL_EXT_ATTR39 TL_EXT_ATTR39, TL.TL_EXT_ATTR40 TL_EXT_ATTR40 FROM EGO_ITEM_TP_ATTRS_EXT_B B , EGO_ITEM_TP_ATTRS_EXT_TL TL WHERE B.EXTENSION_ID = TL.EXTENSION_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.EXTENSION_ID EXTENSION_ID
, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, B.PARTY_SITE_ID PARTY_SITE_ID
, B.ATTR_GROUP_ID ATTR_GROUP_ID
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TL.SOURCE_LANG SOURCE_LANG
, TL.LANGUAGE LANGUAGE
, B.C_EXT_ATTR1 C_EXT_ATTR1
, B.C_EXT_ATTR2 C_EXT_ATTR2
, B.C_EXT_ATTR3 C_EXT_ATTR3
, B.C_EXT_ATTR4 C_EXT_ATTR4
, B.C_EXT_ATTR5 C_EXT_ATTR5
, B.C_EXT_ATTR6 C_EXT_ATTR6
, B.C_EXT_ATTR7 C_EXT_ATTR7
, B.C_EXT_ATTR8 C_EXT_ATTR8
, B.C_EXT_ATTR9 C_EXT_ATTR9
, B.C_EXT_ATTR10 C_EXT_ATTR10
, B.C_EXT_ATTR11 C_EXT_ATTR11
, B.C_EXT_ATTR12 C_EXT_ATTR12
, B.C_EXT_ATTR13 C_EXT_ATTR13
, B.C_EXT_ATTR14 C_EXT_ATTR14
, B.C_EXT_ATTR15 C_EXT_ATTR15
, B.C_EXT_ATTR16 C_EXT_ATTR16
, B.C_EXT_ATTR17 C_EXT_ATTR17
, B.C_EXT_ATTR18 C_EXT_ATTR18
, B.C_EXT_ATTR19 C_EXT_ATTR19
, B.C_EXT_ATTR20 C_EXT_ATTR20
, B.C_EXT_ATTR21 C_EXT_ATTR21
, B.C_EXT_ATTR22 C_EXT_ATTR22
, B.C_EXT_ATTR23 C_EXT_ATTR23
, B.C_EXT_ATTR24 C_EXT_ATTR24
, B.C_EXT_ATTR25 C_EXT_ATTR25
, B.C_EXT_ATTR26 C_EXT_ATTR26
, B.C_EXT_ATTR27 C_EXT_ATTR27
, B.C_EXT_ATTR28 C_EXT_ATTR28
, B.C_EXT_ATTR29 C_EXT_ATTR29
, B.C_EXT_ATTR30 C_EXT_ATTR30
, B.C_EXT_ATTR31 C_EXT_ATTR31
, B.C_EXT_ATTR32 C_EXT_ATTR32
, B.C_EXT_ATTR33 C_EXT_ATTR33
, B.C_EXT_ATTR34 C_EXT_ATTR34
, B.C_EXT_ATTR35 C_EXT_ATTR35
, B.C_EXT_ATTR36 C_EXT_ATTR36
, B.C_EXT_ATTR37 C_EXT_ATTR37
, B.C_EXT_ATTR38 C_EXT_ATTR38
, B.C_EXT_ATTR39 C_EXT_ATTR39
, B.C_EXT_ATTR40 C_EXT_ATTR40
, B.N_EXT_ATTR1 N_EXT_ATTR1
, B.UOM_EXT_ATTR1 UOM_EXT_ATTR1
, B.N_EXT_ATTR2 N_EXT_ATTR2
, B.UOM_EXT_ATTR2 UOM_EXT_ATTR2
, B.N_EXT_ATTR3 N_EXT_ATTR3
, B.UOM_EXT_ATTR3 UOM_EXT_ATTR3
, B.N_EXT_ATTR4 N_EXT_ATTR4
, B.UOM_EXT_ATTR4 UOM_EXT_ATTR4
, B.N_EXT_ATTR5 N_EXT_ATTR5
, B.UOM_EXT_ATTR5 UOM_EXT_ATTR5
, B.N_EXT_ATTR6 N_EXT_ATTR6
, B.UOM_EXT_ATTR6 UOM_EXT_ATTR6
, B.N_EXT_ATTR7 N_EXT_ATTR7
, B.UOM_EXT_ATTR7 UOM_EXT_ATTR7
, B.N_EXT_ATTR8 N_EXT_ATTR8
, B.UOM_EXT_ATTR8 UOM_EXT_ATTR8
, B.N_EXT_ATTR9 N_EXT_ATTR9
, B.UOM_EXT_ATTR9 UOM_EXT_ATTR9
, B.N_EXT_ATTR10 N_EXT_ATTR10
, B.UOM_EXT_ATTR10 UOM_EXT_ATTR10
, B.N_EXT_ATTR11 N_EXT_ATTR11
, B.UOM_EXT_ATTR11 UOM_EXT_ATTR11
, B.N_EXT_ATTR12 N_EXT_ATTR12
, B.UOM_EXT_ATTR12 UOM_EXT_ATTR12
, B.N_EXT_ATTR13 N_EXT_ATTR13
, B.UOM_EXT_ATTR13 UOM_EXT_ATTR13
, B.N_EXT_ATTR14 N_EXT_ATTR14
, B.UOM_EXT_ATTR14 UOM_EXT_ATTR14
, B.N_EXT_ATTR15 N_EXT_ATTR15
, B.UOM_EXT_ATTR15 UOM_EXT_ATTR15
, B.N_EXT_ATTR16 N_EXT_ATTR16
, B.UOM_EXT_ATTR16 UOM_EXT_ATTR16
, B.N_EXT_ATTR17 N_EXT_ATTR17
, B.UOM_EXT_ATTR17 UOM_EXT_ATTR17
, B.N_EXT_ATTR18 N_EXT_ATTR18
, B.UOM_EXT_ATTR18 UOM_EXT_ATTR18
, B.N_EXT_ATTR19 N_EXT_ATTR19
, B.UOM_EXT_ATTR19 UOM_EXT_ATTR19
, B.N_EXT_ATTR20 N_EXT_ATTR20
, B.UOM_EXT_ATTR20 UOM_EXT_ATTR20
, B.D_EXT_ATTR1 D_EXT_ATTR1
, B.D_EXT_ATTR2 D_EXT_ATTR2
, B.D_EXT_ATTR3 D_EXT_ATTR3
, B.D_EXT_ATTR4 D_EXT_ATTR4
, B.D_EXT_ATTR5 D_EXT_ATTR5
, B.D_EXT_ATTR6 D_EXT_ATTR6
, B.D_EXT_ATTR7 D_EXT_ATTR7
, B.D_EXT_ATTR8 D_EXT_ATTR8
, B.D_EXT_ATTR9 D_EXT_ATTR9
, B.D_EXT_ATTR10 D_EXT_ATTR10
, TL.TL_EXT_ATTR1 TL_EXT_ATTR1
, TL.TL_EXT_ATTR2 TL_EXT_ATTR2
, TL.TL_EXT_ATTR3 TL_EXT_ATTR3
, TL.TL_EXT_ATTR4 TL_EXT_ATTR4
, TL.TL_EXT_ATTR5 TL_EXT_ATTR5
, TL.TL_EXT_ATTR6 TL_EXT_ATTR6
, TL.TL_EXT_ATTR7 TL_EXT_ATTR7
, TL.TL_EXT_ATTR8 TL_EXT_ATTR8
, TL.TL_EXT_ATTR9 TL_EXT_ATTR9
, TL.TL_EXT_ATTR10 TL_EXT_ATTR10
, TL.TL_EXT_ATTR11 TL_EXT_ATTR11
, TL.TL_EXT_ATTR12 TL_EXT_ATTR12
, TL.TL_EXT_ATTR13 TL_EXT_ATTR13
, TL.TL_EXT_ATTR14 TL_EXT_ATTR14
, TL.TL_EXT_ATTR15 TL_EXT_ATTR15
, TL.TL_EXT_ATTR16 TL_EXT_ATTR16
, TL.TL_EXT_ATTR17 TL_EXT_ATTR17
, TL.TL_EXT_ATTR18 TL_EXT_ATTR18
, TL.TL_EXT_ATTR19 TL_EXT_ATTR19
, TL.TL_EXT_ATTR20 TL_EXT_ATTR20
, TL.TL_EXT_ATTR21 TL_EXT_ATTR21
, TL.TL_EXT_ATTR22 TL_EXT_ATTR22
, TL.TL_EXT_ATTR23 TL_EXT_ATTR23
, TL.TL_EXT_ATTR24 TL_EXT_ATTR24
, TL.TL_EXT_ATTR25 TL_EXT_ATTR25
, TL.TL_EXT_ATTR26 TL_EXT_ATTR26
, TL.TL_EXT_ATTR27 TL_EXT_ATTR27
, TL.TL_EXT_ATTR28 TL_EXT_ATTR28
, TL.TL_EXT_ATTR29 TL_EXT_ATTR29
, TL.TL_EXT_ATTR30 TL_EXT_ATTR30
, TL.TL_EXT_ATTR31 TL_EXT_ATTR31
, TL.TL_EXT_ATTR32 TL_EXT_ATTR32
, TL.TL_EXT_ATTR33 TL_EXT_ATTR33
, TL.TL_EXT_ATTR34 TL_EXT_ATTR34
, TL.TL_EXT_ATTR35 TL_EXT_ATTR35
, TL.TL_EXT_ATTR36 TL_EXT_ATTR36
, TL.TL_EXT_ATTR37 TL_EXT_ATTR37
, TL.TL_EXT_ATTR38 TL_EXT_ATTR38
, TL.TL_EXT_ATTR39 TL_EXT_ATTR39
, TL.TL_EXT_ATTR40 TL_EXT_ATTR40
FROM EGO_ITEM_TP_ATTRS_EXT_B B
, EGO_ITEM_TP_ATTRS_EXT_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')