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_V

Line 1139: FROM okl_strm_type_v sty_int_pmt

1135:
1136: Cursor stream_element_interest_csr (p_line_id NUMBER,
1137: p_stream_element_date DATE) IS
1138: SELECT nvl(sel_int_pmt.amount, 0) interest
1139: FROM okl_strm_type_v sty_int_pmt
1140: ,okl_streams_v stm_int_pmt
1141: ,okl_strm_elements_v sel_int_pmt
1142: WHERE stm_int_pmt.kle_id = p_line_id
1143: AND stm_int_pmt.id = sel_int_pmt.stm_id

Line 1153: FROM okl_strm_type_v sty_prin_pmt

1149:
1150: Cursor stream_element_principal_csr (p_line_id NUMBER,
1151: p_stream_element_date DATE) IS
1152: SELECT nvl(sel_prin_pmt.amount, 0) principal
1153: FROM okl_strm_type_v sty_prin_pmt
1154: ,okl_streams_v stm_prin_pmt
1155: ,okl_strm_elements_v sel_prin_pmt
1156: WHERE stm_prin_pmt.kle_id = p_line_id
1157: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 1225: FROM okl_strm_type_v sty_int_pmt

1221:
1222: Cursor strm_elem_int_line_csr (p_line_id NUMBER,
1223: p_stream_element_date DATE) IS
1224: SELECT nvl(sel_int_pmt.amount, 0) interest
1225: FROM okl_strm_type_v sty_int_pmt
1226: ,okl_streams_v stm_int_pmt
1227: ,okl_strm_elements_v sel_int_pmt
1228: WHERE stm_int_pmt.kle_id = p_line_id
1229: AND stm_int_pmt.id = sel_int_pmt.stm_id

Line 1239: FROM okl_strm_type_v sty_prin_pmt

1235:
1236: Cursor strm_elem_prin_line_csr (p_line_id NUMBER,
1237: p_stream_element_date DATE) IS
1238: SELECT nvl(sel_prin_pmt.amount, 0) principal
1239: FROM okl_strm_type_v sty_prin_pmt
1240: ,okl_streams_v stm_prin_pmt
1241: ,okl_strm_elements_v sel_prin_pmt
1242: WHERE stm_prin_pmt.kle_id = p_line_id
1243: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 1253: FROM okl_strm_type_v sty_int_pmt

1249:
1250: Cursor strm_elem_int_hdr_csr (p_khr_id NUMBER,
1251: p_stream_element_date DATE) IS
1252: SELECT nvl(sel_int_pmt.amount, 0) interest
1253: FROM okl_strm_type_v sty_int_pmt
1254: ,okl_streams_v stm_int_pmt
1255: ,okl_strm_elements_v sel_int_pmt
1256: WHERE stm_int_pmt.khr_id = p_khr_id
1257: AND stm_int_pmt.id = sel_int_pmt.stm_id

Line 1267: FROM okl_strm_type_v sty_prin_pmt

1263:
1264: Cursor strm_elem_prin_hdr_csr ( p_khr_id NUMBER,
1265: p_stream_element_date DATE) IS
1266: SELECT nvl(sel_prin_pmt.amount, 0) principal
1267: FROM okl_strm_type_v sty_prin_pmt
1268: ,okl_streams_v stm_prin_pmt
1269: ,okl_strm_elements_v sel_prin_pmt
1270: WHERE stm_prin_pmt.khr_id = p_khr_id
1271: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 1503: ,okl_strm_type_v sty

1499: sel.amount amount
1500: FROM
1501: okl_strm_elements sel
1502: ,okl_streams str
1503: ,okl_strm_type_v sty
1504: WHERE sel.stm_id = str.id
1505: AND str.khr_id = p_contract_id
1506: AND str.kle_id = p_line_id
1507: AND str.say_code = 'CURR'

Line 1528: ,okl_strm_type_v sty

1524: SUM(amount) amount
1525: FROM
1526: okl_strm_elements sel
1527: ,okl_streams str
1528: ,okl_strm_type_v sty
1529: ,okc_k_lines_b cle
1530: ,okc_statuses_b sts
1531: WHERE sel.stm_id = str.id
1532: AND str.khr_id = p_contract_id

Line 1558: ,okl_strm_type_v sty

1554: sel.amount amount
1555: FROM
1556: okl_strm_elements sel
1557: ,okl_streams str
1558: ,okl_strm_type_v sty
1559: WHERE sel.stm_id = str.id
1560: AND str.khr_id = p_contract_id
1561: AND str.kle_id = p_line_id
1562: AND str.say_code = 'CURR'

Line 1580: ,okl_strm_type_v sty

1576: SUM(amount) amount
1577: FROM
1578: okl_strm_elements sel
1579: ,okl_streams str
1580: ,okl_strm_type_v sty
1581: ,okc_k_lines_b cle
1582: ,okc_statuses_b sts
1583: WHERE sel.stm_id = str.id
1584: AND str.khr_id = p_contract_id

Line 1692: ,okl_strm_type_v sty

1688: sum(sel.amount) principal_pmt_rcpt_amt
1689: FROM
1690: okl_strm_elements sel
1691: ,okl_streams str
1692: ,okl_strm_type_v sty
1693: WHERE sel.stm_id = str.id
1694: AND str.khr_id = p_contract_id
1695: AND str.kle_id = NVL(p_line_id, str.kle_id)
1696: AND str.say_code = 'CURR'

Line 1810: ,okl_strm_type_v sty

1806: sum(sel.amount) principal_pmt_rcpt_amt
1807: FROM
1808: okl_strm_elements sel
1809: ,okl_streams str
1810: ,okl_strm_type_v sty
1811: WHERE sel.stm_id = str.id
1812: AND str.khr_id = p_contract_id
1813: AND str.kle_id = NVL(p_line_id, str.kle_id)
1814: AND str.say_code = 'CURR'

Line 2289: ,okl_strm_type_v sty

2285: 'R' txn_type
2286: FROM
2287: okl_strm_elements sel
2288: ,okl_streams str
2289: ,okl_strm_type_v sty
2290: WHERE sel.stm_id = str.id
2291: AND str.khr_id = p_contract_id
2292: AND str.say_code = 'CURR'
2293: AND str.active_yn = 'Y'

Line 2334: okl_strm_type_v sty

2330: FROM okl_bpd_tld_ar_lines_v tld,
2331: ar_payment_schedules_all aps,
2332: ar_receivable_applications_all raa,
2333: ar_cash_receipts_all cra,
2334: okl_strm_type_v sty
2335: WHERE tld.trx_status_code = 'PROCESSED'
2336: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
2337: AND tld.customer_trx_id = aps.customer_trx_id
2338: AND raa.applied_customer_trx_id = aps.customer_trx_id

Line 2356: okl_strm_type_v sty

2352: FROM okl_bpd_tld_ar_lines_v tld,
2353: ar_payment_schedules_all aps,
2354: ar_receivable_applications_all raa,
2355: ra_customer_trx_all cm,
2356: okl_strm_type_v sty
2357: WHERE tld.trx_status_code = 'PROCESSED'
2358: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
2359: AND tld.customer_trx_id = aps.customer_trx_id
2360: AND raa.applied_customer_trx_id = aps.customer_trx_id

Line 2377: okl_strm_type_v sty

2373: 'R' txn_type
2374: FROM okl_bpd_tld_ar_lines_v tld,
2375: ar_payment_schedules_all aps,
2376: ar_adjustments_all adj,
2377: okl_strm_type_v sty
2378: WHERE tld.trx_status_code = 'PROCESSED'
2379: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
2380: AND tld.customer_trx_id = aps.customer_trx_id
2381: AND adj.customer_trx_id = aps.customer_trx_id