[Home] [Help]
| Product: | HRI - Human Resources Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
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
, REQ.REQUISITION_PK REQUISITION_FK
, INST.INSTANCE_CODE INSTANCE
, VCS.STATUS VACANCY_STATUS_CODE
, HR_GENERAL.DECODE_LOOKUP('VACANCY_STATUS'
, VCS.STATUS) VACANCY_STATUS
, VCS.NUMBER_OF_OPENINGS NUMBER_OF_OPENINGS
, VCS.BUDGET_MEASUREMENT_TYPE BUDGET_MSRMNT_TYPE_CODE
, HR_GENERAL.DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, VCS.BUDGET_MEASUREMENT_TYPE) BUDGET_MSRMNT_TYPE
, VCS.BUDGET_MEASUREMENT_VALUE BUDGET_MSRMNT_VALUE
, VCS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' NAME
, VCS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' VACANCY_DP
, VCS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, VCS.REQUISITION_ID REQUISITION_ID
, VCS.VACANCY_ID VACANCY_ID
, VCS.DATE_FROM VACANCY_START_DATE
, VCS.DATE_TO VACANCY_END_DATE
, '_DF:PER:PER_VACANCIES:VCS'
, VCS.CREATION_DATE CREATION_DATE
, NVL(VCS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
FROM EDW_LOCAL_INSTANCE INST
, PER_ALL_VACANCIES VCS
, EDW_HR_RQVC_REQUISTN_LCV REQ
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE VCS.REQUISITION_ID = REQ.REQUISITION_ID
AND VCS.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID