VIEW: APPS.IEX_CASE_CONTRACTS_OPEN_V

Source

View Text - Preformatted

SELECT del.delinquency_id, cas.cas_id, cas.object_id, okl.contract_number, okl.accepted_date From IEX_DELINQUENCIES del, IEX_CASE_OBJECTS cas, okl_k_headers_full_v okl WHERE del.case_id = cas.cas_id and cas.object_code = 'CONTRACTS' and okl.khr_id = cas.object_id and not exists (select 'X' from iex_writeoff_contracts cont where cont.contract_id = cas.object_id And cont.active_YN = 'Y')

View Text - HTML Formatted

SELECT DEL.DELINQUENCY_ID
, CAS.CAS_ID
, CAS.OBJECT_ID
, OKL.CONTRACT_NUMBER
, OKL.ACCEPTED_DATE
FROM IEX_DELINQUENCIES DEL
, IEX_CASE_OBJECTS CAS
, OKL_K_HEADERS_FULL_V OKL
WHERE DEL.CASE_ID = CAS.CAS_ID
AND CAS.OBJECT_CODE = 'CONTRACTS'
AND OKL.KHR_ID = CAS.OBJECT_ID
AND NOT EXISTS (SELECT 'X'
FROM IEX_WRITEOFF_CONTRACTS CONT
WHERE CONT.CONTRACT_ID = CAS.OBJECT_ID
AND CONT.ACTIVE_YN = 'Y')