eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 290: FROM ar_cash_receipts_all ar,

286: --mutlipying the amount with exchange rate to convert the currency from
287: --Transaction currency to Functional Curreny.
288: --dkagrawa changed the query to adopt new billing architecture
289: /*SELECT (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
290: FROM ar_cash_receipts_all ar,
291: okc_k_headers_b chr,
292: ar_receivable_applications_all ara,
293: okl_cnSld_ar_strms_b lsm
294: WHERE

Line 303: FROM ar_cash_receipts_all ar,

299: AND lsm.khr_id = p_contract_id
300: ORDER BY receipt_date DESC;*/
301:
302: SELECT (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
303: FROM ar_cash_receipts_all ar,
304: okl_receipt_applications_uv app,
305: okc_k_headers_b chr
306: WHERE chr.id = p_contract_id
307: AND ar.cash_receipt_id = app.cash_receipt_id