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

Line 7552: FROM okl_bpd_leasing_payment_trx_v

7548: -- Cursor for outstanding amount
7549: -- Bug 5897792
7550: /*CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
7551: SELECT NVL(SUM(amount_due_remaining), 0)
7552: FROM okl_bpd_leasing_payment_trx_v
7553: WHERE contract_id = p_chr_id;*/
7554:
7555: CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
7556: SELECT NVL(SUM(amount_due_remaining), 0)

Line 8127: FROM okl_bpd_leasing_payment_trx_v

8123: ,p_kle_id IN NUMBER
8124: ,p_sty_id IN NUMBER)
8125: IS
8126: SELECT NVL(SUM(amount_due_original - amount_due_remaining),0) total_amount
8127: FROM okl_bpd_leasing_payment_trx_v
8128: WHERE contract_id = p_dnz_chr_id
8129: AND contract_line_id = p_kle_id
8130: AND stream_type_id = p_sty_id
8131: AND amount_due_original <> amount_due_remaining;