VIEW: APPS.EDWBV_HR_MVMT_SPRTN_2_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvmv.odf 120.0 2005/05/29 06:43:50 appldev noship $ */ sp3.sep_type_lvl3_pk || '-' || spn.event_code || '-' || inst.instance_code sep_type_lvl2_pk ,sp3.sep_type_lvl3_pk sep_type_lvl3_fk ,inst.instance_code instance ,hrl.meaning name ,hrl.meaning sep_type_lvl2_dp ,spn.event_code lookup_code ,spn.event_id sep_type_lvl2_id ,GREATEST (NVL(spn.last_update_date, to_date('01-01-2000','DD-MM-YYYY')), NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY')), sp3.last_update_date) last_update_date ,spn.creation_date creation_date FROM hri_edw_event_hrchys spn ,edw_hr_mvmt_sprtn_3_lcv sp3 ,hr_lookups hrl ,edw_local_instance inst WHERE spn.hierarchy = 'Separations' AND spn.level_number = 2 AND spn.parent_event_id = sp3.sep_type_lvl3_id AND hrl.lookup_type = 'HRI_SEPARATION_STAGES' AND hrl.lookup_code = spn.event_code WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HRISVMV.ODF 120.0 2005/05/29 06:43:50 APPLDEV NOSHIP $ */ SP3.SEP_TYPE_LVL3_PK || '-' || SPN.EVENT_CODE || '-' || INST.INSTANCE_CODE SEP_TYPE_LVL2_PK
, SP3.SEP_TYPE_LVL3_PK SEP_TYPE_LVL3_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING SEP_TYPE_LVL2_DP
, SPN.EVENT_CODE LOOKUP_CODE
, SPN.EVENT_ID SEP_TYPE_LVL2_ID
, GREATEST (NVL(SPN.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(HRL.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, SP3.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, SPN.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS SPN
, EDW_HR_MVMT_SPRTN_3_LCV SP3
, HR_LOOKUPS HRL
, EDW_LOCAL_INSTANCE INST
WHERE SPN.HIERARCHY = 'SEPARATIONS'
AND SPN.LEVEL_NUMBER = 2
AND SPN.PARENT_EVENT_ID = SP3.SEP_TYPE_LVL3_ID
AND HRL.LOOKUP_TYPE = 'HRI_SEPARATION_STAGES'
AND HRL.LOOKUP_CODE = SPN.EVENT_CODE WITH READ ONLY