DBA Data[Home] [Help]

VIEW: APPS.FND_FLEX_VALUES_DFV

Source

View Text - Preformatted

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
View Text - HTML Formatted

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