VIEW: APPS.HRI_OBI_CL_RVAC_REQSTN_V

Source

View Text - Preformatted

SELECT req.requisition_id REQN_REQSTN_PK, req.name REQN_REQUISITION_NAME, req.name || ' (' || to_char(req.requisition_id) || ')' REQN_REQUISITION_NAME_UNQ, req.person_id REQN_PERSON_FK, req.description REQN_REQUISITION_DESC, req.date_from REQN_VALID_FROM, req.date_to REQN_VALID_TO, req.name REQN_ORDER_BY FROM per_requisitions req UNION ALL SELECT id REQN_REQSTN_PK, hri_oltp_view_message.get_unassigned_msg REQN_REQUISITION_NAME, hri_oltp_view_message.get_unassigned_msg REQN_REQUISITION_NAME_UNQ, id REQN_PERSON_FK, hri_oltp_view_message.get_unassigned_msg REQN_REQUISITION_DESC, hr_general.start_of_time REQN_VALID_FROM, hr_general.end_of_time REQN_VALID_TO, hri_oltp_view_message.get_unassigned_msg REQN_ORDER_BY FROM HRI_UNASSIGNED WITH READ ONLY

View Text - HTML Formatted

SELECT REQ.REQUISITION_ID REQN_REQSTN_PK
, REQ.NAME REQN_REQUISITION_NAME
, REQ.NAME || ' (' || TO_CHAR(REQ.REQUISITION_ID) || ')' REQN_REQUISITION_NAME_UNQ
, REQ.PERSON_ID REQN_PERSON_FK
, REQ.DESCRIPTION REQN_REQUISITION_DESC
, REQ.DATE_FROM REQN_VALID_FROM
, REQ.DATE_TO REQN_VALID_TO
, REQ.NAME REQN_ORDER_BY
FROM PER_REQUISITIONS REQ UNION ALL SELECT ID REQN_REQSTN_PK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG REQN_REQUISITION_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG REQN_REQUISITION_NAME_UNQ
, ID REQN_PERSON_FK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG REQN_REQUISITION_DESC
, HR_GENERAL.START_OF_TIME REQN_VALID_FROM
, HR_GENERAL.END_OF_TIME REQN_VALID_TO
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG REQN_ORDER_BY
FROM HRI_UNASSIGNED WITH READ ONLY