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_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_LINES_FULL_V

Line 427: okl_K_lines_full_v kle,

423: FROM okl_strm_elements sele,
424: okl_streams str,
425: --okl_strm_type_tl sty,
426: okl_strm_type_v sty,
427: okl_K_lines_full_v kle,
428: okc_statuses_b sts
429: WHERE sele.stm_id = str.id
430: AND str.sty_id = sty.id
431: --AND UPPER(sty.name) = 'RENT'

Line 553: okl_K_lines_full_v kle,

549: SELECT NVL(SUM(sele.amount),0) INTO l_income
550: FROM okl_strm_elements sele,
551: okl_streams str,
552: okl_strm_type_v sty,
553: okl_K_lines_full_v kle,
554: okc_statuses_b sts
555: WHERE sele.stm_id = str.id
556: AND str.sty_id = sty.id
557: AND UPPER(sty.name) = 'UNEARNED INCOME'

Line 613: okl_K_lines_full_v kle,

609: CURSOR residual_csr( chrId NUMBER, lineId NUMBER ) IS
610: SELECT NVL(kle.residual_value,0) Value,
611: NVL(kle.residual_percentage,0) Percent
612: FROM OKC_LINE_STYLES_B LS,
613: okl_K_lines_full_v kle,
614: okc_statuses_b sts
615: WHERE LS.ID = KLE.LSE_ID
616: AND LS.LTY_CODE ='FREE_FORM1'
617: AND KLE.ID = lineId

Line 626: okl_K_lines_full_v kle,

622: CURSOR residual_csr_incl_terminated( chrId NUMBER, lineId NUMBER ) IS
623: SELECT NVL(kle.residual_value,0) Value,
624: NVL(kle.residual_percentage,0) Percent
625: FROM OKC_LINE_STYLES_B LS,
626: okl_K_lines_full_v kle,
627: okc_statuses_b sts
628: WHERE LS.ID = KLE.LSE_ID
629: AND LS.LTY_CODE ='FREE_FORM1'
630: AND KLE.ID = lineId

Line 823: okl_K_lines_full_v kle,

819:
820: CURSOR lines_csr( chrId NUMBER ) IS
821: SELECT kle.id lineId
822: FROM OKC_LINE_STYLES_B LS,
823: okl_K_lines_full_v kle,
824: okc_statuses_b sts
825: WHERE LS.ID = KLE.LSE_ID
826: AND LS.LTY_CODE ='FREE_FORM1'
827: AND KLE.DNZ_CHR_ID = chrId

Line 1414: okl_K_lines_full_v kle,

1410: -- rmunjulu 4042892
1411: IF l_discount_incl_terminated THEN
1412: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1413: FROM OKC_LINE_STYLES_B LS,
1414: okl_K_lines_full_v kle,
1415: okc_statuses_b sts
1416: WHERE LS.ID = KLE.LSE_ID
1417: AND LS.LTY_CODE ='FREE_FORM1'
1418: AND KLE.dnz_chr_iD = p_chr_id

Line 1424: okl_K_lines_full_v kle,

1420: AND sts.ste_code NOT IN ('EXPIRED', 'CANCELLED', 'HOLD');
1421: ELSE
1422: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1423: FROM OKC_LINE_STYLES_B LS,
1424: okl_K_lines_full_v kle,
1425: okc_statuses_b sts
1426: WHERE LS.ID = KLE.LSE_ID
1427: AND LS.LTY_CODE ='FREE_FORM1'
1428: AND KLE.dnz_chr_iD = p_chr_id

Line 1481: okl_K_lines_full_v kle,

1477: SELECT NVL(kle.tradein_amount,0.0) amnt,
1478: kle.dnz_chr_id chrId,
1479: kle.id lneId
1480: FROM OKC_LINE_STYLES_B LS,
1481: okl_K_lines_full_v kle,
1482: okc_statuses_b sts
1483: WHERE LS.ID = kLE.LSE_ID
1484: AND LS.LTY_CODE ='FREE_FORM1'
1485: AND kLE.dnz_chr_id = chrID

Line 1495: okl_K_lines_full_v kle,

1491: SELECT NVL(kle.tradein_amount,0.0) amnt,
1492: kle.dnz_chr_id chrId,
1493: kle.id lneId
1494: FROM OKC_LINE_STYLES_B LS,
1495: okl_K_lines_full_v kle,
1496: okc_statuses_b sts
1497: WHERE LS.ID = kLE.LSE_ID
1498: AND LS.LTY_CODE ='FREE_FORM1'
1499: AND kLE.dnz_chr_id = chrID

Line 1596: okl_K_lines_full_v kle,

1592:
1593: CURSOR l_lines_csr( chrId NUMBER ) IS
1594: SELECT kle.id
1595: FROM okc_line_styles_b ls,
1596: okl_K_lines_full_v kle,
1597: okc_statuses_b sts
1598: WHERE ls.id = kle.lse_id
1599: AND ls.lty_code = 'FREE_FORM1'
1600: AND kle.dnz_chr_id = chrId

Line 1611: okl_K_lines_full_v kle,

1607:
1608: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
1609: SELECT kle.id
1610: FROM okc_line_styles_b ls,
1611: okl_K_lines_full_v kle,
1612: okc_statuses_b sts
1613: WHERE ls.id = kle.lse_id
1614: AND ls.lty_code = 'FREE_FORM1'
1615: AND kle.dnz_chr_id = chrId

Line 1723: okl_K_lines_full_v kle,

1719: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
1720: NVL(kle.CAPITALIZE_DOWN_PAYMENT_YN, 'N') CAPITALIZE_DOWN_PAYMENT_YN,
1721: sts.ste_code
1722: FROM OKC_LINE_STYLES_B LS,
1723: okl_K_lines_full_v kle,
1724: okc_statuses_b sts
1725: WHERE LS.ID = KLE.LSE_ID
1726: AND LS.LTY_CODE ='FREE_FORM1'
1727: AND KLE.dnz_chr_id = p_chr_id

Line 1767: okl_K_lines_full_v kle,

1763: END IF;
1764: END LOOP;
1765: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
1766: FROM OKC_LINE_STYLES_B LS,
1767: okl_K_lines_full_v kle,
1768: okc_statuses_b sts
1769: WHERE LS.ID = KLE.LSE_ID
1770: AND LS.LTY_CODE ='FREE_FORM1'
1771: AND KLE.dnz_chr_id = p_chr_id

Line 1788: okl_K_lines_full_v kle,

1784: END LOOP;
1785:
1786: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
1787: FROM OKC_LINE_STYLES_B LS,
1788: okl_K_lines_full_v kle,
1789: okc_statuses_b sts
1790: WHERE LS.ID = KLE.LSE_ID
1791: AND LS.LTY_CODE ='FREE_FORM1'
1792: AND KLE.dnz_chr_id = p_chr_id

Line 1812: okl_K_lines_full_v kle,

1808: END LOOP;
1809:
1810: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
1811: FROM OKC_LINE_STYLES_B LS,
1812: okl_K_lines_full_v kle,
1813: okc_statuses_b sts
1814: WHERE LS.ID = KLE.LSE_ID
1815: AND LS.LTY_CODE ='FREE_FORM1'
1816: AND KLE.dnz_chr_id = p_chr_id

Line 1833: okl_K_lines_full_v kle,

1829: END LOOP;
1830:
1831: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
1832: FROM OKC_LINE_STYLES_B LS,
1833: okl_K_lines_full_v kle,
1834: okc_statuses_b sts
1835: WHERE LS.ID = KLE.LSE_ID
1836: AND LS.LTY_CODE ='FREE_FORM1'
1837: AND KLE.dnz_chr_id = p_chr_id

Line 2039: okl_K_lines_full_v kle,

2035:
2036: CURSOR l_lines_csr( chrId NUMBER ) IS
2037: SELECT kle.id
2038: FROM okc_line_styles_b ls,
2039: okl_K_lines_full_v kle,
2040: okc_statuses_b sts
2041: WHERE ls.id = kle.lse_id
2042: AND ls.lty_code = 'FREE_FORM1'
2043: AND kle.dnz_chr_id = chrId

Line 2050: okl_K_lines_full_v kle,

2046:
2047: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
2048: SELECT kle.id
2049: FROM okc_line_styles_b ls,
2050: okl_K_lines_full_v kle,
2051: okc_statuses_b sts
2052: WHERE ls.id = kle.lse_id
2053: AND ls.lty_code = 'FREE_FORM1'
2054: AND kle.dnz_chr_id = chrId

Line 2153: okl_K_lines_full_v kle,

2149: CURSOR l_srvcline_csr ( kleId NUMBER ) IS
2150: SELECT NVL(SUM(kle.capital_amount),0) CapAmountSubLines
2151: FROM OKC_LINE_STYLES_B LS,
2152: okc_k_items cim,
2153: okl_K_lines_full_v kle,
2154: okc_statuses_b sts
2155: WHERE LS.ID = KLE.LSE_ID
2156: AND ls.lty_code = 'LINK_SERV_ASSET'
2157: AND cim.jtot_object1_code = 'OKX_COVASST'

Line 2169: okl_K_lines_full_v kle,

2165: sty.name
2166: FROM okl_strm_type_v sty,
2167: okc_k_items cim,
2168: okc_line_styles_b ls,
2169: okl_K_lines_full_v kle,
2170: okc_statuses_b sts
2171: WHERE cim.cle_id = kle.id
2172: AND ls.id = kle.lse_id
2173: AND ls.lty_code = 'SOLD_SERVICE'

Line 2632: FROM OKL_K_LINES_FULL_V A

2628:
2629: CURSOR C (p_contract_id NUMBER)
2630: IS
2631: SELECT NVL(SUM(A.amount),0)
2632: FROM OKL_K_LINES_FULL_V A
2633: WHERE A.dnz_chr_id = p_contract_id
2634: AND A.credit_nature = 'NEW'
2635: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2636: ;

Line 2681: FROM OKL_K_LINES_FULL_V A

2677:
2678: CURSOR C (p_contract_id NUMBER)
2679: IS
2680: SELECT NVL(SUM(A.amount),0)
2681: FROM OKL_K_LINES_FULL_V A
2682: WHERE A.dnz_chr_id = p_contract_id
2683: AND A.credit_nature = 'ADD'
2684: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2685: ;

Line 2730: FROM OKL_K_LINES_FULL_V A

2726:
2727: CURSOR C (p_contract_id NUMBER)
2728: IS
2729: SELECT NVL(SUM(A.amount),0)
2730: FROM OKL_K_LINES_FULL_V A
2731: WHERE A.dnz_chr_id = p_contract_id
2732: AND A.credit_nature = 'REDUCE'
2733: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2734: ;

Line 3814: FROM OKL_K_LINES_FULL_V

3810: WHERE id = p_ctr_id;
3811:
3812: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
3813: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))
3814: FROM OKL_K_LINES_FULL_V
3815: WHERE DNZ_CHR_ID = p_ctr_id;
3816:
3817: BEGIN
3818: OPEN contract_num_csr(p_khr_id);

Line 5491: FROM okl_k_lines_full_v

5487: CURSOR C (p_contract_id NUMBER)
5488:
5489: IS
5490: SELECT NVL(SUM(RESIDUAL_VALUE),0)
5491: FROM okl_k_lines_full_v
5492: WHERE dnz_chr_id= p_contract_id
5493: AND sts_code <> 'TERMINATED';
5494:
5495: --Commented this code by rvaduri for bug 3487920

Line 7316: OKL_K_LINES_FULL_V KLE,

7312:
7313: CURSOR capz_csr( chrId NUMBER ) IS
7314: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7315: FROM OKC_LINE_STYLES_B LS,
7316: OKL_K_LINES_FULL_V KLE,
7317: okc_statuses_b sts
7318: WHERE LS.ID = KLE.LSE_ID
7319: AND LS.LTY_CODE ='FREE_FORM1'
7320: AND KLE.DNZ_CHR_ID = chrId

Line 7379: OKL_K_LINES_FULL_V KLE

7375:
7376: CURSOR capz_csr( chrId NUMBER, kleId NUMBER ) IS
7377: SELECT NVL( kle.capitalized_interest, 0.0)
7378: FROM OKC_LINE_STYLES_B LS,
7379: OKL_K_LINES_FULL_V KLE
7380: WHERE LS.ID = KLE.LSE_ID
7381: AND LS.LTY_CODE ='FREE_FORM1'
7382: AND KLE.DNZ_CHR_ID = chrId
7383: AND KLE.id = kleId;

Line 8673: okl_K_lines_full_v kle,

8669: FROM okl_strm_elements sele,
8670: okl_streams str,
8671: --okl_strm_type_tl sty,
8672: okl_strm_type_v sty,
8673: okl_K_lines_full_v kle,
8674: okc_statuses_b sts
8675: WHERE sele.stm_id = str.id
8676: AND str.sty_id = sty.id
8677: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'

Line 14469: okl_k_lines_full_v kle,

14465: NVL(kle.tradein_amount,0) tradein_amount,
14466: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
14467: kle.capitalize_down_payment_yn capitalize_down_payment_yn
14468: FROM okc_line_styles_b ls,
14469: okl_k_lines_full_v kle,
14470: okc_statuses_b sts
14471: WHERE kle.dnz_chr_id = p_dnz_chr_id
14472: AND kle.id = p_line_id
14473: AND ls.id = kle.lse_id