SELECT ROWID, JEI_INFORMATION_CATEGORY, JEI_INFORMATION1, JEI_INFORMATION2, JEI_INFORMATION3, (DECODE (JEI_INFORMATION_CATEGORY, 'Job Category', FND_NUMBER.CANONICAL_TO_NUMBER(JEI_INFORMATION4), NULL)), JEI_INFORMATION5, JEI_INFORMATION6, JEI_INFORMATION1, JEI_INFORMATION2, JEI_INFORMATION1,
(DECODE (JEI_INFORMATION_CATEGORY,
'Job Category', JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION1 || '.' || JEI_INFORMATION2 || '.' || JEI_INFORMATION3 || '.' || JEI_INFORMATION4 || '.' || JEI_INFORMATION5 || '.' || JEI_INFORMATION6,
'MX_SS_SALARY_TYPE', JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION1,
'PER_SUCCESSION_PLANNING', JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION2 || '.' || JEI_INFORMATION1, NULL))
FROM PER_JOB_EXTRA_INFO
SELECT ROWID
, JEI_INFORMATION_CATEGORY
, JEI_INFORMATION1
, JEI_INFORMATION2
, JEI_INFORMATION3
, (DECODE (JEI_INFORMATION_CATEGORY
, 'JOB CATEGORY'
, FND_NUMBER.CANONICAL_TO_NUMBER(JEI_INFORMATION4)
, NULL))
, JEI_INFORMATION5
, JEI_INFORMATION6
, JEI_INFORMATION1
, JEI_INFORMATION2
, JEI_INFORMATION1
,
(DECODE (JEI_INFORMATION_CATEGORY
,
'JOB CATEGORY'
, JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION1 || '.' || JEI_INFORMATION2 || '.' || JEI_INFORMATION3 || '.' || JEI_INFORMATION4 || '.' || JEI_INFORMATION5 || '.' || JEI_INFORMATION6
,
'MX_SS_SALARY_TYPE'
, JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION1
,
'PER_SUCCESSION_PLANNING'
, JEI_INFORMATION_CATEGORY || '.' || JEI_INFORMATION2 || '.' || JEI_INFORMATION1
, NULL))
FROM PER_JOB_EXTRA_INFO
|
|
|