View: EDWBV_HR_MVMT_GAIN_1_LCV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.EDWBV_HR_MVMT_GAIN_1_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ GN2.GAIN_TYPE_LVL2_PK || '-' || NVL(GNS.EVENT_CODE
, USR.EVENT_CODE) || '-' || INST.INSTANCE_CODE GAIN_TYPE_LVL1_PK
, GN2.GAIN_TYPE_LVL2_PK GAIN_TYPE_LVL2_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING GAIN_TYPE_LVL1_DP
, NVL(GNS.EVENT_CODE
, USR.EVENT_CODE) LOOKUP_CODE
, GNS.EVENT_ID GAIN_TYPE_LVL1_ID
, GREATEST (NVL(GNS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(HRL.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, GN2.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, GNS.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS GNS
, HRI_EDW_USER_EVENTS USR
, HR_LOOKUPS HRL
, EDW_HR_MVMT_GAIN_2_LCV GN2
, EDW_LOCAL_INSTANCE INST
WHERE GNS.HIERARCHY = 'GAIN'
AND GNS.LEVEL_NUMBER = 1
AND GNS.USER_EVENT_TYPE = USR.USER_EVENT_TYPE (+)
AND HRL.LOOKUP_TYPE = NVL(GNS.USER_EVENT_TYPE
, 'HRI_GAIN_TYPES')
AND HRL.LOOKUP_CODE = NVL(GNS.EVENT_CODE
, USR.EVENT_CODE)
AND GNS.PARENT_EVENT_ID = GN2.GAIN_TYPE_LVL2_ID WITH READ ONLY

Columns