[Home] [Help]
View: EDW_HR_RQN_VCNCY_FKV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 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
Columns
Name |
VACANCY_PK |
VACANCY_ID |