View: EDW_HR_REC_ACT_FKV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.EDW_HR_REC_ACT_FKV

View Text

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 RECRUITMENT_ACTIVITY_PK
, RCA.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
FROM PER_RECRUITMENT_ACTIVITIES RCA
, EDW_HR_RACT_ACT_TYPE_LCV TYP
, EDW_LOCAL_INSTANCE INST
WHERE RCA.TYPE = TYP.ACTIVITY_TYPE_CODE (+)

Columns