SELECT ROWID, VALUE_CATEGORY, (DECODE (VALUE_CATEGORY, 'FND_TX_CLASSES', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE1), NULL)), ATTRIBUTE2, ATTRIBUTE1, ATTRIBUTE2,
(DECODE (VALUE_CATEGORY,
'FND_TX_CLASSES', VALUE_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2,
'FND_TX_GROUPS', VALUE_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2, NULL))
FROM FND_FLEX_VALUES
SELECT ROWID
, VALUE_CATEGORY
, (DECODE (VALUE_CATEGORY
, 'FND_TX_CLASSES'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE1)
, NULL))
, ATTRIBUTE2
, ATTRIBUTE1
, ATTRIBUTE2
,
(DECODE (VALUE_CATEGORY
,
'FND_TX_CLASSES'
, VALUE_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2
,
'FND_TX_GROUPS'
, VALUE_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2
, NULL))
FROM FND_FLEX_VALUES
|
|
|