VIEW: APPS.HRI_OBI_CL_SCAT_SPCATGRY_V

Source

View Text - Preformatted

SELECT hrl.lookup_code , hrl.meaning , hrl.meaning||' ('||hrl.lookup_code||')', nvl(hrl.start_date_active, hr_general.start_of_time) SCAT_START_DATE , nvl(hrl.end_date_active, hr_general.end_of_time) SCAT_END_DATE , hrl.meaning , hrl.enabled_flag, hr_bis.bis_decode_lookup('YES_NO',nvl(hrl.enabled_flag,'N')) FROM hr_lookups hrl WHERE hrl.lookup_type = 'HRI_LOSS_TYPES' AND hrl.lookup_code like 'SEP_%' AND TRUNC(sysdate) BETWEEN nvl(trunc(hrl.start_date_active), hr_general.start_of_time) AND nvl(trunc(hrl.end_date_active), hr_general.end_of_time) UNION ALL SELECT 'NA_EDW', NVL(VALUE,hri_oltp_view_message.get_unassigned_msg), NVL(VALUE,hri_oltp_view_message.get_unassigned_msg)||' ('||ID_CHAR||')', hr_general.start_of_time, hr_general.end_of_time, '', 'Y', hr_bis.bis_decode_lookup('YES_NO','Y') FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT HRL.LOOKUP_CODE
, HRL.MEANING
, HRL.MEANING||' ('||HRL.LOOKUP_CODE||')'
, NVL(HRL.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME) SCAT_START_DATE
, NVL(HRL.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME) SCAT_END_DATE
, HRL.MEANING
, HRL.ENABLED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(HRL.ENABLED_FLAG
, 'N'))
FROM HR_LOOKUPS HRL
WHERE HRL.LOOKUP_TYPE = 'HRI_LOSS_TYPES'
AND HRL.LOOKUP_CODE LIKE 'SEP_%'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(HRL.START_DATE_ACTIVE)
, HR_GENERAL.START_OF_TIME)
AND NVL(TRUNC(HRL.END_DATE_ACTIVE)
, HR_GENERAL.END_OF_TIME) UNION ALL SELECT 'NA_EDW'
, NVL(VALUE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)
, NVL(VALUE
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)||' ('||ID_CHAR||')'
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, ''
, 'Y'
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'Y')
FROM HRI_UNASSIGNED WITH READ ONLY