VIEW: APPS.HRI_CS_JOBCAT_V

Source

View Text - Preformatted

SELECT job.job_id JOB_ID , NVL(jei.jei_information1, 'NA_EDW') JOB_CAT_CODE , job.date_from EFFECTIVE_START_DATE , NVL(job.date_to,hr_general.end_of_time) EFFECTIVE_END_DATE FROM per_job_extra_info jei , per_jobs job WHERE jei.jei_information_category (+) = 'Job Category' AND job.job_id = jei.job_id (+) UNION ALL SELECT -1 job_id , 'NA_EDW' job_cat_code , hr_general.start_of_time EFFECTIVE_START_DATE , hr_general.end_of_time EFFECTIVE_END_DATE FROM dual

View Text - HTML Formatted

SELECT JOB.JOB_ID JOB_ID
, NVL(JEI.JEI_INFORMATION1
, 'NA_EDW') JOB_CAT_CODE
, JOB.DATE_FROM EFFECTIVE_START_DATE
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) EFFECTIVE_END_DATE
FROM PER_JOB_EXTRA_INFO JEI
, PER_JOBS JOB
WHERE JEI.JEI_INFORMATION_CATEGORY (+) = 'JOB CATEGORY'
AND JOB.JOB_ID = JEI.JOB_ID (+) UNION ALL SELECT -1 JOB_ID
, 'NA_EDW' JOB_CAT_CODE
, HR_GENERAL.START_OF_TIME EFFECTIVE_START_DATE
, HR_GENERAL.END_OF_TIME EFFECTIVE_END_DATE
FROM DUAL