VIEW: APPS.EGO_ALL_ATTR_LANG_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'