View: EGO_ALL_ATTR_LANG_V

Product:	EGO - Advanced Product Catalog
Description:	Each rov of this view displays all language translated information associated with base and user-defined attributes for a given item.
Implementation/DBA Data:	APPS.EGO_ALL_ATTR_LANG_V

View Text

SELECT EXTENSION_ID AS EXTENSION_ID
, ORGANIZATION_ID AS ORGANIZATION_ID
, INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID
, REVISION_ID AS REVISION_ID
, DATA_LEVEL_ID AS DATA_LEVEL_ID
, PK1_VALUE AS PK1_VALUE
, PK2_VALUE AS PK2_VALUE
, PK3_VALUE AS PK3_VALUE
, PK4_VALUE AS PK4_VALUE
, PK5_VALUE AS PK5_VALUE
, AG.ATTR_GROUP_ID AS ATTRIBUTEGROUP_ID
, AGC.APPLICATION_ID AS APPLICATION_ID
, AG.ATTR_GROUP_NAME AS ATTRIBUTE_GROUP_NAME
, AGC.ATTR_ID AS ATTRIBUTE_ID
, AGC.ATTR_NAME AS ATTRIBUTE_NAME
, AGC.DATA_TYPE_CODE AS DATA_TYPE_CODE
, LANGUAGE AS LANGUAGE
, DECODE(AGC.DATA_TYPE_CODE
, 'A'
, DECODE(DATABASE_COLUMN
, 'TL_EXT_ATTR1'
, UDA.TL_EXT_ATTR1
, 'TL_EXT_ATTR2'
, UDA.TL_EXT_ATTR2
, 'TL_EXT_ATTR3'
, UDA.TL_EXT_ATTR3
, 'TL_EXT_ATTR4'
, UDA.TL_EXT_ATTR4
, 'TL_EXT_ATTR5'
, UDA.TL_EXT_ATTR5
, 'TL_EXT_ATTR6'
, UDA.TL_EXT_ATTR6
, 'TL_EXT_ATTR7'
, UDA.TL_EXT_ATTR7
, 'TL_EXT_ATTR8'
, UDA.TL_EXT_ATTR8
, 'TL_EXT_ATTR9'
, UDA.TL_EXT_ATTR9
, 'TL_EXT_ATTR10'
, UDA.TL_EXT_ATTR10
, 'TL_EXT_ATTR11'
, UDA.TL_EXT_ATTR11
, 'TL_EXT_ATTR12'
, UDA.TL_EXT_ATTR12
, 'TL_EXT_ATTR13'
, UDA.TL_EXT_ATTR13
, 'TL_EXT_ATTR14'
, UDA.TL_EXT_ATTR14
, 'TL_EXT_ATTR15'
, UDA.TL_EXT_ATTR15
, 'TL_EXT_ATTR16'
, UDA.TL_EXT_ATTR16
, 'TL_EXT_ATTR17'
, UDA.TL_EXT_ATTR17
, 'TL_EXT_ATTR18'
, UDA.TL_EXT_ATTR18
, 'TL_EXT_ATTR19'
, UDA.TL_EXT_ATTR19
, 'TL_EXT_ATTR20'
, UDA.TL_EXT_ATTR20)) AS ATTRIBUTE_TRANSLATABLE_VALUE
FROM EGO_ATTRS_V AGC
, EGO_ATTR_GROUPS_V AG
, EGO_MTL_SY_ITEMS_EXT_TL UDA
WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
AND AGC.APPLICATION_ID = AG.APPLICATION_ID
AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE
AND AGC.ATTR_GROUP_NAME = AG.ATTR_GROUP_NAME
AND AGC.DATA_TYPE_CODE = 'A'

Columns