SELECT ROWID, PJO_INFORMATION_CATEGORY, PJO_INFORMATION1, (DECODE (PJO_INFORMATION_CATEGORY, 'FR_PQH', PJO_INFORMATION4, 'DE', PJO_INFORMATION2, NULL)), PJO_INFORMATION4, PJO_INFORMATION5, (DECODE (PJO_INFORMATION_CATEGORY, 'DE', FND_NUMBER.CANONICAL_TO_NUMBER(PJO_INFORMATION6), NULL)), PJO_INFORMATION1, PJO_INFORMATION2, PJO_INFORMATION3, PJO_INFORMATION5, PJO_INFORMATION6, (DECODE (PJO_INFORMATION_CATEGORY, 'NO', FND_NUMBER.CANONICAL_TO_NUMBER(PJO_INFORMATION1), NULL)), PJO_INFORMATION1, PJO_INFORMATION1, PJO_INFORMATION2, PJO_INFORMATION3, PJO_INFORMATION4, PJO_INFORMATION5, PJO_INFORMATION6, PJO_INFORMATION7,
(DECODE (PJO_INFORMATION_CATEGORY,
'DE', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1 || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6,
'FI', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1,
'FR_PQH', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION3 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6,
'NO', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1,
'PL', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1,
'RU', PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1 || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION3 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6 || '.' || PJO_INFORMATION7, NULL))
FROM PER_PREVIOUS_JOBS
SELECT ROWID
, PJO_INFORMATION_CATEGORY
, PJO_INFORMATION1
, (DECODE (PJO_INFORMATION_CATEGORY
, 'FR_PQH'
, PJO_INFORMATION4
, 'DE'
, PJO_INFORMATION2
, NULL))
, PJO_INFORMATION4
, PJO_INFORMATION5
, (DECODE (PJO_INFORMATION_CATEGORY
, 'DE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PJO_INFORMATION6)
, NULL))
, PJO_INFORMATION1
, PJO_INFORMATION2
, PJO_INFORMATION3
, PJO_INFORMATION5
, PJO_INFORMATION6
, (DECODE (PJO_INFORMATION_CATEGORY
, 'NO'
, FND_NUMBER.CANONICAL_TO_NUMBER(PJO_INFORMATION1)
, NULL))
, PJO_INFORMATION1
, PJO_INFORMATION1
, PJO_INFORMATION2
, PJO_INFORMATION3
, PJO_INFORMATION4
, PJO_INFORMATION5
, PJO_INFORMATION6
, PJO_INFORMATION7
,
(DECODE (PJO_INFORMATION_CATEGORY
,
'DE'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1 || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6
,
'FI'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1
,
'FR_PQH'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION3 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6
,
'NO'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1
,
'PL'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1
,
'RU'
, PJO_INFORMATION_CATEGORY || '.' || PJO_INFORMATION1 || '.' || PJO_INFORMATION2 || '.' || PJO_INFORMATION3 || '.' || PJO_INFORMATION4 || '.' || PJO_INFORMATION5 || '.' || PJO_INFORMATION6 || '.' || PJO_INFORMATION7
, NULL))
FROM PER_PREVIOUS_JOBS
|
|
|