VIEW: APPS.HRI_DBI_CL_JOB_V

Source

View Text - Preformatted

SELECT job.job_id ID , job.name VALUE , job.date_from START_DATE , nvl(job.date_to,hr_general.end_of_time) END_DATE , job.business_group_id BUSINESS_GROUP_ID FROM per_jobs job UNION ALL SELECT ID ID ,hri_oltp_view_message.get_unassigned_msg VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,-1 BUSINESS_GROUP_ID FROM HRI_UNASSIGNED WITH READ ONLY

View Text - HTML Formatted

SELECT JOB.JOB_ID ID
, JOB.NAME VALUE
, JOB.DATE_FROM START_DATE
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, JOB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_JOBS JOB UNION ALL SELECT ID ID
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
FROM HRI_UNASSIGNED WITH READ ONLY