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_STRM_ELEMENTS

Line 252: FROM okl_strm_elements sel,

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

Line 267: FROM okl_strm_elements sel,

263: SELECT sel.stream_element_date bill_date
264: ,0 principal
265: ,sel.amount interest
266: ,decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
267: FROM okl_strm_elements sel,
268: okl_streams stm,
269: okl_strm_type_b sty
270: WHERE stm.khr_id = cp_khr_id
271: AND sty.id = stm.sty_id

Line 292: FROM okl_strm_elements sel,

288: 0 principal,
289: 0 interest,
290: sel.amount princ_pay_down,
291: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
292: FROM okl_strm_elements sel,
293: okl_streams stm,
294: okl_strm_type_b sty
295: WHERE stm.khr_id = cp_khr_id
296: AND sty.id = stm.sty_id

Line 506: FROM okl_strm_elements sel,

502: (
503: SELECT sel.stream_element_date bill_date
504: ,sel.amount principal
505: ,0 interest
506: FROM okl_strm_elements sel,
507: okl_streams stm,
508: okl_strm_type_b sty
509: WHERE stm.khr_id = cp_khr_id
510: AND sty.id = stm.sty_id

Line 520: FROM okl_strm_elements sel,

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

Line 539: FROM okl_strm_elements sel,

535: --This cursor selects the past principal paydown streams for a contract.
536: CURSOR c_amort_sch_ppd_csr(cp_khr_id IN NUMBER) IS
537: SELECT sel.stream_element_date bill_date
538: ,sum(sel.amount) ppd_amount
539: FROM okl_strm_elements sel,
540: okl_streams stm,
541: okl_strm_type_b sty
542: WHERE stm.khr_id = cp_khr_id
543: AND sty.id = stm.sty_id

Line 777: FROM okl_strm_elements sel_dii,

773: SELECT sel_dii.stream_element_date receipt_date,
774: 0 principal,
775: sel_dii.amount interest,
776: sel_dii.request_id
777: FROM okl_strm_elements sel_dii,
778: okl_streams stm_dii,
779: okl_strm_type_b sty_dii
780: WHERE stm_dii.khr_id = p_chr_id
781: AND sty_dii.id = stm_dii.sty_id

Line 791: FROM okl_strm_elements sel_dip,

787: SELECT sel_dip.stream_element_date receipt_date,
788: sel_dip.amount principal,
789: 0 interest,
790: sel_dip.request_id
791: FROM okl_strm_elements sel_dip,
792: okl_streams stm_dip,
793: okl_strm_type_b sty_dip
794: WHERE stm_dip.khr_id = p_chr_id
795: AND sty_dip.id = stm_dip.sty_id

Line 999: FROM okl_strm_elements sel_dii,

995: (
996: SELECT sel_dii.stream_element_date receipt_date,
997: 0 principal,
998: sel_dii.amount interest
999: FROM okl_strm_elements sel_dii,
1000: okl_streams stm_dii,
1001: okl_strm_type_b sty_dii
1002: WHERE stm_dii.khr_id = p_chr_id
1003: AND sty_dii.id = stm_dii.sty_id

Line 1012: FROM okl_strm_elements sel_dip,

1008: UNION ALL
1009: SELECT sel_dip.stream_element_date receipt_date,
1010: sel_dip.amount principal,
1011: 0 interest
1012: FROM okl_strm_elements sel_dip,
1013: okl_streams stm_dip,
1014: okl_strm_type_b sty_dip
1015: WHERE stm_dip.khr_id = p_chr_id
1016: AND sty_dip.id = stm_dip.sty_id

Line 1341: okl_strm_elements sel,

1337:
1338: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1339: SELECT MAX(sel.stream_element_date)
1340: FROM okl_streams stm,
1341: okl_strm_elements sel,
1342: okl_strm_type_b sty
1343: WHERE stm.khr_id = p_chr_id
1344: AND sty.id = stm.sty_id
1345: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'

Line 1351: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;

1347: AND stm.say_code = 'CURR'
1348: AND stm.active_yn = 'Y'
1349: AND sel.date_billed IS NOT NULL;
1350:
1351: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
1352:
1353: CURSOR chr_csr(p_chr_id IN NUMBER) IS
1354: SELECT chr.start_date
1355: FROM okc_k_headers_b chr

Line 1371: FROM okl_strm_elements sel,

1367: SELECT sel.stream_element_date bill_date,
1368: 0 principal,
1369: sel.amount interest,
1370: G_BILLED payment_type
1371: FROM okl_strm_elements sel,
1372: okl_streams stm,
1373: okl_strm_type_b sty
1374: WHERE stm.khr_id = p_chr_id
1375: AND sty.id = stm.sty_id

Line 1386: FROM okl_strm_elements sel,

1382: SELECT sel.stream_element_date bill_date,
1383: sel.amount principal,
1384: 0 interest,
1385: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1386: FROM okl_strm_elements sel,
1387: okl_streams stm,
1388: okl_strm_type_b sty
1389: WHERE stm.khr_id = p_chr_id
1390: AND sty.id = stm.sty_id

Line 1400: FROM okl_strm_elements sel,

1396: SELECT sel.stream_element_date bill_date,
1397: 0 principal,
1398: sel.amount interest,
1399: G_PROJECTED payment_type
1400: FROM okl_strm_elements sel,
1401: okl_streams stm,
1402: okl_strm_type_b sty
1403: WHERE stm.khr_id = p_chr_id
1404: AND sty.id = stm.sty_id

Line 1426: FROM okl_strm_elements sel,

1422: 0 principal,
1423: 0 interest,
1424: sel.amount princ_pay_down,
1425: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1426: FROM okl_strm_elements sel,
1427: okl_streams stm,
1428: okl_strm_type_b sty
1429: WHERE stm.khr_id = p_chr_id
1430: AND sty.id = stm.sty_id

Line 1599: okl_strm_elements sel,

1595:
1596: CURSOR last_bill_date_csr(p_chr_id IN NUMBER) IS
1597: SELECT MAX(sel.stream_element_date)
1598: FROM okl_streams stm,
1599: okl_strm_elements sel,
1600: okl_strm_type_b sty
1601: WHERE stm.khr_id = p_chr_id
1602: AND sty.id = stm.sty_id
1603: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'

Line 1609: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;

1605: AND stm.say_code = 'CURR'
1606: AND stm.active_yn = 'Y'
1607: AND sel.date_billed IS NOT NULL;
1608:
1609: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
1610:
1611: CURSOR chr_csr(p_chr_id IN NUMBER) IS
1612: SELECT chr.start_date
1613: FROM okc_k_headers_b chr

Line 1626: FROM okl_strm_elements sel,

1622: (
1623: SELECT sel.stream_element_date bill_date,
1624: 0 principal,
1625: sel.amount interest
1626: FROM okl_strm_elements sel,
1627: okl_streams stm,
1628: okl_strm_type_b sty
1629: WHERE stm.khr_id = p_chr_id
1630: AND sty.id = stm.sty_id

Line 1640: FROM okl_strm_elements sel,

1636: UNION ALL
1637: SELECT sel.stream_element_date bill_date,
1638: 0 principal,
1639: sel.amount interest
1640: FROM okl_strm_elements sel,
1641: okl_streams stm,
1642: okl_strm_type_b sty
1643: WHERE stm.khr_id = p_chr_id
1644: AND sty.id = stm.sty_id

Line 1655: FROM okl_strm_elements sel,

1651: UNION ALL
1652: SELECT sel.stream_element_date bill_date,
1653: sel.amount principal,
1654: 0 interest
1655: FROM okl_strm_elements sel,
1656: okl_streams stm,
1657: okl_strm_type_b sty
1658: WHERE stm.khr_id = p_chr_id
1659: AND sty.id = stm.sty_id

Line 1913: FROM okl_strm_elements sel,

1909: SELECT sel.stream_element_date bill_date,
1910: 0 principal,
1911: sel.amount interest,
1912: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1913: FROM okl_strm_elements sel,
1914: okl_streams stm,
1915: okl_strm_type_b sty
1916: WHERE stm.khr_id = p_chr_id
1917: AND sty.id = stm.sty_id

Line 1927: FROM okl_strm_elements sel,

1923: SELECT sel.stream_element_date bill_date,
1924: sel.amount principal,
1925: 0 interest,
1926: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1927: FROM okl_strm_elements sel,
1928: okl_streams stm,
1929: okl_strm_type_b sty
1930: WHERE stm.khr_id = p_chr_id
1931: AND sty.id = stm.sty_id

Line 1944: FROM okl_strm_elements sel,

1940: SUM(sel.amount) principal,
1941: 0 interest,
1942: 0 princ_pay_down,
1943: G_BILLED payment_type
1944: FROM okl_strm_elements sel,
1945: okl_streams stm,
1946: okl_strm_type_b sty
1947: WHERE stm.khr_id = p_chr_id
1948: AND sty.id = stm.sty_id

Line 1961: FROM okl_strm_elements sel,

1957: 0 principal,
1958: SUM(sel.amount) interest,
1959: 0 princ_pay_down,
1960: G_BILLED payment_type
1961: FROM okl_strm_elements sel,
1962: okl_streams stm,
1963: okl_strm_type_b sty
1964: WHERE stm.khr_id = p_chr_id
1965: AND sty.id = stm.sty_id

Line 1985: FROM okl_strm_elements sel,

1981: 0 principal,
1982: 0 interest,
1983: sel.amount princ_pay_down,
1984: decode(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
1985: FROM okl_strm_elements sel,
1986: okl_streams stm,
1987: okl_strm_type_b sty
1988: WHERE stm.khr_id = p_chr_id
1989: AND sty.id = stm.sty_id

Line 2187: FROM okl_strm_elements sel,

2183: SELECT sel.stream_element_date bill_date,
2184: 0 principal,
2185: sel.amount interest,
2186: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2187: FROM okl_strm_elements sel,
2188: okl_streams stm,
2189: okl_strm_type_b sty
2190: WHERE stm.khr_id = p_chr_id
2191: AND sty.id = stm.sty_id

Line 2201: FROM okl_strm_elements sel,

2197: SELECT sel.stream_element_date bill_date,
2198: sel.amount principal,
2199: 0 interest,
2200: DECODE(sel.date_billed,NULL,G_PROJECTED,G_BILLED) payment_type
2201: FROM okl_strm_elements sel,
2202: okl_streams stm,
2203: okl_strm_type_b sty
2204: WHERE stm.khr_id = p_chr_id
2205: AND sty.id = stm.sty_id