View: EDWBV_HR_MVMT_MVMNTS_LCV

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

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ GAIN.GAIN_TYPE_LVL1_PK || '-' || LOSS.LOSS_TYPE_LVL1_PK || '-' || REC.REC_TYPE_LVL1_PK || '-' || SEP.SEP_TYPE_LVL1_PK || '-' || INST.INSTANCE_CODE MOVEMENT_PK
, GAIN.GAIN_TYPE_LVL1_PK GAIN_TYPE_LVL1_FK
, LOSS.LOSS_TYPE_LVL1_PK LOSS_TYPE_LVL1_FK
, REC.REC_TYPE_LVL1_PK REC_TYPE_LVL1_FK
, SEP.SEP_TYPE_LVL1_PK SEP_TYPE_LVL1_FK
, INST.INSTANCE_CODE INSTANCE
, CMBN.DESCRIPTION NAME
, CMBN.DESCRIPTION MOVEMENT_DP
, CMBN.COMBINATION_ID MOVEMENT_CMBN_ID
, GREATEST (GAIN.LAST_UPDATE_DATE
, LOSS.LAST_UPDATE_DATE
, REC.LAST_UPDATE_DATE
, SEP.LAST_UPDATE_DATE
, NVL(CMBN.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, CMBN.CREATION_DATE CREATION_DATE
FROM EDW_HR_MVMT_GAIN_1_LCV GAIN
, EDW_HR_MVMT_LOSS_1_LCV LOSS
, EDW_HR_MVMT_RCTMNT_1_LCV REC
, EDW_HR_MVMT_SPRTN_1_LCV SEP
, HRI_EDW_EVENT_HRCHY_CMBNS CMBN
, EDW_LOCAL_INSTANCE INST
WHERE CMBN.GAIN_EVENT_ID = GAIN.GAIN_TYPE_LVL1_ID
AND CMBN.LOSS_EVENT_ID = LOSS.LOSS_TYPE_LVL1_ID
AND CMBN.REC_EVENT_ID = REC.REC_TYPE_LVL1_ID
AND CMBN.SEP_EVENT_ID = SEP.SEP_TYPE_LVL1_ID

Columns