VIEW: APPS.HRI_CL_JOB_CAT_JOB_V

Source

View Text - Preformatted

SELECT jei.job_id ID , hrl.meaning VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , jei.job_id job_id , jei.jei_information1 job_cat_code FROM per_job_extra_info jei , hr_lookups hrl WHERE jei.jei_information_category = 'Job Category' AND hrl.lookup_type = 'JOB_CATEGORIES' AND hrl.enabled_flag = 'Y' AND jei.jei_information1 = hrl.lookup_code UNION ALL SELECT job.job_id ID , to_char(NULL) VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , job.job_id job_id , 'NA_EDW' job_cat_code FROM per_jobs job UNION ALL SELECT -1 ID , to_char(NULL) VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , -1 job_id , 'NA_EDW' job_cat_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT JEI.JOB_ID ID
, HRL.MEANING VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, JEI.JOB_ID JOB_ID
, JEI.JEI_INFORMATION1 JOB_CAT_CODE
FROM PER_JOB_EXTRA_INFO JEI
, HR_LOOKUPS HRL
WHERE JEI.JEI_INFORMATION_CATEGORY = 'JOB CATEGORY'
AND HRL.LOOKUP_TYPE = 'JOB_CATEGORIES'
AND HRL.ENABLED_FLAG = 'Y'
AND JEI.JEI_INFORMATION1 = HRL.LOOKUP_CODE UNION ALL SELECT JOB.JOB_ID ID
, TO_CHAR(NULL) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, JOB.JOB_ID JOB_ID
, 'NA_EDW' JOB_CAT_CODE
FROM PER_JOBS JOB UNION ALL SELECT -1 ID
, TO_CHAR(NULL) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 JOB_ID
, 'NA_EDW' JOB_CAT_CODE
FROM DUAL WITH READ ONLY