SELECT ROWID, QUA_INFORMATION_CATEGORY, (DECODE (QUA_INFORMATION_CATEGORY, 'DE', TO_DATE(QUA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), QUA_INFORMATION2, QUA_INFORMATION3, QUA_INFORMATION4, QUA_INFORMATION1, (DECODE (QUA_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION1), NULL)), QUA_INFORMATION2, QUA_INFORMATION1, (DECODE (QUA_INFORMATION_CATEGORY, 'FR', TO_DATE(QUA_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), QUA_INFORMATION3, QUA_INFORMATION4, QUA_INFORMATION5, QUA_INFORMATION1, QUA_INFORMATION2, QUA_INFORMATION1, QUA_INFORMATION2, QUA_INFORMATION3, (DECODE (QUA_INFORMATION_CATEGORY, 'NO', FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION4), NULL)), QUA_INFORMATION1, QUA_INFORMATION2, QUA_INFORMATION3, QUA_INFORMATION4, QUA_INFORMATION5, QUA_INFORMATION7, QUA_INFORMATION6, QUA_INFORMATION1, QUA_INFORMATION2,
(DECODE (QUA_INFORMATION_CATEGORY,
'DE', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4,
'DE_PQH', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1,
'FI', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2,
'FR', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5,
'HU', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2,
'NO', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4,
'RU', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5 || '.' || QUA_INFORMATION7 || '.' || QUA_INFORMATION6,
'SE', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2, NULL))
FROM PER_QUALIFICATIONS
SELECT ROWID
, QUA_INFORMATION_CATEGORY
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(QUA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, QUA_INFORMATION2
, QUA_INFORMATION3
, QUA_INFORMATION4
, QUA_INFORMATION1
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION1)
, NULL))
, QUA_INFORMATION2
, QUA_INFORMATION1
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(QUA_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, QUA_INFORMATION3
, QUA_INFORMATION4
, QUA_INFORMATION5
, QUA_INFORMATION1
, QUA_INFORMATION2
, QUA_INFORMATION1
, QUA_INFORMATION2
, QUA_INFORMATION3
, (DECODE (QUA_INFORMATION_CATEGORY
, 'NO'
, FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION4)
, NULL))
, QUA_INFORMATION1
, QUA_INFORMATION2
, QUA_INFORMATION3
, QUA_INFORMATION4
, QUA_INFORMATION5
, QUA_INFORMATION7
, QUA_INFORMATION6
, QUA_INFORMATION1
, QUA_INFORMATION2
,
(DECODE (QUA_INFORMATION_CATEGORY
,
'DE'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4
,
'DE_PQH'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1
,
'FI'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
,
'FR'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5
,
'HU'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
,
'NO'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4
,
'RU'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5 || '.' || QUA_INFORMATION7 || '.' || QUA_INFORMATION6
,
'SE'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
, NULL))
FROM PER_QUALIFICATIONS
|
|
|