VIEW: APPS.IEX_DEL_CASES_NEW_V

Source

View Text - Preformatted

SELECT DISTINCT CAS_ID FROM iex_case_objects WHERE active_flag = 'Y' and delinquency_status in ('PREDELINQUENT', 'DELINQUENT')

View Text - HTML Formatted

SELECT DISTINCT CAS_ID
FROM IEX_CASE_OBJECTS
WHERE ACTIVE_FLAG = 'Y'
AND DELINQUENCY_STATUS IN ('PREDELINQUENT'
, 'DELINQUENT')