APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_LINES_FULL_V

Line 5019: FROM okl_k_lines_full_v kle,

5015: kle.orig_system_id1,
5016: kle.initial_direct_cost,
5017: tl.item_description,
5018: tl.name
5019: FROM okl_k_lines_full_v kle,
5020: okc_line_styles_b lse,
5021: okc_k_lines_tl tl,
5022: okc_statuses_b sts
5023: WHERE kle.lse_id = lse.id

Line 7203: okl_k_lines_full_v kle,

7199: From okl_strm_elements ele,
7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts
7206: Where ele.stm_id = str.id
7207: and str.khr_id = chrId

Line 8693: FROM okl_k_lines_full_v kle,

8689: AND str.say_code = 'CURR'
8690: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
8691: AND (NVL( str.kle_id, -1) = -1 OR
8692: str.kle_id IN (SELECT kle.id
8693: FROM okl_k_lines_full_v kle,
8694: okc_line_styles_b lse,
8695: okc_statuses_b sts
8696: WHERE KLE.LSE_ID = LSE.ID
8697: AND kle.dnz_chr_id = p_chr_id

Line 10185: from okl_k_lines_full_v kle,

10181: kle.initial_direct_cost,
10182: tl.item_description,
10183: tl.name ,
10184: kle.orig_contract_line_id --sechawla 15-jul-09 PRB ESG Enhancements : added orig_contract_line_id
10185: from okl_k_lines_full_v kle,
10186: okc_line_styles_b lse,
10187: okc_k_lines_tl tl,
10188: okc_statuses_b sts
10189: where KLE.LSE_ID = LSE.ID

Line 10211: okl_k_lines_full_v kle,

10207: kle.id line_id,
10208: stl.id styp_id
10209: FROM OKL_STRM_TMPT_LINES_UV stl,
10210: okc_k_items cim,
10211: okl_k_lines_full_v kle,
10212: okc_line_styles_b ls
10213: WHERE cim.cle_id = kle.id
10214: AND ls.id = kle.lse_id
10215: AND ls.lty_code = 'FEE'

Line 11040: FROM okl_k_lines_full_v kle,

11036: kle.date_funding_expected,
11037: kle.capital_reduction,
11038: kle.capitalize_down_payment_yn,
11039: kle.orig_contract_line_id --sechawla 15-jul-09 ESG PRB Enhancements : added orig_contract_line_id
11040: FROM okl_k_lines_full_v kle,
11041: okc_line_styles_b lse,
11042: okc_k_lines_tl tl,
11043: okc_statuses_b sts
11044: WHERE kle.lse_id = lse.id

Line 15333: l_total_oec okl_k_lines_full_v.oec%TYPE;

15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;
15334: --Added by kthiruva for the VR build
15335: l_ppd_assigned VARCHAR2(1) := 'N';
15336: l_rent_sty_id strm_rec_type;
15337: l_prev_ppd NUMBER := 0;

Line 17618: l_total_oec okl_k_lines_full_v.oec%TYPE;

17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;
17619: --Added by kthiruva for the VR build
17620: l_rent_sty_id strm_rec_type;
17621: l_prev_ppd NUMBER := 0;
17622:

Line 20275: FROM okl_k_lines_full_v kle,

20271: kle.capital_reduction,
20272: kle.capitalize_down_payment_yn,
20273: kle.orig_contract_line_id, --sechawla 10-jul-09 PRB ESG enhancements : added
20274: kle.capital_reduction_percent
20275: FROM okl_k_lines_full_v kle,
20276: okc_line_styles_b lse,
20277: okc_k_lines_tl tl,
20278: okc_statuses_b sts
20279: WHERE kle.lse_id = lse.id

Line 24795: FROM okl_k_lines_full_v kle,

24791: kle.fee_type,
24792: kle.initial_direct_cost,
24793: tl.item_description,
24794: tl.name
24795: FROM okl_k_lines_full_v kle,
24796: okc_line_styles_b lse,
24797: okc_k_lines_tl tl,
24798: okc_statuses_b sts
24799: WHERE kle.lse_id = lse.id

Line 24830: FROM okl_k_lines_full_v kle,

24826: kle.fee_type,
24827: kle.initial_direct_cost,
24828: tl.item_description,
24829: tl.name
24830: FROM okl_k_lines_full_v kle,
24831: okc_line_styles_b lse,
24832: okc_k_lines_tl tl,
24833: okc_statuses_b sts
24834: WHERE kle.lse_id = lse.id