View: EDWBV_HR_MVMT_RCTMNT_2_LCV

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

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ RC3.REC_TYPE_LVL3_PK || '-' || RCT.EVENT_CODE || '-' || INST.INSTANCE_CODE REC_TYPE_LVL2_PK
, RC3.REC_TYPE_LVL3_PK REC_TYPE_LVL3_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING REC_TYPE_LVL2_DP
, RCT.EVENT_CODE LOOKUP_CODE
, RCT.EVENT_ID REC_TYPE_LVL2_ID
, GREATEST (NVL(RCT.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(HRL.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, RC3.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, RCT.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS RCT
, EDW_HR_MVMT_RCTMNT_3_LCV RC3
, HR_LOOKUPS HRL
, EDW_LOCAL_INSTANCE INST
WHERE RCT.HIERARCHY = 'RECRUITMENT'
AND RCT.LEVEL_NUMBER = 2
AND RCT.PARENT_EVENT_ID = RC3.REC_TYPE_LVL3_ID
AND HRL.LOOKUP_TYPE = 'HRI_RECRUITMENT_STAGES'
AND HRL.LOOKUP_CODE = RCT.EVENT_CODE WITH READ ONLY

Columns