VIEW: APPS.HRI_OBI_CL_RVAC_VACNCY_V

Source

View Text - Preformatted

SELECT vac.vacancy_id VAC_VACNCY_PK, vac.name VAC_VACANCY_NAME, vac.name || ' (' || to_char(vac.vacancy_id) || ')' VAC_VACANCY_NAME_UNQ, vac.description VAC_VACANCY_DESC, vac.date_from VAC_VALID_FROM, nvl(vac.date_to, hr_general.end_of_time) VAC_VALID_TO, vac.requisition_id VAC_REQSTN_FK, vac.name VAC_ORDER_BY, vac.status VAC_STATUS_CODE, vac.vacancy_category VAC_CATEGORY_CODE, hr_bis.bis_decode_lookup('VACANCY_STATUS', vac.status) VAC_STATUS_NAME, hr_bis.bis_decode_lookup('VACANCY_CATEGORY', vac.vacancy_category) VAC_CATEGORY_NAME FROM per_all_vacancies vac UNION ALL SELECT id VAC_VACNCY_PK, hri_oltp_view_message.get_unassigned_msg VAC_VACANCY_NAME, hri_oltp_view_message.get_unassigned_msg VAC_VACANCY_NAME_UNQ, hri_oltp_view_message.get_unassigned_msg VAC_VACANCY_DESC, hr_general.start_of_time VAC_VALID_FROM, hr_general.end_of_time VAC_VALID_TO, id VAC_REQSTN_FK, hri_oltp_view_message.get_unassigned_msg VAC_ORDER_BY, hri_oltp_view_message.get_unassigned_msg VAC_STATUS_CODE, hri_oltp_view_message.get_unassigned_msg VAC_CATEGORY_CODE, hri_oltp_view_message.get_unassigned_msg VAC_STATUS_NAME, hri_oltp_view_message.get_unassigned_msg VAC_CATEGORY_NAME FROM HRI_UNASSIGNED WITH READ ONLY

View Text - HTML Formatted

SELECT VAC.VACANCY_ID VAC_VACNCY_PK
, VAC.NAME VAC_VACANCY_NAME
, VAC.NAME || ' (' || TO_CHAR(VAC.VACANCY_ID) || ')' VAC_VACANCY_NAME_UNQ
, VAC.DESCRIPTION VAC_VACANCY_DESC
, VAC.DATE_FROM VAC_VALID_FROM
, NVL(VAC.DATE_TO
, HR_GENERAL.END_OF_TIME) VAC_VALID_TO
, VAC.REQUISITION_ID VAC_REQSTN_FK
, VAC.NAME VAC_ORDER_BY
, VAC.STATUS VAC_STATUS_CODE
, VAC.VACANCY_CATEGORY VAC_CATEGORY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_STATUS'
, VAC.STATUS) VAC_STATUS_NAME
, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_CATEGORY'
, VAC.VACANCY_CATEGORY) VAC_CATEGORY_NAME
FROM PER_ALL_VACANCIES VAC UNION ALL SELECT ID VAC_VACNCY_PK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_VACANCY_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_VACANCY_NAME_UNQ
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_VACANCY_DESC
, HR_GENERAL.START_OF_TIME VAC_VALID_FROM
, HR_GENERAL.END_OF_TIME VAC_VALID_TO
, ID VAC_REQSTN_FK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_ORDER_BY
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_STATUS_CODE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_CATEGORY_CODE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_STATUS_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VAC_CATEGORY_NAME
FROM HRI_UNASSIGNED WITH READ ONLY