SELECT ROWID, REVAL_ATTRIBUTE_CATEGORY, MAX_FULLY_RSVD_REVALS, LIFE_EXTENSION_FACTOR, LIFE_EXTENSION_CEILING,
(DECODE (REVAL_ATTRIBUTE_CATEGORY,
'NO', REVAL_ATTRIBUTE_CATEGORY,
'YES', REVAL_ATTRIBUTE_CATEGORY || '.' || MAX_FULLY_RSVD_REVALS || '.' || LIFE_EXTENSION_FACTOR || '.' || LIFE_EXTENSION_CEILING, NULL))
FROM FA_MASS_REVALUATION_RULES
SELECT ROWID
, REVAL_ATTRIBUTE_CATEGORY
, MAX_FULLY_RSVD_REVALS
, LIFE_EXTENSION_FACTOR
, LIFE_EXTENSION_CEILING
,
(DECODE (REVAL_ATTRIBUTE_CATEGORY
,
'NO'
, REVAL_ATTRIBUTE_CATEGORY
,
'YES'
, REVAL_ATTRIBUTE_CATEGORY || '.' || MAX_FULLY_RSVD_REVALS || '.' || LIFE_EXTENSION_FACTOR || '.' || LIFE_EXTENSION_CEILING
, NULL))
FROM FA_MASS_REVALUATION_RULES
|
|
|