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_STRM_TYPE_V

Line 141: FROM okl_strm_type_v sty,

137: AND TRUNC(aps.trx_date)
138: BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
139: UNION ALL
140: SELECT NVL(SUM(sel.amount),0) interest_paid_amount
141: FROM okl_strm_type_v sty,
142: okl_streams_v stm,
143: okl_strm_elements sel,
144: okc_k_headers_b khr
145: WHERE stm.khr_id = cp_khr_id

Line 262: okl_strm_type_v sty

258: p_due_date DATE) IS
259: SELECT NVL(SUM(amount),0)
260: FROM okl_strm_elements sel,
261: okl_streams str,
262: okl_strm_type_v sty
263: WHERE sel.stm_id = str.id
264: AND str.khr_id = cp_khr_id
265: AND str.say_code = 'CURR'
266: AND str.active_yn = 'Y'

Line 495: ,okl_strm_type_v sty

491: SELECT MAX(sel.stream_element_date)
492: FROM
493: okl_strm_elements sel
494: ,okl_streams str
495: ,okl_strm_type_v sty
496: WHERE sel.stm_id = str.id
497: AND str.khr_id = p_contract_id
498: AND str.kle_id = p_line_id
499: AND str.say_code = 'CURR'

Line 511: ,okl_strm_type_v sty

507: SELECT MAX(sel.stream_element_date)
508: FROM
509: okl_strm_elements sel
510: ,okl_streams str
511: ,okl_strm_type_v sty
512: WHERE sel.stm_id = str.id
513: AND str.khr_id = p_contract_id
514: AND str.say_code = 'CURR'
515: AND str.active_yn = 'Y'

Line 727: FROM okl_strm_type_v sty,

723: AND TRUNC(aps.trx_date)
724: BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
725: UNION ALL
726: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
727: FROM okl_strm_type_v sty,
728: okl_streams_v stm,
729: okl_strm_elements sel,
730: okc_k_headers_b khr
731: WHERE stm.khr_id = cp_khr_id

Line 776: FROM okl_strm_type_v sty,

772: group by RECEIVABLES_INVOICE_ID
773: having SUM(AMOUNT_LINE_ITEMS_REMAINING)< SUM(AMOUNT)
774: UNION ALL
775: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
776: FROM okl_strm_type_v sty,
777: okl_streams_v stm,
778: okl_strm_elements sel,
779: okc_k_headers_b khr
780: WHERE stm.khr_id = cp_khr_id

Line 801: --okl_strm_type_v sty,

797: --FROM ar_receivable_applications_all app,
798: --ar_cash_receipts_all cra,
799: --ar_payment_schedules_all sch,
800: --okl_bpd_tld_ar_lines_v tld,
801: --okl_strm_type_v sty,
802: --okl_k_headers_full_v khr
803: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
804: --AND app.cash_receipt_id = cra.cash_receipt_id
805: --AND app.status = 'APP'

Line 816: --FROM okl_strm_type_v sty,

812: --AND tld.sty_id = sty.id
813: --AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT', 'PRINCIPAL_CATCHUP')
814: --UNION
815: --SELECT NVL(SUM(sel.amount),0) principal_paid_amount
816: --FROM okl_strm_type_v sty,
817: --okl_streams_v stm,
818: --okl_strm_elements sel,
819: --okc_k_headers_b khr
820: --WHERE stm.khr_id = cp_khr_id

Line 1544: --okl_strm_type_v sty,

1540: --SELECT NVL(SUM(app.amount_applied),0) loan_paid_amount
1541: --FROM ar_receivable_applications_all app,
1542: --ar_payment_schedules_all sch,
1543: --okl_bpd_tld_ar_lines_v tld,
1544: --okl_strm_type_v sty,
1545: --okl_k_headers_full_v khr
1546: --WHERE TRUNC(app.apply_date) <= cp_effective_date
1547: --AND app.status = 'APP'
1548: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1628: okl_strm_type_v sty,

1624:
1625: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1626: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1627: FROM okl_streams_v stm,
1628: okl_strm_type_v sty,
1629: okl_strm_elements_v sel
1630: WHERE stm.khr_id = cp_khr_id
1631: AND stm.id = sel.stm_id
1632: AND stm.sty_id = sty.id

Line 1787: okl_strm_type_v styp,

1783: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1784: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1785: FROM okc_rules_b sll,
1786: okc_rules_b slh,
1787: okl_strm_type_v styp,
1788: okc_rule_groups_b rgp
1789: WHERE TO_NUMBER(sll.object2_id1) = slh.id
1790: AND sll.rule_information_category = 'LASLL'
1791: AND sll.dnz_chr_id = rgp.dnz_chr_id

Line 1813: okl_strm_type_v sty,

1809:
1810: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1811: SELECT max(sel.stream_element_date)
1812: FROM okl_streams_v stm,
1813: okl_strm_type_v sty,
1814: okl_strm_elements_v sel
1815: WHERE stm.khr_id = cp_khr_id
1816: AND stm.id = sel.stm_id
1817: AND stm.sty_id = sty.id

Line 2233: ,okl_strm_type_v sty

2229: p_line_id NUMBER) IS
2230: SELECT 'Y'
2231: FROM okl_strm_elements sel
2232: ,okl_streams str
2233: ,okl_strm_type_v sty
2234: WHERE sel.stm_id = str.id
2235: AND str.khr_id = p_contract_id
2236: AND str.kle_id = p_line_id
2237: AND str.say_code = 'CURR'

Line 2247: ,okl_strm_type_v sty

2243: p_line_id NUMBER) IS
2244: SELECT 'Y'
2245: FROM okl_strm_elements sel
2246: ,okl_streams str
2247: ,okl_strm_type_v sty
2248: WHERE sel.stm_id = str.id
2249: AND str.khr_id = p_contract_id
2250: AND str.kle_id = p_line_id
2251: AND str.say_code = 'CURR'