SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'REMUNERATION_REGULATION', INFORMATION1, 'PURGE', INFORMATION1, 'OPERATION_PLAN', INFORMATION1, 'LOCAL_COST_OF_LIVING', INFORMATION1, NULL)),
(DECODE (INFORMATION_CATEGORY,
'FEDREP', INFORMATION_CATEGORY,
'LOCAL_COST_OF_LIVING', INFORMATION_CATEGORY || '.' || INFORMATION1,
'OPERATION_PLAN', INFORMATION_CATEGORY || '.' || INFORMATION1,
'PURGE', INFORMATION_CATEGORY || '.' || INFORMATION1,
'REMUNERATION_REGULATION', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL))
FROM PER_GEN_HIERARCHY
SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'REMUNERATION_REGULATION'
, INFORMATION1
, 'PURGE'
, INFORMATION1
, 'OPERATION_PLAN'
, INFORMATION1
, 'LOCAL_COST_OF_LIVING'
, INFORMATION1
, NULL))
,
(DECODE (INFORMATION_CATEGORY
,
'FEDREP'
, INFORMATION_CATEGORY
,
'LOCAL_COST_OF_LIVING'
, INFORMATION_CATEGORY || '.' || INFORMATION1
,
'OPERATION_PLAN'
, INFORMATION_CATEGORY || '.' || INFORMATION1
,
'PURGE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
,
'REMUNERATION_REGULATION'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PER_GEN_HIERARCHY
|
|
|