SELECT ROWID, INFORMATION_CATEGORY, INFORMATION1, INFORMATION2, INFORMATION3, INFORMATION4, (DECODE (INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5), NULL)), INFORMATION6, INFORMATION7, INFORMATION1,
(DECODE (INFORMATION_CATEGORY,
'FR', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7,
'NO', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL))
FROM PER_QUALIFICATION_TYPES
SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, (DECODE (INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5)
, NULL))
, INFORMATION6
, INFORMATION7
, INFORMATION1
,
(DECODE (INFORMATION_CATEGORY
,
'FR'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7
,
'NO'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PER_QUALIFICATION_TYPES
|
|
|