VIEW: APPS.HRI_OBI_CL_JOB_JOB_V

Source

View Text - Preformatted

SELECT jobh.job_id JOB_JOB_PK ,job_name.name JOB_JOB_NAME ,job_name.name || ' (' || job.business_group_id || ')' JOB_JOB_NAME_UNQ ,hri_bpl_job.get_job_display_name( jobh.job_id ,job.business_group_id ,job_name.name) JOB_DISPLAY_NAME ,job.date_from JOB_START_DATE ,NVL(job.date_to, hr_general.end_of_time) JOB_END_DATE ,job_name.name JOB_ORDER_BY ,jobh.job_fmly_code JOB_FAMILY_FK ,jobh.job_fnctn_code JOB_FUNCTION_FK ,jobh.job_fmly_code || ' (' || jobh.job_fnctn_code ||')' JOB_FMLYFNCT_FK FROM hri_cs_jobh_ct jobh ,per_jobs job ,per_jobs_tl job_name WHERE jobh.job_id = job.job_id AND job.job_id = job_name.job_id AND job_name.language = USERENV('LANG') UNION ALL SELECT id ,hri_oltp_view_message.get_unassigned_msg ,hri_oltp_view_message.get_unassigned_msg ,hri_oltp_view_message.get_unassigned_msg ,hr_general.start_of_time ,hr_general.end_of_time ,'' ,id_char ,id_char ,id_char FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT JOBH.JOB_ID JOB_JOB_PK
, JOB_NAME.NAME JOB_JOB_NAME
, JOB_NAME.NAME || ' (' || JOB.BUSINESS_GROUP_ID || ')' JOB_JOB_NAME_UNQ
, HRI_BPL_JOB.GET_JOB_DISPLAY_NAME( JOBH.JOB_ID
, JOB.BUSINESS_GROUP_ID
, JOB_NAME.NAME) JOB_DISPLAY_NAME
, JOB.DATE_FROM JOB_START_DATE
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) JOB_END_DATE
, JOB_NAME.NAME JOB_ORDER_BY
, JOBH.JOB_FMLY_CODE JOB_FAMILY_FK
, JOBH.JOB_FNCTN_CODE JOB_FUNCTION_FK
, JOBH.JOB_FMLY_CODE || ' (' || JOBH.JOB_FNCTN_CODE ||')' JOB_FMLYFNCT_FK
FROM HRI_CS_JOBH_CT JOBH
, PER_JOBS JOB
, PER_JOBS_TL JOB_NAME
WHERE JOBH.JOB_ID = JOB.JOB_ID
AND JOB.JOB_ID = JOB_NAME.JOB_ID
AND JOB_NAME.LANGUAGE = USERENV('LANG') UNION ALL SELECT ID
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, ''
, ID_CHAR
, ID_CHAR
, ID_CHAR
FROM HRI_UNASSIGNED WITH READ ONLY