VIEW: APPS.HRI_OBI_CL_RACT_RECACTVY_V

Source

View Text - Preformatted

SELECT pra.RECRUITMENT_ACTIVITY_ID ,pra.NAME ,pra.NAME||' ('||pra.RECRUITMENT_ACTIVITY_ID||')' ,pra.DATE_START ,pra.DATE_END ,NVL(pra.TYPE, 'NA_EDW') ,pra.CONTACT_TELEPHONE_NUMBER ,pra.DATE_CLOSING ,pra.EXTERNAL_CONTACT ,pra.LAST_POSTED_DATE ,pra.NAME FROM PER_RECRUITMENT_ACTIVITIES pra UNION ALL SELECT ID ,NVL(VALUE,hri_oltp_view_message.get_unassigned_msg) ,NVL(VALUE,hri_oltp_view_message.get_unassigned_msg)||' ('||ID||')' ,hr_general.start_of_time ,hr_general.end_of_time ,ID_CHAR ,null ,to_date(null) ,null ,to_date(null) ,null FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT PRA.RECRUITMENT_ACTIVITY_ID
, PRA.NAME
, PRA.NAME||' ('||PRA.RECRUITMENT_ACTIVITY_ID||')'
, PRA.DATE_START
, PRA.DATE_END
, NVL(PRA.TYPE
, 'NA_EDW')
, PRA.CONTACT_TELEPHONE_NUMBER
, PRA.DATE_CLOSING
, PRA.EXTERNAL_CONTACT
, PRA.LAST_POSTED_DATE
, PRA.NAME
FROM PER_RECRUITMENT_ACTIVITIES PRA UNION ALL SELECT ID
, NVL(VALUE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)
, NVL(VALUE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)||' ('||ID||')'
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, ID_CHAR
, NULL
, TO_DATE(NULL)
, NULL
, TO_DATE(NULL)
, NULL
FROM HRI_UNASSIGNED WITH READ ONLY