VIEW: APPS.EDW_HR_RQN_VCNCY_FKV

Source

View Text - Preformatted

SELECT /* $Header: hrisvvc.odf 115.5 2001/11/01 01:21:25 pkm ship       $ */ req.requisition_pk || '-' || vcs.vacancy_id || '-' || inst.instance_code vacancy_pk ,vcs.vacancy_id vacancy_id FROM edw_local_instance inst ,per_all_vacancies vcs ,edw_hr_rqvc_requistn_lcv req WHERE vcs.requisition_id = req.requisition_id

View Text - HTML Formatted

SELECT /* $HEADER: HRISVVC.ODF 115.5 2001/11/01 01:21:25 PKM SHIP $ */ REQ.REQUISITION_PK || '-' || VCS.VACANCY_ID || '-' || INST.INSTANCE_CODE VACANCY_PK
, VCS.VACANCY_ID VACANCY_ID
FROM EDW_LOCAL_INSTANCE INST
, PER_ALL_VACANCIES VCS
, EDW_HR_RQVC_REQUISTN_LCV REQ
WHERE VCS.REQUISITION_ID = REQ.REQUISITION_ID