[Home] [Help]
View: EDWBV_HR_MVMT_SPRTN_3_LCV
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ SPN.EVENT_CODE || '-' || INST.INSTANCE_CODE SEP_TYPE_LVL3_PK
, 'ALL' ALL_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING SEP_TYPE_LVL3_DP
, SPN.EVENT_CODE LOOKUP_CODE
, SPN.EVENT_ID SEP_TYPE_LVL3_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'))) LAST_UPDATE_DATE
, SPN.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS SPN
, HR_LOOKUPS HRL
, EDW_LOCAL_INSTANCE INST
WHERE SPN.HIERARCHY = 'SEPARATIONS'
AND SPN.LEVEL_NUMBER = 3
AND HRL.LOOKUP_TYPE = 'HRI_SEPARATION_STAGES'
AND HRL.LOOKUP_CODE = SPN.EVENT_CODE WITH READ ONLY
Columns
Name |
SEP_TYPE_LVL3_PK |
ALL_FK |
INSTANCE |
NAME |
SEP_TYPE_LVL3_DP |
LOOKUP_CODE |
SEP_TYPE_LVL3_ID |
LAST_UPDATE_DATE |
CREATION_DATE |