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_LOAN_AMORT_SCHEDULE_PVT dependencies on OKL_STREAMS

Line 254: okl_streams stm,

250: ,sel.amount principal
251: ,0 interest
252: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
253: FROM okl_strm_elements sel,
254: okl_streams stm,
255: okl_strm_type_b sty,
256: okc_k_lines_b cle
257: WHERE stm.khr_id = cp_khr_id
258: AND sty.id = stm.sty_id

Line 273: okl_streams stm,

269: ,0 principal
270: ,sel.amount interest
271: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
272: FROM okl_strm_elements sel,
273: okl_streams stm,
274: okl_strm_type_b sty,
275: okc_k_lines_b cle
276: WHERE stm.khr_id = cp_khr_id
277: AND sty.id = stm.sty_id

Line 302: okl_streams stm,

298: 0 interest,
299: sel.amount princ_pay_down,
300: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
301: FROM okl_strm_elements sel,
302: okl_streams stm,
303: okl_strm_type_b sty,
304: okc_k_lines_b cle
305: WHERE stm.khr_id = cp_khr_id
306: AND sty.id = stm.sty_id

Line 521: okl_streams stm,

517: SELECT sel.stream_element_date bill_date
518: ,sel.amount principal
519: ,0 interest
520: FROM okl_strm_elements sel,
521: okl_streams stm,
522: okl_strm_type_b sty,
523: okc_k_lines_b cle
524: WHERE stm.khr_id = cp_khr_id
525: AND sty.id = stm.sty_id

Line 539: okl_streams stm,

535: SELECT sel.stream_element_date bill_date
536: ,0 principal
537: ,sel.amount interest
538: FROM okl_strm_elements sel,
539: okl_streams stm,
540: okl_strm_type_b sty,
541: okc_k_lines_b cle
542: WHERE stm.khr_id = cp_khr_id
543: AND sty.id = stm.sty_id

Line 562: okl_streams stm,

558: CURSOR c_amort_sch_ppd_csr(cp_khr_id IN NUMBER) IS
559: SELECT sel.stream_element_date bill_date
560: ,sum(sel.amount) ppd_amount
561: FROM okl_strm_elements sel,
562: okl_streams stm,
563: okl_strm_type_b sty,
564: okc_k_lines_b cle
565: WHERE stm.khr_id = cp_khr_id
566: AND sty.id = stm.sty_id

Line 804: okl_streams stm_dii,

800: 0 principal,
801: sel_dii.amount interest,
802: sel_dii.request_id
803: FROM okl_strm_elements sel_dii,
804: okl_streams stm_dii,
805: okl_strm_type_b sty_dii
806: WHERE stm_dii.khr_id = p_chr_id
807: AND sty_dii.id = stm_dii.sty_id
808: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'

Line 818: okl_streams stm_dip,

814: sel_dip.amount principal,
815: 0 interest,
816: sel_dip.request_id
817: FROM okl_strm_elements sel_dip,
818: okl_streams stm_dip,
819: okl_strm_type_b sty_dip
820: WHERE stm_dip.khr_id = p_chr_id
821: AND sty_dip.id = stm_dip.sty_id
822: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'

Line 1026: okl_streams stm_dii,

1022: SELECT sel_dii.stream_element_date receipt_date,
1023: 0 principal,
1024: sel_dii.amount interest
1025: FROM okl_strm_elements sel_dii,
1026: okl_streams stm_dii,
1027: okl_strm_type_b sty_dii
1028: WHERE stm_dii.khr_id = p_chr_id
1029: AND sty_dii.id = stm_dii.sty_id
1030: AND sty_dii.stream_type_purpose = 'DAILY_INTEREST_INTEREST'

Line 1039: okl_streams stm_dip,

1035: SELECT sel_dip.stream_element_date receipt_date,
1036: sel_dip.amount principal,
1037: 0 interest
1038: FROM okl_strm_elements sel_dip,
1039: okl_streams stm_dip,
1040: okl_strm_type_b sty_dip
1041: WHERE stm_dip.khr_id = p_chr_id
1042: AND sty_dip.id = stm_dip.sty_id
1043: AND sty_dip.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'

Line 1367: FROM okl_streams stm,

1363:
1364: --Bug# 14683157: Fetch Last Billed Date only for Asset Principal Payment
1365: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1366: SELECT MAX(sel.stream_element_date)
1367: FROM okl_streams stm,
1368: okl_strm_elements sel,
1369: okl_strm_type_b sty,
1370: okc_k_lines_b cle
1371: WHERE stm.khr_id = p_chr_id

Line 1404: okl_streams stm,

1400: 0 principal,
1401: sel.amount interest,
1402: G_BILLED payment_type
1403: FROM okl_strm_elements sel,
1404: okl_streams stm,
1405: okl_strm_type_b sty,
1406: okc_k_lines_b cle
1407: WHERE stm.khr_id = p_chr_id
1408: AND sty.id = stm.sty_id

Line 1423: okl_streams stm,

1419: sel.amount principal,
1420: 0 interest,
1421: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1422: FROM okl_strm_elements sel,
1423: okl_streams stm,
1424: okl_strm_type_b sty,
1425: okc_k_lines_b cle
1426: WHERE stm.khr_id = p_chr_id
1427: AND sty.id = stm.sty_id

Line 1441: okl_streams stm,

1437: 0 principal,
1438: sel.amount interest,
1439: G_PROJECTED payment_type
1440: FROM okl_strm_elements sel,
1441: okl_streams stm,
1442: okl_strm_type_b sty,
1443: okc_k_lines_b cle
1444: WHERE stm.khr_id = p_chr_id
1445: AND sty.id = stm.sty_id

Line 1471: okl_streams stm,

1467: 0 interest,
1468: sel.amount princ_pay_down,
1469: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1470: FROM okl_strm_elements sel,
1471: okl_streams stm,
1472: okl_strm_type_b sty,
1473: okc_k_lines_b cle
1474: WHERE stm.khr_id = p_chr_id
1475: AND sty.id = stm.sty_id

Line 1647: FROM okl_streams stm,

1643:
1644: --Bug# 14683157: Fetch Last Billed Date only for Asset Principal Payment
1645: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1646: SELECT MAX(sel.stream_element_date)
1647: FROM okl_streams stm,
1648: okl_strm_elements sel,
1649: okl_strm_type_b sty,
1650: okc_k_lines_b cle
1651: WHERE stm.khr_id = p_chr_id

Line 1681: okl_streams stm,

1677: SELECT sel.stream_element_date bill_date,
1678: 0 principal,
1679: sel.amount interest
1680: FROM okl_strm_elements sel,
1681: okl_streams stm,
1682: okl_strm_type_b sty,
1683: okc_k_lines_b cle
1684: WHERE stm.khr_id = p_chr_id
1685: AND sty.id = stm.sty_id

Line 1699: okl_streams stm,

1695: SELECT sel.stream_element_date bill_date,
1696: 0 principal,
1697: sel.amount interest
1698: FROM okl_strm_elements sel,
1699: okl_streams stm,
1700: okl_strm_type_b sty,
1701: okc_k_lines_b cle
1702: WHERE stm.khr_id = p_chr_id
1703: AND sty.id = stm.sty_id

Line 1718: okl_streams stm,

1714: SELECT sel.stream_element_date bill_date,
1715: sel.amount principal,
1716: 0 interest
1717: FROM okl_strm_elements sel,
1718: okl_streams stm,
1719: okl_strm_type_b sty,
1720: okc_k_lines_b cle
1721: WHERE stm.khr_id = p_chr_id
1722: AND sty.id = stm.sty_id

Line 1982: okl_streams stm,

1978: 0 principal,
1979: sel.amount interest,
1980: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1981: FROM okl_strm_elements sel,
1982: okl_streams stm,
1983: okl_strm_type_b sty,
1984: okc_k_lines_b cle
1985: WHERE stm.khr_id = p_chr_id
1986: AND sty.id = stm.sty_id

Line 2000: okl_streams stm,

1996: sel.amount principal,
1997: 0 interest,
1998: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1999: FROM okl_strm_elements sel,
2000: okl_streams stm,
2001: okl_strm_type_b sty,
2002: okc_k_lines_b cle
2003: WHERE stm.khr_id = p_chr_id
2004: AND sty.id = stm.sty_id

Line 2021: okl_streams stm,

2017: 0 interest,
2018: 0 princ_pay_down,
2019: G_BILLED payment_type
2020: FROM okl_strm_elements sel,
2021: okl_streams stm,
2022: okl_strm_type_b sty,
2023: okc_k_lines_b cle
2024: WHERE stm.khr_id = p_chr_id
2025: AND sty.id = stm.sty_id

Line 2042: okl_streams stm,

2038: SUM(sel.amount) interest,
2039: 0 princ_pay_down,
2040: G_BILLED payment_type
2041: FROM okl_strm_elements sel,
2042: okl_streams stm,
2043: okl_strm_type_b sty,
2044: okc_k_lines_b cle
2045: WHERE stm.khr_id = p_chr_id
2046: AND sty.id = stm.sty_id

Line 2070: okl_streams stm,

2066: 0 interest,
2067: sel.amount princ_pay_down,
2068: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2069: FROM okl_strm_elements sel,
2070: okl_streams stm,
2071: okl_strm_type_b sty,
2072: okc_k_lines_b cle
2073: WHERE stm.khr_id = p_chr_id
2074: AND sty.id = stm.sty_id

Line 2277: okl_streams stm,

2273: 0 principal,
2274: sel.amount interest,
2275: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2276: FROM okl_strm_elements sel,
2277: okl_streams stm,
2278: okl_strm_type_b sty,
2279: okc_k_lines_b cle
2280: WHERE stm.khr_id = p_chr_id
2281: AND sty.id = stm.sty_id

Line 2295: okl_streams stm,

2291: sel.amount principal,
2292: 0 interest,
2293: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2294: FROM okl_strm_elements sel,
2295: okl_streams stm,
2296: okl_strm_type_b sty,
2297: okc_k_lines_b cle
2298: WHERE stm.khr_id = p_chr_id
2299: AND sty.id = stm.sty_id