Skip to content
[Home] [Help]
View: EDWBV_HR_RACT_ACT_TYPE_LCV
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ HRL.LOOKUP_CODE || '-' || INST.INSTANCE_CODE ACTIVITY_TYPE_PK
, 'ALL' ALL_FK
, HRL.LOOKUP_CODE ACTIVITY_TYPE_CODE
, HRL.MEANING || '(' || INST.INSTANCE_CODE || ')' NAME
, HRL.MEANING || '(' || INST.INSTANCE_CODE || ')' ACTIVITY_TYPE_DP
, INST.INSTANCE_CODE INSTANCE
, 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
WHERE HRL.LOOKUP_TYPE = 'REC_TYPE'
Columns
| Name |
| ACTIVITY_TYPE_PK |
| ALL_FK |
| ACTIVITY_TYPE_CODE |
| NAME |
| ACTIVITY_TYPE_DP |
| INSTANCE |
| LAST_UPDATE_DATE |
| CREATION_DATE |
APPS.EDWBV_HR_RACT_ACT_TYPE_LCV