[Home] [Help]
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