Product: | HRI - Human Resources Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.EDWBV_HR_RACT_ACTIVITY_LCV |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ NVL(TYP.ACTIVITY_TYPE_PK
, 'NA_EDW') || '-' || RCA.RECRUITMENT_ACTIVITY_ID || '-' || INST.INSTANCE_CODE REC_ACTIVITY_PK
, NVL(TYP.ACTIVITY_TYPE_PK
, 'NA_EDW') ACTIVITY_TYPE_FK
, RCA.NAME || '(' || BGR.NAME || '-' || INST.INSTANCE_CODE || ')' NAME
, RCA.NAME || '(' || BGR.NAME || '-' || INST.INSTANCE_CODE || ')' REC_ACTIVITY_DP
, RCA.EXTERNAL_CONTACT EXTERNAL_CONTACT
, INST.INSTANCE_CODE INSTANCE
, RCA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RCA.RECRUITMENT_ACTIVITY_ID REC_ACTIVITY_ID
, RCA.ACTUAL_COST ACTIVITY_COST
, RCA.PLANNED_COST ACTIVITY_PLANNED_COST
, RCA.DATE_START START_DATE
, RCA.DATE_END END_DATE
, RCA.DATE_CLOSING CLOSING_DATE
, '_DF:PER:PER_RECRUITMENT_ACTIVITIES:RCA'
, NVL(RCA.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
, RCA.CREATION_DATE CREATION_DATE
FROM PER_RECRUITMENT_ACTIVITIES RCA
, EDW_HR_RACT_ACT_TYPE_LCV TYP
, HR_ALL_ORGANIZATION_UNITS BGR
, EDW_LOCAL_INSTANCE INST
WHERE BGR.ORGANIZATION_ID = RCA.BUSINESS_GROUP_ID
AND RCA.TYPE = TYP.ACTIVITY_TYPE_CODE (+)