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 304: FROM ar_cash_receipts_all ar,

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

Line 316: FROM ar_cash_receipts_all ar,

312:
313: -- Modified cursor for bug 11810605
314: /*select
315: (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
316: FROM ar_cash_receipts_all ar,
317: okl_receipt_applications_uv app
318: WHERE
319: ar.cash_receipt_id = app.cash_receipt_id
320: AND ar.pay_from_customer = p_customer_id

Line 332: FROM ar_cash_receipts_all ar,

328:
329: -- Added for performance issue 13082893
330: select
331: (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
332: FROM ar_cash_receipts_all ar,
333: okl_receipt_applications_uv app
334: WHERE
335: ar.cash_receipt_id = app.cash_receipt_id
336: AND ar.pay_from_customer = p_customer_id