APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_LINES_FULL_V

Line 3920: FROM okl_k_lines_full_v kle,

3916: kle.orig_system_id1,
3917: kle.initial_direct_cost,
3918: tl.item_description,
3919: tl.name
3920: FROM okl_k_lines_full_v kle,
3921: okc_line_styles_b lse,
3922: okc_k_lines_tl tl,
3923: okc_statuses_b sts
3924: WHERE kle.lse_id = lse.id

Line 5787: okl_k_lines_full_v kle,

5783: From okl_strm_elements ele,
5784: okl_streams str,
5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts
5790: Where ele.stm_id = str.id
5791: and str.khr_id = chrId

Line 7199: FROM okl_k_lines_full_v kle,

7195: AND str.say_code = 'CURR'
7196: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
7197: AND (NVL( str.kle_id, -1) = -1 OR
7198: str.kle_id IN (SELECT kle.id
7199: FROM okl_k_lines_full_v kle,
7200: okc_line_styles_b lse,
7201: okc_statuses_b sts
7202: WHERE KLE.LSE_ID = LSE.ID
7203: AND kle.dnz_chr_id = p_chr_id

Line 8663: from okl_k_lines_full_v kle,

8659: kle.fee_type,
8660: kle.initial_direct_cost,
8661: tl.item_description,
8662: tl.name
8663: from okl_k_lines_full_v kle,
8664: okc_line_styles_b lse,
8665: okc_k_lines_tl tl,
8666: okc_statuses_b sts
8667: where KLE.LSE_ID = LSE.ID

Line 8689: okl_k_lines_full_v kle,

8685: kle.id line_id,
8686: stl.id styp_id
8687: FROM OKL_STRM_TMPT_LINES_UV stl,
8688: okc_k_items cim,
8689: okl_k_lines_full_v kle,
8690: okc_line_styles_b ls
8691: WHERE cim.cle_id = kle.id
8692: AND ls.id = kle.lse_id
8693: AND ls.lty_code = 'FEE'

Line 9454: FROM okl_k_lines_full_v kle,

9450: kle.tradein_amount,
9451: kle.date_funding_expected,
9452: kle.capital_reduction,
9453: kle.capitalize_down_payment_yn
9454: FROM okl_k_lines_full_v kle,
9455: okc_line_styles_b lse,
9456: okc_k_lines_tl tl,
9457: okc_statuses_b sts
9458: WHERE kle.lse_id = lse.id

Line 13230: l_total_oec okl_k_lines_full_v.oec%TYPE;

13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;
13231: --Added by kthiruva for the VR build
13232: l_ppd_assigned VARCHAR2(1) := 'N';
13233: l_rent_sty_id strm_rec_type;
13234: l_prev_ppd NUMBER := 0;

Line 15305: l_total_oec okl_k_lines_full_v.oec%TYPE;

15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;
15306: --Added by kthiruva for the VR build
15307: l_rent_sty_id strm_rec_type;
15308: l_prev_ppd NUMBER := 0;
15309:

Line 17637: FROM okl_k_lines_full_v kle,

17633: kle.date_funding_expected,
17634: -- Added for Down Payment Enhancement
17635: kle.capital_reduction,
17636: kle.capitalize_down_payment_yn
17637: FROM okl_k_lines_full_v kle,
17638: okc_line_styles_b lse,
17639: okc_k_lines_tl tl,
17640: okc_statuses_b sts
17641: WHERE kle.lse_id = lse.id

Line 21952: FROM okl_k_lines_full_v kle,

21948: kle.fee_type,
21949: kle.initial_direct_cost,
21950: tl.item_description,
21951: tl.name
21952: FROM okl_k_lines_full_v kle,
21953: okc_line_styles_b lse,
21954: okc_k_lines_tl tl,
21955: okc_statuses_b sts
21956: WHERE kle.lse_id = lse.id

Line 21987: FROM okl_k_lines_full_v kle,

21983: kle.fee_type,
21984: kle.initial_direct_cost,
21985: tl.item_description,
21986: tl.name
21987: FROM okl_k_lines_full_v kle,
21988: okc_line_styles_b lse,
21989: okc_k_lines_tl tl,
21990: okc_statuses_b sts
21991: WHERE kle.lse_id = lse.id