VIEW: APPS.PER_BUDGET_VALUES1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, BUDGET_INFORMATION1,  
 (DECODE (INFORMATION_CATEGORY,  
      'FR', INFORMATION_CATEGORY || '.' || BUDGET_INFORMATION1, NULL)) 
 FROM PER_BUDGET_VALUES

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, BUDGET_INFORMATION1
, (DECODE (INFORMATION_CATEGORY
, 'FR'
, INFORMATION_CATEGORY || '.' || BUDGET_INFORMATION1
, NULL))
FROM PER_BUDGET_VALUES