SELECT ROWID, DEI_INFORMATION_CATEGORY, DEI_INFORMATION1, DEI_INFORMATION2, DEI_INFORMATION3, DEI_INFORMATION4, (DECODE (DEI_INFORMATION_CATEGORY, 'AE_PASSPORT', FND_NUMBER.CANONICAL_TO_NUMBER(DEI_INFORMATION5), NULL)), DEI_INFORMATION1, DEI_INFORMATION2, DEI_INFORMATION3, DEI_INFORMATION4, DEI_INFORMATION5, DEI_INFORMATION6, DEI_INFORMATION7, DEI_INFORMATION8, DEI_INFORMATION9, (DECODE (DEI_INFORMATION_CATEGORY, 'PL_PASSPORT', DEI_INFORMATION1, 'PL_MILITARY_BOOK', DEI_INFORMATION1, 'PL_IDENTITY_CARD', DEI_INFORMATION1, 'NO_LIAISON_MEETING', DEI_INFORMATION1, 'NO_FOLLOWUP_PLAN', DEI_INFORMATION1, NULL)),
(DECODE (DEI_INFORMATION_CATEGORY,
'AE_PASSPORT', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1 || '.' || DEI_INFORMATION2 || '.' || DEI_INFORMATION3 || '.' || DEI_INFORMATION4 || '.' || DEI_INFORMATION5,
'AE_VISA', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1 || '.' || DEI_INFORMATION2 || '.' || DEI_INFORMATION3 || '.' || DEI_INFORMATION4 || '.' || DEI_INFORMATION5 || '.' || DEI_INFORMATION6 || '.' || DEI_INFORMATION7 || '.' || DEI_INFORMATION8 || '.' || DEI_INFORMATION9,
'NO_FOLLOWUP_PLAN', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1,
'NO_LIAISON_MEETING', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1,
'PL_IDENTITY_CARD', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1,
'PL_MILITARY_BOOK', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1,
'PL_PASSPORT', DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1, NULL))
FROM HR_DOCUMENT_EXTRA_INFO
SELECT ROWID
, DEI_INFORMATION_CATEGORY
, DEI_INFORMATION1
, DEI_INFORMATION2
, DEI_INFORMATION3
, DEI_INFORMATION4
, (DECODE (DEI_INFORMATION_CATEGORY
, 'AE_PASSPORT'
, FND_NUMBER.CANONICAL_TO_NUMBER(DEI_INFORMATION5)
, NULL))
, DEI_INFORMATION1
, DEI_INFORMATION2
, DEI_INFORMATION3
, DEI_INFORMATION4
, DEI_INFORMATION5
, DEI_INFORMATION6
, DEI_INFORMATION7
, DEI_INFORMATION8
, DEI_INFORMATION9
, (DECODE (DEI_INFORMATION_CATEGORY
, 'PL_PASSPORT'
, DEI_INFORMATION1
, 'PL_MILITARY_BOOK'
, DEI_INFORMATION1
, 'PL_IDENTITY_CARD'
, DEI_INFORMATION1
, 'NO_LIAISON_MEETING'
, DEI_INFORMATION1
, 'NO_FOLLOWUP_PLAN'
, DEI_INFORMATION1
, NULL))
,
(DECODE (DEI_INFORMATION_CATEGORY
,
'AE_PASSPORT'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1 || '.' || DEI_INFORMATION2 || '.' || DEI_INFORMATION3 || '.' || DEI_INFORMATION4 || '.' || DEI_INFORMATION5
,
'AE_VISA'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1 || '.' || DEI_INFORMATION2 || '.' || DEI_INFORMATION3 || '.' || DEI_INFORMATION4 || '.' || DEI_INFORMATION5 || '.' || DEI_INFORMATION6 || '.' || DEI_INFORMATION7 || '.' || DEI_INFORMATION8 || '.' || DEI_INFORMATION9
,
'NO_FOLLOWUP_PLAN'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1
,
'NO_LIAISON_MEETING'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1
,
'PL_IDENTITY_CARD'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1
,
'PL_MILITARY_BOOK'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1
,
'PL_PASSPORT'
, DEI_INFORMATION_CATEGORY || '.' || DEI_INFORMATION1
, NULL))
FROM HR_DOCUMENT_EXTRA_INFO
|
|
|