APPS.EGO_SYS_ITEM_EXT_LANG_V
[Home] [Help]
| Product: | EGO - Advanced Product Catalog |
|---|---|
| Description: | View contains Item User-Defined Attribute Group data with langauge and Attribute group Type |
| Implementation/DBA Data: |
APPS.EGO_SYS_ITEM_EXT_LANG_V
|
SELECT B.EXTENSION_ID EXTENSION_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.REVISION_ID REVISION_ID
, B.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, B.ATTR_GROUP_ID ATTR_GROUP_ID
, E.APPLICATION_ID APPLICATION_ID
, E.DESCRIPTIVE_FLEXFIELD_NAME ATTR_GROUP_TYPE
, E.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME
, 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_ATTR1 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_MTL_SY_ITEMS_EXT_B B
, EGO_MTL_SY_ITEMS_EXT_TL TL
, EGO_FND_DSC_FLX_CTX_EXT E
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND B.ATTR_GROUP_ID = E.ATTR_GROUP_ID