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_CASH_APPL_RULES dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 235: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

231: ,lpt.currency_code
232: ,lpt.receivables_invoice_number
233: ,lpt.stream_id
234: ,lpt.trx_date
235: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
236: WHERE lpt.consolidated_invoice_number = cp_cons_bill_num
237: AND NVL (lpt.contract_number, 999) = NVL (DECODE (cp_contract_num, NULL, lpt.contract_number, cp_contract_num), 999)
238: AND lpt.customer_number = NVL (cp_customer_num, lpt.customer_number)
239: AND lpt.stream_type_id = NVL (cp_stream_type_id, lpt.stream_type_id)

Line 259: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

255: ,lpt.currency_code
256: ,lpt.receivables_invoice_number
257: ,lpt.stream_id
258: ,lpt.trx_date
259: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
260: WHERE lpt.consolidated_invoice_number = NVL (cp_cons_bill_num, lpt.consolidated_invoice_number)
261: AND lpt.contract_number = cp_contract_num
262: AND lpt.customer_number = NVL (cp_customer_num, lpt.customer_number)
263: AND lpt.stream_type_id = NVL (cp_stream_type_id, lpt.stream_type_id)

Line 275: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

271: CURSOR c_inv_date ( cp_cons_bill_num IN VARCHAR2
272: ,cp_customer_num IN VARCHAR2) IS
273: SELECT DISTINCT(lpt.contract_number)
274: ,lpt.start_date, lpt.contract_id
275: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
276: WHERE lpt.consolidated_invoice_number = cp_cons_bill_num -- for performance issue #5484903
277: --NVL (cp_cons_bill_num, lpt.consolidated_invoice_number)
278: AND lpt.customer_number = NVL (cp_customer_num, lpt.customer_number);
279:

Line 338: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

334: ORDER BY CN.start_date; -- fixed for performance bug#5484903 - varangan- 19-9-06
335:
336: /* commented for bug#5484903 - varangan-19-9-06
337: SELECT distinct (lpt.contract_id), lpt.contract_number, lpt.start_date
338: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
339: WHERE lpt.consolidated_invoice_number = cp_cons_bill_num
340: AND lpt.status = 'OP'
341: AND lpt.amount_due_remaining > 0*/
342:

Line 363: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

359: ORDER BY CN.start_date; -- fixed for performance bug#5484903 - varangan- 19-9-06
360:
361: /* commented for bug#5484903 - varangan-19-9-06
362: SELECT lpt.contract_id
363: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
364: WHERE lpt.contract_number = cp_contract_num
365: AND lpt.status = 'OP'
366: AND lpt.amount_due_remaining > 0
367: ORDER BY lpt.start_date; */