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 OKC_K_LINES_B

Line 75: FROM okc_k_lines_b cleb_fin,

71: l_api_version CONSTANT NUMBER := 1.0;
72:
73: CURSOR fin_cle_csr(p_chr_id IN NUMBER) IS
74: SELECT cleb_fin.id
75: FROM okc_k_lines_b cleb_fin,
76: okc_statuses_b sts
77: WHERE cleb_fin.dnz_chr_id = p_chr_id
78: AND cleb_fin.chr_id = p_chr_id
79: AND cleb_fin.lse_id = 33

Line 256: okc_k_lines_b cle

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
259: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
260: AND sel.stm_id = stm.id

Line 275: okc_k_lines_b cle

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
278: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
279: AND sel.stm_id = stm.id

Line 304: okc_k_lines_b cle

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
307: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
308: AND sel.stm_id = stm.id

Line 523: okc_k_lines_b cle

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
526: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
527: AND sel.stm_id = stm.id

Line 541: okc_k_lines_b cle

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
544: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
545: AND sel.stm_id = stm.id

Line 564: okc_k_lines_b cle

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
567: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
568: AND sel.stm_id = stm.id

Line 1370: okc_k_lines_b cle

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
1372: AND sty.id = stm.sty_id
1373: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1374: AND sel.stm_id = stm.id

Line 1406: okc_k_lines_b cle

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
1409: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1410: AND sel.stm_id = stm.id

Line 1425: okc_k_lines_b cle

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
1428: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1429: AND sel.stm_id = stm.id

Line 1443: okc_k_lines_b cle

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
1446: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1447: AND sel.stm_id = stm.id

Line 1473: okc_k_lines_b cle

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
1476: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
1477: AND sel.stm_id = stm.id

Line 1650: okc_k_lines_b cle

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
1652: AND sty.id = stm.sty_id
1653: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
1654: AND sel.stm_id = stm.id

Line 1683: okc_k_lines_b cle

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
1686: AND sty.stream_type_purpose = 'VARIABLE_INTEREST'
1687: AND sel.stm_id = stm.id

Line 1701: okc_k_lines_b cle

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
1704: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1705: AND sel.stm_id = stm.id

Line 1720: okc_k_lines_b cle

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
1723: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','UNSCHEDULED_PRINCIPAL_PAYMENT')
1724: AND sel.stm_id = stm.id

Line 1984: okc_k_lines_b cle

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
1987: AND sty.stream_type_purpose = 'INTEREST_PAYMENT'
1988: AND sel.stm_id = stm.id

Line 2002: okc_k_lines_b cle

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
2005: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
2006: AND sel.stm_id = stm.id

Line 2023: okc_k_lines_b cle

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
2026: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
2027: AND sel.stm_id = stm.id

Line 2044: okc_k_lines_b cle

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
2047: AND sty.stream_type_purpose = 'INTEREST_CATCHUP'
2048: AND sel.stm_id = stm.id

Line 2072: okc_k_lines_b cle

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
2075: AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
2076: AND sel.stm_id = stm.id

Line 2279: okc_k_lines_b cle

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
2282: AND sty.stream_type_purpose IN ('INTEREST_PAYMENT','INTEREST_CATCHUP')
2283: AND sel.stm_id = stm.id

Line 2297: okc_k_lines_b cle

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
2300: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT','PRINCIPAL_CATCHUP','UNSCHEDULED_PRINCIPAL_PAYMENT')
2301: AND sel.stm_id = stm.id

Line 2580: FROM okc_k_lines_b cleb,

2576: rulb2.rule_information10 arrear_yn,
2577: --Bug# 14529968
2578: rulb2.object1_id1 frequency,
2579: cleb.sts_code sts_code
2580: FROM okc_k_lines_b cleb,
2581: okc_rule_groups_b rgpb,
2582: okc_rules_b rulb,
2583: okc_rules_b rulb2,
2584: okl_strm_type_b styb,