VIEW: APPS.HRI_OBI_CL_POS_POSITION_V

Source

View Text - Preformatted

SELECT POS.POSITION_ID , POS.NAME , POS.NAME||' ('||POS.POSITION_ID||')' , POS.DATE_EFFECTIVE , NVL(POS.DATE_END, HR_GENERAL.END_OF_TIME) , POS.NAME , POS.ORGANIZATION_ID , POS.JOB_ID , POS.POSITION_DEFINITION_ID FROM PER_POSITIONS POS UNION ALL SELECT ID, hri_oltp_view_message.get_unassigned_msg, hri_oltp_view_message.get_unassigned_msg||'('||ID||')', hr_general.start_of_time, hr_general.end_of_time, '', ID, ID, ID FROM HRI_UNASSIGNED WITH READ ONLY

View Text - HTML Formatted

SELECT POS.POSITION_ID
, POS.NAME
, POS.NAME||' ('||POS.POSITION_ID||')'
, POS.DATE_EFFECTIVE
, NVL(POS.DATE_END
, HR_GENERAL.END_OF_TIME)
, POS.NAME
, POS.ORGANIZATION_ID
, POS.JOB_ID
, POS.POSITION_DEFINITION_ID
FROM PER_POSITIONS POS UNION ALL SELECT ID
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG||'('||ID||')'
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, ''
, ID
, ID
, ID
FROM HRI_UNASSIGNED WITH READ ONLY