DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_RECEIPT_APPLICATIONS_UV

Line 305: okl_receipt_applications_uv app,

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
309: AND ar.pay_from_customer = p_customer_id

Line 317: okl_receipt_applications_uv app

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
321: AND customer_trx_id in

Line 333: okl_receipt_applications_uv app

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
337: AND exists