VIEW: APPS.EDWBV_HR_MVMT_MVMNTS_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvmv.odf 120.0 2005/05/29 06:43:50 appldev noship $ */ 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

View Text - HTML Formatted

SELECT /* $HEADER: HRISVMV.ODF 120.0 2005/05/29 06:43:50 APPLDEV NOSHIP $ */ 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