VIEW: APPS.EDWBV_HR_RSON_REASONS_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvrn.odf 120.0 2005/05/29 06:44:32 appldev noship $ */ hrl.lookup_type || '-' || hrl.lookup_code || '-' || inst.instance_code reason_pk ,'ALL' all_fk ,inst.instance_code instance ,hrl.meaning name ,hrl.meaning reason_dp ,hrl.lookup_type lookup_type ,hrl.lookup_code lookup_code ,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 ,(select evt.reason_type from hri_edw_event_hrchys evt WHERE not exists (select 1 from hri_edw_event_hrchys dummy where dummy.rowid > evt.rowid and evt.reason_type = dummy.reason_type)) types WHERE hrl.lookup_type = types.reason_type

View Text - HTML Formatted

SELECT /* $HEADER: HRISVRN.ODF 120.0 2005/05/29 06:44:32 APPLDEV NOSHIP $ */ HRL.LOOKUP_TYPE || '-' || HRL.LOOKUP_CODE || '-' || INST.INSTANCE_CODE REASON_PK
, 'ALL' ALL_FK
, INST.INSTANCE_CODE INSTANCE
, HRL.MEANING NAME
, HRL.MEANING REASON_DP
, HRL.LOOKUP_TYPE LOOKUP_TYPE
, HRL.LOOKUP_CODE LOOKUP_CODE
, 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
, (SELECT EVT.REASON_TYPE
FROM HRI_EDW_EVENT_HRCHYS EVT
WHERE NOT EXISTS (SELECT 1
FROM HRI_EDW_EVENT_HRCHYS DUMMY
WHERE DUMMY.ROWID > EVT.ROWID
AND EVT.REASON_TYPE = DUMMY.REASON_TYPE)) TYPES
WHERE HRL.LOOKUP_TYPE = TYPES.REASON_TYPE