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 426: okl_K_lines_full_v kle,

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

Line 475: okl_K_lines_full_v kle,

471: FROM okl_strm_elements sele,
472: okl_streams str,
473: --okl_strm_type_tl sty,
474: okl_strm_type_v sty,
475: okl_K_lines_full_v kle,
476: okc_statuses_b sts
477: WHERE sele.stm_id = str.id
478: AND str.sty_id = sty.id
479: --AND UPPER(sty.name) = 'RENT'

Line 626: okl_K_lines_full_v kle,

622: SELECT NVL(SUM(sele.amount),0) INTO l_income
623: FROM okl_strm_elements sele,
624: okl_streams str,
625: okl_strm_type_v sty,
626: okl_K_lines_full_v kle,
627: okc_statuses_b sts
628: WHERE sele.stm_id = str.id
629: AND str.sty_id = sty.id
630: AND UPPER(sty.name) = 'UNEARNED INCOME'

Line 687: okl_K_lines_full_v kle,

683: SELECT NVL(kle.residual_value,0) Value,
684: NVL(kle.residual_percentage,0) Percent
685: ,ls.lty_code lty_Code --added bug 7439724
686: FROM OKC_LINE_STYLES_B LS,
687: okl_K_lines_full_v kle,
688: okc_statuses_b sts
689: WHERE LS.ID = KLE.LSE_ID
690: --Modified bug 7439724
691: AND LS.LTY_CODE in ('FREE_FORM1',

Line 705: okl_K_lines_full_v kle,

701: SELECT NVL(kle.residual_value,0) Value,
702: NVL(kle.residual_percentage,0) Percent
703: ,ls.lty_code lty_Code --added bug 7439724
704: FROM OKC_LINE_STYLES_B LS,
705: okl_K_lines_full_v kle,
706: okc_statuses_b sts
707: WHERE LS.ID = KLE.LSE_ID
708: --Modified bug 7439724
709: AND LS.LTY_CODE in ('FREE_FORM1',

Line 909: okl_K_lines_full_v kle,

905:
906: CURSOR lines_csr( chrId NUMBER ) IS
907: SELECT kle.id lineId
908: FROM OKC_LINE_STYLES_B LS,
909: okl_K_lines_full_v kle,
910: okc_statuses_b sts
911: WHERE LS.ID = KLE.LSE_ID
912: AND LS.LTY_CODE ='FREE_FORM1'
913: AND KLE.DNZ_CHR_ID = chrId

Line 922: okl_K_lines_full_v kle,

918: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
919: CURSOR lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
920: SELECT kle.id lineId
921: FROM OKC_LINE_STYLES_B LS,
922: okl_K_lines_full_v kle,
923: okc_statuses_b sts
924: WHERE LS.ID = KLE.LSE_ID
925: AND LS.LTY_CODE ='FREE_FORM1'
926: AND KLE.DNZ_CHR_ID = chrId

Line 1679: okl_K_lines_full_v kle,

1675:
1676: IF l_discount_incl_terminated THEN
1677: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1678: FROM OKC_LINE_STYLES_B LS,
1679: okl_K_lines_full_v kle,
1680: okc_statuses_b sts
1681: WHERE LS.ID = KLE.LSE_ID
1682: AND LS.LTY_CODE ='FREE_FORM1'
1683: AND KLE.dnz_chr_iD = p_chr_id

Line 1692: okl_K_lines_full_v kle,

1688: ELSE
1689:
1690: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1691: FROM OKC_LINE_STYLES_B LS,
1692: okl_K_lines_full_v kle,
1693: okc_statuses_b sts
1694: WHERE LS.ID = KLE.LSE_ID
1695: AND LS.LTY_CODE ='FREE_FORM1'
1696: AND KLE.dnz_chr_iD = p_chr_id

Line 1717: okl_K_lines_full_v kle,

1713: --Bug# 15992711 , End
1714:
1715: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1716: FROM OKC_LINE_STYLES_B LS,
1717: okl_K_lines_full_v kle,
1718: okc_statuses_b sts
1719: WHERE LS.ID = KLE.LSE_ID
1720: AND LS.LTY_CODE ='FREE_FORM1'
1721: AND KLE.dnz_chr_iD = p_chr_id

Line 1728: okl_K_lines_full_v kle,

1724:
1725: ELSE
1726: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1727: FROM OKC_LINE_STYLES_B LS,
1728: okl_K_lines_full_v kle,
1729: okc_statuses_b sts
1730: WHERE LS.ID = KLE.LSE_ID
1731: AND LS.LTY_CODE ='FREE_FORM1'
1732: AND KLE.dnz_chr_iD = p_chr_id

Line 1785: okl_K_lines_full_v kle,

1781: SELECT NVL(kle.tradein_amount,0.0) amnt,
1782: kle.dnz_chr_id chrId,
1783: kle.id lneId
1784: FROM OKC_LINE_STYLES_B LS,
1785: okl_K_lines_full_v kle,
1786: okc_statuses_b sts
1787: WHERE LS.ID = kLE.LSE_ID
1788: AND LS.LTY_CODE ='FREE_FORM1'
1789: AND kLE.dnz_chr_id = chrID

Line 1799: okl_K_lines_full_v kle,

1795: SELECT NVL(kle.tradein_amount,0.0) amnt,
1796: kle.dnz_chr_id chrId,
1797: kle.id lneId
1798: FROM OKC_LINE_STYLES_B LS,
1799: okl_K_lines_full_v kle,
1800: okc_statuses_b sts
1801: WHERE LS.ID = kLE.LSE_ID
1802: AND LS.LTY_CODE ='FREE_FORM1'
1803: AND kLE.dnz_chr_id = chrID

Line 1908: okl_K_lines_full_v kle,

1904:
1905: CURSOR l_lines_csr( chrId NUMBER ) IS
1906: SELECT kle.id
1907: FROM okc_line_styles_b ls,
1908: okl_K_lines_full_v kle,
1909: okc_statuses_b sts
1910: WHERE ls.id = kle.lse_id
1911: AND ls.lty_code = 'FREE_FORM1'
1912: AND kle.dnz_chr_id = chrId

Line 1923: okl_K_lines_full_v kle,

1919:
1920: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
1921: SELECT kle.id
1922: FROM okc_line_styles_b ls,
1923: okl_K_lines_full_v kle,
1924: okc_statuses_b sts
1925: WHERE ls.id = kle.lse_id
1926: AND ls.lty_code = 'FREE_FORM1'
1927: AND kle.dnz_chr_id = chrId

Line 1939: okl_K_lines_full_v kle,

1935: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
1936: CURSOR l_lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
1937: SELECT kle.id
1938: FROM okc_line_styles_b ls,
1939: okl_K_lines_full_v kle,
1940: okc_statuses_b sts
1941: WHERE ls.id = kle.lse_id
1942: AND ls.lty_code = 'FREE_FORM1'
1943: AND kle.dnz_chr_id = chrId

Line 1956: okl_K_lines_full_v kle,

1952: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
1953: CURSOR l_lines_nr_csr_incl_term( chrId NUMBER, p_line_type VARCHAR2 ) IS
1954: SELECT kle.id
1955: FROM okc_line_styles_b ls,
1956: okl_K_lines_full_v kle,
1957: okc_statuses_b sts
1958: WHERE ls.id = kle.lse_id
1959: AND ls.lty_code = 'FREE_FORM1'
1960: AND kle.dnz_chr_id = chrId

Line 2114: okl_K_lines_full_v kle,

2110: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
2111: NVL(kle.CAPITALIZE_DOWN_PAYMENT_YN, 'N') CAPITALIZE_DOWN_PAYMENT_YN,
2112: sts.ste_code
2113: FROM OKC_LINE_STYLES_B LS,
2114: okl_K_lines_full_v kle,
2115: okc_statuses_b sts
2116: WHERE LS.ID = KLE.LSE_ID
2117: AND LS.LTY_CODE ='FREE_FORM1'
2118: AND KLE.dnz_chr_id = p_chr_id

Line 2158: okl_K_lines_full_v kle,

2154: END IF;
2155: END LOOP;
2156: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
2157: FROM OKC_LINE_STYLES_B LS,
2158: okl_K_lines_full_v kle,
2159: okc_statuses_b sts
2160: WHERE LS.ID = KLE.LSE_ID
2161: AND LS.LTY_CODE ='FREE_FORM1'
2162: AND KLE.dnz_chr_id = p_chr_id

Line 2179: okl_K_lines_full_v kle,

2175: END LOOP;
2176:
2177: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
2178: FROM OKC_LINE_STYLES_B LS,
2179: okl_K_lines_full_v kle,
2180: okc_statuses_b sts
2181: WHERE LS.ID = KLE.LSE_ID
2182: AND LS.LTY_CODE ='FREE_FORM1'
2183: AND KLE.dnz_chr_id = p_chr_id

Line 2203: okl_K_lines_full_v kle,

2199: END LOOP;
2200:
2201: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
2202: FROM OKC_LINE_STYLES_B LS,
2203: okl_K_lines_full_v kle,
2204: okc_statuses_b sts
2205: WHERE LS.ID = KLE.LSE_ID
2206: AND LS.LTY_CODE ='FREE_FORM1'
2207: AND KLE.dnz_chr_id = p_chr_id

Line 2224: okl_K_lines_full_v kle,

2220: END LOOP;
2221:
2222: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
2223: FROM OKC_LINE_STYLES_B LS,
2224: okl_K_lines_full_v kle,
2225: okc_statuses_b sts
2226: WHERE LS.ID = KLE.LSE_ID
2227: AND LS.LTY_CODE ='FREE_FORM1'
2228: AND KLE.dnz_chr_id = p_chr_id

Line 2430: okl_K_lines_full_v kle,

2426:
2427: CURSOR l_lines_csr( chrId NUMBER ) IS
2428: SELECT kle.id
2429: FROM okc_line_styles_b ls,
2430: okl_K_lines_full_v kle,
2431: okc_statuses_b sts
2432: WHERE ls.id = kle.lse_id
2433: AND ls.lty_code = 'FREE_FORM1'
2434: AND kle.dnz_chr_id = chrId

Line 2441: okl_K_lines_full_v kle,

2437:
2438: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
2439: SELECT kle.id
2440: FROM okc_line_styles_b ls,
2441: okl_K_lines_full_v kle,
2442: okc_statuses_b sts
2443: WHERE ls.id = kle.lse_id
2444: AND ls.lty_code = 'FREE_FORM1'
2445: AND kle.dnz_chr_id = chrId

Line 2454: okl_K_lines_full_v kle,

2450: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
2451: CURSOR l_lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
2452: SELECT kle.id
2453: FROM okc_line_styles_b ls,
2454: okl_K_lines_full_v kle,
2455: okc_statuses_b sts
2456: WHERE ls.id = kle.lse_id
2457: AND ls.lty_code = 'FREE_FORM1'
2458: AND kle.dnz_chr_id = chrId

Line 2468: okl_K_lines_full_v kle,

2464: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
2465: CURSOR l_lines_nr_csr_incl_term( chrId NUMBER, p_line_type VARCHAR2 ) IS
2466: SELECT kle.id
2467: FROM okc_line_styles_b ls,
2468: okl_K_lines_full_v kle,
2469: okc_statuses_b sts
2470: WHERE ls.id = kle.lse_id
2471: AND ls.lty_code = 'FREE_FORM1'
2472: AND kle.dnz_chr_id = chrId

Line 2617: okl_K_lines_full_v kle,

2613: CURSOR l_srvcline_csr ( kleId NUMBER ) IS
2614: SELECT NVL(SUM(kle.capital_amount),0) CapAmountSubLines
2615: FROM OKC_LINE_STYLES_B LS,
2616: okc_k_items cim,
2617: okl_K_lines_full_v kle,
2618: okc_statuses_b sts
2619: WHERE LS.ID = KLE.LSE_ID
2620: AND ls.lty_code = 'LINK_SERV_ASSET'
2621: AND cim.jtot_object1_code = 'OKX_COVASST'

Line 2633: okl_K_lines_full_v kle,

2629: sty.name
2630: FROM okl_strm_type_v sty,
2631: okc_k_items cim,
2632: okc_line_styles_b ls,
2633: okl_K_lines_full_v kle,
2634: okc_statuses_b sts
2635: WHERE cim.cle_id = kle.id
2636: AND ls.id = kle.lse_id
2637: AND ls.lty_code = 'SOLD_SERVICE'

Line 3096: FROM OKL_K_LINES_FULL_V A

3092:
3093: CURSOR C (p_contract_id NUMBER)
3094: IS
3095: SELECT NVL(SUM(A.amount),0)
3096: FROM OKL_K_LINES_FULL_V A
3097: WHERE A.dnz_chr_id = p_contract_id
3098: AND A.credit_nature = 'NEW'
3099: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
3100: ;

Line 3145: FROM OKL_K_LINES_FULL_V A

3141:
3142: CURSOR C (p_contract_id NUMBER)
3143: IS
3144: SELECT NVL(SUM(A.amount),0)
3145: FROM OKL_K_LINES_FULL_V A
3146: WHERE A.dnz_chr_id = p_contract_id
3147: AND A.credit_nature = 'ADD'
3148: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
3149: ;

Line 3194: FROM OKL_K_LINES_FULL_V A

3190:
3191: CURSOR C (p_contract_id NUMBER)
3192: IS
3193: SELECT NVL(SUM(A.amount),0)
3194: FROM OKL_K_LINES_FULL_V A
3195: WHERE A.dnz_chr_id = p_contract_id
3196: AND A.credit_nature = 'REDUCE'
3197: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
3198: ;

Line 4377: FROM OKL_K_LINES_FULL_V

4373: WHERE id = p_ctr_id;
4374:
4375: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
4376: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))
4377: FROM OKL_K_LINES_FULL_V
4378: WHERE DNZ_CHR_ID = p_ctr_id;
4379:
4380: BEGIN
4381: OPEN contract_num_csr(p_khr_id);

Line 6089: FROM okl_k_lines_full_v

6085: CURSOR C (p_contract_id NUMBER)
6086:
6087: IS
6088: SELECT NVL(SUM(RESIDUAL_VALUE),0)
6089: FROM okl_k_lines_full_v
6090: WHERE dnz_chr_id= p_contract_id
6091: AND sts_code <> 'TERMINATED';
6092:
6093: --Commented this code by rvaduri for bug 3487920

Line 7914: OKL_K_LINES_FULL_V KLE,

7910:
7911: CURSOR capz_csr( chrId NUMBER ) IS
7912: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7913: FROM OKC_LINE_STYLES_B LS,
7914: OKL_K_LINES_FULL_V KLE,
7915: okc_statuses_b sts
7916: WHERE LS.ID = KLE.LSE_ID
7917: AND LS.LTY_CODE ='FREE_FORM1'
7918: AND KLE.DNZ_CHR_ID = chrId

Line 7929: OKL_K_LINES_FULL_V KLE,

7925: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
7926: CURSOR capz_nr_csr( chrId NUMBER, p_line_type VARCHAR2) IS
7927: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7928: FROM OKC_LINE_STYLES_B LS,
7929: OKL_K_LINES_FULL_V KLE,
7930: okc_statuses_b sts
7931: WHERE LS.ID = KLE.LSE_ID
7932: AND LS.LTY_CODE ='FREE_FORM1'
7933: AND KLE.DNZ_CHR_ID = chrId

Line 8028: OKL_K_LINES_FULL_V KLE

8024:
8025: CURSOR capz_csr( chrId NUMBER, kleId NUMBER ) IS
8026: SELECT NVL( kle.capitalized_interest, 0.0)
8027: FROM OKC_LINE_STYLES_B LS,
8028: OKL_K_LINES_FULL_V KLE
8029: WHERE LS.ID = KLE.LSE_ID
8030: AND LS.LTY_CODE ='FREE_FORM1'
8031: AND KLE.DNZ_CHR_ID = chrId
8032: AND KLE.id = kleId;

Line 9523: okl_K_lines_full_v kle,

9519: FROM okl_strm_elements sele,
9520: okl_streams str,
9521: --okl_strm_type_tl sty,
9522: okl_strm_type_v sty,
9523: okl_K_lines_full_v kle,
9524: okc_statuses_b sts
9525: WHERE sele.stm_id = str.id
9526: AND str.sty_id = sty.id
9527: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'

Line 15701: okl_k_lines_full_v kle,

15697: NVL(kle.tradein_amount,0) tradein_amount,
15698: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
15699: kle.capitalize_down_payment_yn capitalize_down_payment_yn
15700: FROM okc_line_styles_b ls,
15701: okl_k_lines_full_v kle,
15702: okc_statuses_b sts
15703: WHERE kle.dnz_chr_id = p_dnz_chr_id
15704: AND kle.id = p_line_id
15705: AND ls.id = kle.lse_id