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_INTEREST_PVT dependencies on OKL_STRM_TYPE_B

Line 1621: okl_strm_type_b sty,

1617: okl_trx_ar_invoices_b tai,
1618: ar_payment_schedules_all aps,
1619: ar_receivable_applications_all raa,
1620: ar_cash_receipts_all cra,
1621: okl_strm_type_b sty,
1622: ar_distributions_all ad
1623: WHERE tai.trx_status_code = 'PROCESSED'
1624: AND tai.khr_id = p_contract_id
1625: AND tld.khr_id = p_contract_id

Line 1654: okl_strm_type_b sty

1650: okl_trx_ar_invoices_b tai,
1651: ar_payment_schedules_all aps,
1652: ar_receivable_applications_all raa,
1653: ar_cash_receipts_all cra,
1654: okl_strm_type_b sty
1655: WHERE tai.trx_status_code = 'PROCESSED'
1656: AND tai.khr_id = p_contract_id
1657: AND tld.khr_id = p_contract_id
1658: AND tld.kle_id = NVL(p_line_id, tld.kle_id)

Line 1712: okl_strm_type_b sty,

1708: okl_trx_ar_invoices_b tai,
1709: ar_payment_schedules_all aps,
1710: ar_receivable_applications_all raa,
1711: ra_customer_trx_all cm,
1712: okl_strm_type_b sty,
1713: ar_distributions_all ad
1714: WHERE tai.trx_status_code = 'PROCESSED'
1715: AND tai.khr_id = p_contract_id
1716: AND tld.khr_id = p_contract_id

Line 1745: okl_strm_type_b sty

1741: okl_trx_ar_invoices_b tai,
1742: ar_payment_schedules_all aps,
1743: ar_receivable_applications_all raa,
1744: ra_customer_trx_all cm,
1745: okl_strm_type_b sty
1746: WHERE tai.trx_status_code = 'PROCESSED'
1747: AND tai.khr_id = p_contract_id
1748: AND tld.khr_id = p_contract_id
1749: AND tld.kle_id = NVL(p_line_id, tld.kle_id)

Line 1778: okl_strm_type_b sty,

1774: okl_txl_ar_inv_lns_b til,
1775: okl_trx_ar_invoices_b tai,
1776: ar_payment_schedules_all aps,
1777: ar_adjustments_all adj,
1778: okl_strm_type_b sty,
1779: ar_distributions_all ad
1780: WHERE tai.trx_status_code = 'PROCESSED'
1781: AND tai.khr_id = p_contract_id
1782: AND tld.khr_id = p_contract_id

Line 2781: okl_strm_type_b sty

2777:
2778: CURSOR c_int_calc_date_csr(cp_khr_id NUMBER) IS SELECT (max(sel.stream_element_date) - 1) last_interest_calc_date
2779: FROM okl_streams stm,
2780: okl_strm_elements sel,
2781: okl_strm_type_b sty
2782: WHERE stm.khr_id = cp_khr_id
2783: AND stm.id = sel.stm_id
2784: AND stm.sty_id = sty.id
2785: AND (sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL' OR sty.stream_type_purpose = 'DAILY_INTEREST_INTEREST');

Line 2823: okl_strm_type_b styb

2819: FROM okc_k_lines_b cleb,
2820: okc_rule_groups_b rgpb,
2821: okc_rules_b rulb,
2822: okc_rules_b rulb2,
2823: okl_strm_type_b styb
2824: WHERE rgpb.chr_id IS NULL
2825: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
2826: AND rgpb.cle_id = cleb.id
2827: AND cleb.id = p_cle_id

Line 3033: okl_strm_type_b styb,

3029: CURSOR c_pay_freq(cp_khr_id NUMBER) IS
3030: select sll_rulb.object1_id1 pay_freq
3031: from okc_rules_b sll_rulb,
3032: okc_rules_b slh_rulb,
3033: okl_strm_type_b styb,
3034: okc_rule_groups_b rgpb
3035: where sll_rulb.rgp_id = rgpb.id
3036: and sll_rulb.rule_information_category = 'LASLL'
3037: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id

Line 4490: okl_strm_type_b sty,

4486: --prior to date passed
4487: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4488: SELECT 'Y' return_value
4489: FROM okl_streams stm,
4490: okl_strm_type_b sty,
4491: okl_strm_elements sel
4492: WHERE stm.khr_id = cp_khr_id
4493: AND stm.sty_id = sty.id
4494: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'

Line 4508: okl_strm_type_b sty,

4504: --prior to date passed
4505: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4506: SELECT 'Y' return_value
4507: FROM okl_streams stm,
4508: okl_strm_type_b sty,
4509: okl_strm_elements sel
4510: WHERE stm.khr_id = cp_khr_id
4511: AND stm.sty_id = sty.id
4512: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'

Line 4536: ,okl_strm_type_b sty

4532: ,okl_trx_ar_invoices_b tai
4533: ,ar_payment_schedules_all aps
4534: ,ar_receivable_applications_all raa
4535: ,ar_cash_receipts_all cra
4536: ,okl_strm_type_b sty
4537: WHERE tai.trx_status_code = 'PROCESSED'
4538: AND tai.khr_id = cp_khr_id
4539: AND tld.khr_id = cp_khr_id
4540: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 4617: ,okl_strm_type_b sty

4613: ,okl_trx_ar_invoices_b tai
4614: ,ar_payment_schedules_all aps
4615: ,ar_receivable_applications_all raa
4616: ,ra_customer_trx_all cm
4617: ,okl_strm_type_b sty
4618: WHERE tai.trx_status_code = 'PROCESSED'
4619: AND tai.khr_id = cp_khr_id
4620: AND tld.khr_id = cp_khr_id
4621: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 4657: ,okl_strm_type_b sty

4653: ,okl_txl_ar_inv_lns_b til
4654: ,okl_trx_ar_invoices_b tai
4655: ,ar_payment_schedules_all aps
4656: ,ar_adjustments_all adj
4657: ,okl_strm_type_b sty
4658: WHERE tai.trx_status_code = 'PROCESSED'
4659: AND tai.khr_id = cp_khr_id
4660: AND tld.khr_id = cp_khr_id
4661: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 4909: okl_strm_type_b sty,

4905: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4906: SELECT sel.id source_id
4907: , 'OKL_STRM_ELEMENTS_V' source_table
4908: FROM okl_streams stm,
4909: okl_strm_type_b sty,
4910: okl_strm_elements sel
4911: WHERE stm.khr_id = cp_khr_id
4912: AND stm.sty_id = sty.id
4913: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'

Line 4928: okl_strm_type_b sty,

4924: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4925: SELECT sel.id source_id
4926: , 'OKL_STRM_ELEMENTS_V' source_table
4927: FROM okl_streams stm,
4928: okl_strm_type_b sty,
4929: okl_strm_elements sel
4930: WHERE stm.khr_id = cp_khr_id
4931: AND stm.sty_id = sty.id
4932: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'

Line 4958: ,okl_strm_type_b sty

4954: ,okl_trx_ar_invoices_b tai
4955: ,ar_payment_schedules_all aps
4956: ,ar_receivable_applications_all raa
4957: ,ar_cash_receipts_all cra
4958: ,okl_strm_type_b sty
4959: WHERE tai.trx_status_code = 'PROCESSED'
4960: AND tai.khr_id = cp_khr_id
4961: AND tld.khr_id = cp_khr_id
4962: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 5042: ,okl_strm_type_b sty

5038: ,okl_trx_ar_invoices_b tai
5039: ,ar_payment_schedules_all aps
5040: ,ar_receivable_applications_all raa
5041: ,ra_customer_trx_all cm
5042: ,okl_strm_type_b sty
5043: WHERE tai.trx_status_code = 'PROCESSED'
5044: AND tai.khr_id = cp_khr_id
5045: AND tld.khr_id = cp_khr_id
5046: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 5082: ,okl_strm_type_b sty

5078: ,okl_txl_ar_inv_lns_b til
5079: ,okl_trx_ar_invoices_b tai
5080: ,ar_payment_schedules_all aps
5081: ,ar_adjustments_all adj
5082: ,okl_strm_type_b sty
5083: WHERE tai.trx_status_code = 'PROCESSED'
5084: AND tai.khr_id = cp_khr_id
5085: AND tld.khr_id = cp_khr_id
5086: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 6458: okl_strm_type_b sty

6454: SELECT NVL(rul2.rule_information10,'N') arrears_yn
6455: FROM okc_rule_groups_b rgp,
6456: okc_rules_b rul1,
6457: okc_rules_b rul2,
6458: okl_strm_type_b sty
6459: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
6460: AND rul2.rule_information_category = 'LASLL'
6461: AND rul2.rgp_id = rgp.id
6462: AND rgp.cle_id IS NULL