VIEW: APPS.IEX_CASE_INVOICES_OPEN_V

Source

View Text - Preformatted

SELECT del.delinquency_id, cas.cas_id, cas.object_id, okll.khr_id, okll.id, full.contract_number, okll.line_Type, okll.amount From IEX_DELINQUENCIES del, IEX_CASE_OBJECTS cas , OKL_CNSLD_AR_LINES_V okll, okl_cnsld_ar_hdrs_v okl, okl_k_headers_full_v full WHERE del.case_id = cas.cas_id and cas.object_code = 'CONTRACTS' and okl.id = cas.object_id and okl.id = okll.khr_id and full.khr_id = cas.object_id and not exists (select 'X' from iex_writeoff_invoices wo where wo.lease_inv_line_id = okll.id And wo.active_YN = 'Y')

View Text - HTML Formatted

SELECT DEL.DELINQUENCY_ID
, CAS.CAS_ID
, CAS.OBJECT_ID
, OKLL.KHR_ID
, OKLL.ID
, FULL.CONTRACT_NUMBER
, OKLL.LINE_TYPE
, OKLL.AMOUNT
FROM IEX_DELINQUENCIES DEL
, IEX_CASE_OBJECTS CAS
, OKL_CNSLD_AR_LINES_V OKLL
, OKL_CNSLD_AR_HDRS_V OKL
, OKL_K_HEADERS_FULL_V FULL
WHERE DEL.CASE_ID = CAS.CAS_ID
AND CAS.OBJECT_CODE = 'CONTRACTS'
AND OKL.ID = CAS.OBJECT_ID
AND OKL.ID = OKLL.KHR_ID
AND FULL.KHR_ID = CAS.OBJECT_ID
AND NOT EXISTS (SELECT 'X'
FROM IEX_WRITEOFF_INVOICES WO
WHERE WO.LEASE_INV_LINE_ID = OKLL.ID
AND WO.ACTIVE_YN = 'Y')