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_VARIABLE_INT_UTIL_PVT dependencies on OKL_STREAMS_V

Line 195: okl_streams_v stm,

191: having NVL(SUM(AMOUNT),0) < NVL(SUM(AMOUNT_LINE_ITEMS_REMAINING),0)
192: UNION ALL
193: SELECT NVL(SUM(sel.amount),0) interest_paid_amount
194: FROM okl_strm_type_v sty,
195: okl_streams_v stm,
196: okl_strm_elements sel,
197: okc_k_headers_b khr
198: WHERE stm.khr_id = cp_khr_id
199: AND stm.kle_id = NVL(null, stm.kle_id)

Line 230: --okl_streams_v stm,

226: --UNION
227: ----fix for bug # 4746404
228: --SELECT NVL(SUM(sel.amount),0) interest_paid_amount
229: --FROM okl_strm_type_v sty,
230: --okl_streams_v stm,
231: --okl_strm_elements sel,
232: --okc_k_headers_b khr
233: --WHERE stm.khr_id = cp_khr_id
234: --AND stm.khr_id = khr.id

Line 826: okl_streams_v stm,

822: having SUM(AMOUNT_LINE_ITEMS_REMAINING)< SUM(AMOUNT)
823: UNION ALL
824: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
825: FROM okl_strm_type_v sty,
826: okl_streams_v stm,
827: okl_strm_elements sel,
828: okc_k_headers_b khr
829: WHERE stm.khr_id = cp_khr_id
830: AND stm.kle_id = NVL(null, stm.kle_id)

Line 864: --okl_streams_v stm,

860: --AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT', 'PRINCIPAL_CATCHUP')
861: --UNION
862: --SELECT NVL(SUM(sel.amount),0) principal_paid_amount
863: --FROM okl_strm_type_v sty,
864: --okl_streams_v stm,
865: --okl_strm_elements sel,
866: --okc_k_headers_b khr
867: --WHERE stm.khr_id = cp_khr_id
868: --AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)

Line 1674: FROM okl_streams_v stm,

1670: l_excess_loan_payment NUMBER;
1671:
1672: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1673: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1674: FROM okl_streams_v stm,
1675: okl_strm_type_v sty,
1676: okl_strm_elements_v sel
1677: WHERE stm.khr_id = cp_khr_id
1678: AND stm.id = sel.stm_id

Line 1859: FROM okl_streams_v stm,

1855: AND khr.id = cp_khr_id;
1856:
1857: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1858: SELECT max(sel.stream_element_date)
1859: FROM okl_streams_v stm,
1860: okl_strm_type_v sty,
1861: okl_strm_elements_v sel
1862: WHERE stm.khr_id = cp_khr_id
1863: AND stm.id = sel.stm_id