VIEW: APPS.EGO_MTL_SYS_ITEMS_B_EXT_DFV

Source

View Text - Preformatted

SELECT ROWID, ATTR_GROUP_ID, (DECODE (ATTR_GROUP_ID, 'ItemDetailImage', N_EXT_ATTR1, 'ItemDetailDesc', N_EXT_ATTR1, NULL)), C_EXT_ATTR1, (DECODE (ATTR_GROUP_ID, 'ItemDetailImage', C_EXT_ATTR2, 'ItemDetailDesc', C_EXT_ATTR2, NULL)), (DECODE (ATTR_GROUP_ID, 'ItemDetailImage', C_EXT_ATTR3, 'ItemDetailDesc', C_EXT_ATTR3, NULL)), (DECODE (ATTR_GROUP_ID, 'ItemDetailImage', C_EXT_ATTR4, 'ItemDetailDesc', C_EXT_ATTR4, NULL)), (DECODE (ATTR_GROUP_ID, 'ItemDetailDesc', ATTR_GROUP_ID || '|' || N_EXT_ATTR1 || '|' || C_EXT_ATTR1 || '|' || C_EXT_ATTR2 || '|' || C_EXT_ATTR3 || '|' || C_EXT_ATTR4, 'ItemDetailImage', ATTR_GROUP_ID || '|' || N_EXT_ATTR1 || '|' || C_EXT_ATTR2 || '|' || C_EXT_ATTR3 || '|' || C_EXT_ATTR4, NULL)) FROM EGO_MTL_SYS_ITEMS_B_EXT

View Text - HTML Formatted

SELECT ROWID
, ATTR_GROUP_ID
, (DECODE (ATTR_GROUP_ID
, 'ITEMDETAILIMAGE'
, N_EXT_ATTR1
, 'ITEMDETAILDESC'
, N_EXT_ATTR1
, NULL))
, C_EXT_ATTR1
, (DECODE (ATTR_GROUP_ID
, 'ITEMDETAILIMAGE'
, C_EXT_ATTR2
, 'ITEMDETAILDESC'
, C_EXT_ATTR2
, NULL))
, (DECODE (ATTR_GROUP_ID
, 'ITEMDETAILIMAGE'
, C_EXT_ATTR3
, 'ITEMDETAILDESC'
, C_EXT_ATTR3
, NULL))
, (DECODE (ATTR_GROUP_ID
, 'ITEMDETAILIMAGE'
, C_EXT_ATTR4
, 'ITEMDETAILDESC'
, C_EXT_ATTR4
, NULL))
, (DECODE (ATTR_GROUP_ID
, 'ITEMDETAILDESC'
, ATTR_GROUP_ID || '|' || N_EXT_ATTR1 || '|' || C_EXT_ATTR1 || '|' || C_EXT_ATTR2 || '|' || C_EXT_ATTR3 || '|' || C_EXT_ATTR4
, 'ITEMDETAILIMAGE'
, ATTR_GROUP_ID || '|' || N_EXT_ATTR1 || '|' || C_EXT_ATTR2 || '|' || C_EXT_ATTR3 || '|' || C_EXT_ATTR4
, NULL))
FROM EGO_MTL_SYS_ITEMS_B_EXT