[Home] [Help]
View: EDWBV_HR_RSON_REASONS_LCV
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ HRL.LOOKUP_TYPE || '-' || HRL.LOOKUP_CODE || '-' || INST.INSTANCE_CODE REASON_PK
, 'ALL' ALL_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING REASON_DP
, HRL.LOOKUP_TYPE LOOKUP_TYPE
, HRL.LOOKUP_CODE LOOKUP_CODE
, NVL(HRL.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
, HRL.CREATION_DATE CREATION_DATE
FROM HR_LOOKUPS HRL
, EDW_LOCAL_INSTANCE INST
, (SELECT EVT.REASON_TYPE
FROM HRI_EDW_EVENT_HRCHYS EVT
WHERE NOT EXISTS (SELECT 1
FROM HRI_EDW_EVENT_HRCHYS DUMMY
WHERE DUMMY.ROWID > EVT.ROWID
AND EVT.REASON_TYPE = DUMMY.REASON_TYPE)) TYPES
WHERE HRL.LOOKUP_TYPE = TYPES.REASON_TYPE
Columns
Name |
REASON_PK |
ALL_FK |
INSTANCE |
NAME |
REASON_DP |
LOOKUP_TYPE |
LOOKUP_CODE |
LAST_UPDATE_DATE |
CREATION_DATE |