VIEW: APPS.EDWBV_HR_MVMT_LOSS_1_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvmv.odf 120.0 2005/05/29 06:43:50 appldev noship $ */ ls2.loss_type_lvl2_pk || '-' || NVL(lss.event_code,usr.event_code) || '-' || inst.instance_code loss_type_lvl1_pk ,ls2.loss_type_lvl2_pk loss_type_lvl2_fk ,inst.instance_code instance ,hrl.meaning name ,hrl.meaning loss_type_lvl1_dp ,NVL(lss.event_code,usr.event_code) lookup_code ,lss.event_id loss_type_lvl1_id ,GREATEST (NVL(lss.last_update_date, to_date('01-01-2000','DD-MM-YYYY')), NVL(hrl.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))) last_update_date ,lss.creation_date creation_date FROM hri_edw_event_hrchys lss ,hri_edw_user_events usr ,hr_lookups hrl ,edw_hr_mvmt_loss_2_lcv ls2 ,edw_local_instance inst WHERE lss.hierarchy = 'Loss' AND lss.level_number = 1 AND lss.user_event_type = usr.user_event_type (+) AND lss.parent_event_id = ls2.loss_type_lvl2_id AND hrl.lookup_type = NVL(lss.user_event_type,'HRI_LOSS_TYPES') AND hrl.lookup_code = NVL(lss.event_code,usr.event_code) WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HRISVMV.ODF 120.0 2005/05/29 06:43:50 APPLDEV NOSHIP $ */ LS2.LOSS_TYPE_LVL2_PK || '-' || NVL(LSS.EVENT_CODE
, USR.EVENT_CODE) || '-' || INST.INSTANCE_CODE LOSS_TYPE_LVL1_PK
, LS2.LOSS_TYPE_LVL2_PK LOSS_TYPE_LVL2_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING LOSS_TYPE_LVL1_DP
, NVL(LSS.EVENT_CODE
, USR.EVENT_CODE) LOOKUP_CODE
, LSS.EVENT_ID LOSS_TYPE_LVL1_ID
, GREATEST (NVL(LSS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(HRL.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, LSS.CREATION_DATE CREATION_DATE
FROM HRI_EDW_EVENT_HRCHYS LSS
, HRI_EDW_USER_EVENTS USR
, HR_LOOKUPS HRL
, EDW_HR_MVMT_LOSS_2_LCV LS2
, EDW_LOCAL_INSTANCE INST
WHERE LSS.HIERARCHY = 'LOSS'
AND LSS.LEVEL_NUMBER = 1
AND LSS.USER_EVENT_TYPE = USR.USER_EVENT_TYPE (+)
AND LSS.PARENT_EVENT_ID = LS2.LOSS_TYPE_LVL2_ID
AND HRL.LOOKUP_TYPE = NVL(LSS.USER_EVENT_TYPE
, 'HRI_LOSS_TYPES')
AND HRL.LOOKUP_CODE = NVL(LSS.EVENT_CODE
, USR.EVENT_CODE) WITH READ ONLY