VIEW: APPS.EDWBV_HR_MVMT_RCTMNT_1_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvmv.odf 120.0 2005/05/29 06:43:50 appldev noship $ */ rc2.rec_type_lvl2_pk || '-' || rct.event_code || '-' || inst.instance_code rec_type_lvl1_pk ,rc2.rec_type_lvl2_pk rec_type_lvl2_fk ,inst.instance_code instance ,hrl.meaning name ,hrl.meaning rec_type_lvl1_dp ,rct.event_code lookup_code ,rct.event_id rec_type_lvl1_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')), rc2.last_update_date) last_update_date ,rct.creation_date creation_date FROM hri_edw_event_hrchys rct ,edw_hr_mvmt_rctmnt_2_lcv rc2 ,hr_lookups hrl ,edw_local_instance inst WHERE rct.hierarchy = 'Recruitment' AND rct.level_number = 1 AND rct.parent_event_id = rc2.rec_type_lvl2_id AND hrl.lookup_type = 'HRI_RECRUITMENT_STAGES' AND hrl.lookup_code = rct.event_code WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HRISVMV.ODF 120.0 2005/05/29 06:43:50 APPLDEV NOSHIP $ */ RC2.REC_TYPE_LVL2_PK || '-' || RCT.EVENT_CODE || '-' || INST.INSTANCE_CODE REC_TYPE_LVL1_PK
, RC2.REC_TYPE_LVL2_PK REC_TYPE_LVL2_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING REC_TYPE_LVL1_DP
, RCT.EVENT_CODE LOOKUP_CODE
, RCT.EVENT_ID REC_TYPE_LVL1_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'))
, RC2.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, RCT.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS RCT
, EDW_HR_MVMT_RCTMNT_2_LCV RC2
, HR_LOOKUPS HRL
, EDW_LOCAL_INSTANCE INST
WHERE RCT.HIERARCHY = 'RECRUITMENT'
AND RCT.LEVEL_NUMBER = 1
AND RCT.PARENT_EVENT_ID = RC2.REC_TYPE_LVL2_ID
AND HRL.LOOKUP_TYPE = 'HRI_RECRUITMENT_STAGES'
AND HRL.LOOKUP_CODE = RCT.EVENT_CODE WITH READ ONLY