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 84: okl_strm_type_v sty,

80: /*
81: UNION
82: SELECT sum(aps.amount_due_original) interest_billed_amount
83: FROM okl_cnsld_ar_strms_b lsm,
84: okl_strm_type_v sty,
85: okl_strm_elements sel,
86: ar_payment_schedules_all aps,
87: okl_k_headers_full_v khr
88: WHERE lsm.khr_id = cp_khr_id

Line 194: FROM okl_strm_type_v sty,

190: group by RECEIVABLES_INVOICE_ID
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

Line 214: --okl_strm_type_v sty,

210: --FROM ar_receivable_applications_all app,
211: --ar_cash_receipts_all cra,
212: --ar_payment_schedules_all sch,
213: --okl_bpd_tld_ar_lines_v tld,
214: --okl_strm_type_v sty,
215: --okl_k_headers_full_v khr
216: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
217: --AND app.status = 'APP'
218: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 229: --FROM okl_strm_type_v sty,

225: --AND sty.stream_type_purpose IN ('INTEREST_PAYMENT', 'VARIABLE_INTEREST','INTEREST_CATCHUP')
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

Line 348: okl_strm_type_v sty

344: p_due_date DATE) IS
345: SELECT NVL(SUM(amount),0)
346: FROM okl_strm_elements sel,
347: okl_streams str,
348: okl_strm_type_v sty
349: WHERE sel.stm_id = str.id
350: AND str.khr_id = cp_khr_id
351: AND str.say_code = 'CURR'
352: AND str.active_yn = 'Y'

Line 581: ,okl_strm_type_v sty

577: SELECT MAX(sel.stream_element_date)
578: FROM
579: okl_strm_elements sel
580: ,okl_streams str
581: ,okl_strm_type_v sty
582: WHERE sel.stm_id = str.id
583: AND str.khr_id = p_contract_id
584: AND str.kle_id = p_line_id
585: AND str.say_code = 'CURR'

Line 597: ,okl_strm_type_v sty

593: SELECT MAX(sel.stream_element_date)
594: FROM
595: okl_strm_elements sel
596: ,okl_streams str
597: ,okl_strm_type_v sty
598: WHERE sel.stm_id = str.id
599: AND str.khr_id = p_contract_id
600: AND str.say_code = 'CURR'
601: AND str.active_yn = 'Y'

Line 825: FROM okl_strm_type_v sty,

821: group by RECEIVABLES_INVOICE_ID
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

Line 848: --okl_strm_type_v sty,

844: --FROM ar_receivable_applications_all app,
845: --ar_cash_receipts_all cra,
846: --ar_payment_schedules_all sch,
847: --okl_bpd_tld_ar_lines_v tld,
848: --okl_strm_type_v sty,
849: --okl_k_headers_full_v khr
850: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
851: --AND app.cash_receipt_id = cra.cash_receipt_id
852: --AND app.status = 'APP'

Line 863: --FROM okl_strm_type_v sty,

859: --AND tld.sty_id = sty.id
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

Line 1591: --okl_strm_type_v sty,

1587: --SELECT NVL(SUM(app.amount_applied),0) loan_paid_amount
1588: --FROM ar_receivable_applications_all app,
1589: --ar_payment_schedules_all sch,
1590: --okl_bpd_tld_ar_lines_v tld,
1591: --okl_strm_type_v sty,
1592: --okl_k_headers_full_v khr
1593: --WHERE TRUNC(app.apply_date) <= cp_effective_date
1594: --AND app.status = 'APP'
1595: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1675: okl_strm_type_v sty,

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
1679: AND stm.sty_id = sty.id

Line 1834: okl_strm_type_v styp,

1830: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1831: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1832: FROM okc_rules_b sll,
1833: okc_rules_b slh,
1834: okl_strm_type_v styp,
1835: okc_rule_groups_b rgp
1836: WHERE TO_NUMBER(sll.object2_id1) = slh.id
1837: AND sll.rule_information_category = 'LASLL'
1838: AND sll.dnz_chr_id = rgp.dnz_chr_id

Line 1860: okl_strm_type_v sty,

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
1864: AND stm.sty_id = sty.id