select
pjt.name "Name",
--
pjei.jei_information_category "Type",
decode (pjei.jei_information_category,
'Job Category',pjei.jei_information1||'.'||pjei.jei_information2||'.'||pjei.jei_information3||'.'
||pjei.jei_information4|| '.'|| pjei.jei_information5|| '.'|| pjei.jei_information6,
'MX_SS_SALARY_TYPE', pjei.jei_information1,
'PER_SUCCESSION_PLANNING', pjei.jei_information2|| '.'|| pjei.jei_information1,
null) "Details",
--
pj.job_id
from
per_job_extra_info pjei,
per_jobs pj,
per_jobs_tl pjt
where
1=1
and pjei.job_id = pj.job_id
and pj.job_id = pjt.job_id
and pjt.language = userenv('LANG')
--
and pjt.name like 'ACC400%'
order by
1;
No comments:
Post a Comment