APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_LINES_B

Line 2862: FROM OKC_K_LINES_B KLE,

2858: -- RMUNJULU 20-FEB-03 2757368 Changed code to get only active lines
2859: CURSOR k_lines_csr (p_khr_id IN NUMBER) IS
2860: SELECT KLE.id kle_id,
2861: KLE.line_number line_number
2862: FROM OKC_K_LINES_B KLE,
2863: OKC_K_HEADERS_B KHR
2864: WHERE KLE.dnz_chr_id = p_khr_id
2865: AND KLE.sts_code = KHR.sts_code
2866: AND KLE.dnz_chr_id = KHR.id;

Line 6406: okc_k_lines_b okc_line,

6402: -- removed reference to stream type view.
6403: CURSOR idc_accel_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER,p_kle_id IN Number) IS
6404: SELECT okl_line.fee_type fee_type
6405: FROM okl_k_lines okl_line,
6406: okc_k_lines_b okc_line,
6407: okc_line_styles_b lse,
6408: okl_streams stm
6409: WHERE okl_line.id = okc_line.id AND
6410: okc_line.lse_id = lse.id AND lse.lty_code = 'FEE' AND

Line 6422: FROM okc_k_lines_b okc_line,

6418:
6419: -- ansethur for bug#6156337 08-aug-07 start
6420: CURSOR primary_sty_id_csr (p_khr_id IN NUMBER) IS
6421: SELECT sty.id Primary_sty_id, sty.code,okc_line.id kle_id
6422: FROM okc_k_lines_b okc_line,
6423: okc_line_styles_b lse,
6424: okc_k_items item,
6425: okl_strm_type_b sty
6426: WHERE okc_line.dnz_chr_id = p_khr_id

Line 8037: FROM okc_k_lines_b cle,

8033: cim.object1_id1,
8034: cim.object1_id2,
8035: cim.number_of_items,
8036: fa_kle.year_of_manufacture
8037: FROM okc_k_lines_b cle,
8038: okc_k_items cim,
8039: okc_line_styles_b lse,
8040: okc_statuses_b sts,
8041: okl_k_lines fa_kle,

Line 8042: okc_k_lines_b fa_cle,

8038: okc_k_items cim,
8039: okc_line_styles_b lse,
8040: okc_statuses_b sts,
8041: okl_k_lines fa_kle,
8042: okc_k_lines_b fa_cle,
8043: okc_line_styles_b fa_lse
8044: WHERE cle.dnz_chr_id = p_chr_id
8045: AND cle.cle_id = p_cle_id
8046: AND cle.lse_id = lse.id

Line 8097: OKC_K_LINES_B CLE,

8093:
8094: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
8095: SELECT ITM.ID
8096: FROM OKC_K_ITEMS ITM,
8097: OKC_K_LINES_B CLE,
8098: OKC_LINE_STYLES_B LSE
8099: WHERE ITM.CLE_ID = cle.ID
8100: AND CLE.CLE_ID = p_cle_id
8101: AND CLE.LSE_ID = LSE.ID

Line 8633: FROM okc_k_lines_b cle,

8629: cim.object1_id1,
8630: cim.object1_id2,
8631: cim.number_of_items,
8632: fa_kle.year_of_manufacture
8633: FROM okc_k_lines_b cle,
8634: okc_k_items cim,
8635: okc_line_styles_b lse,
8636: okc_statuses_b sts,
8637: okl_k_lines fa_kle,

Line 8638: okc_k_lines_b fa_cle,

8634: okc_k_items cim,
8635: okc_line_styles_b lse,
8636: okc_statuses_b sts,
8637: okl_k_lines fa_kle,
8638: okc_k_lines_b fa_cle,
8639: okc_line_styles_b fa_lse
8640: WHERE cle.dnz_chr_id = p_chr_id
8641: AND cle.cle_id = p_cle_id
8642: AND cle.lse_id = lse.id

Line 8693: OKC_K_LINES_B CLE,

8689:
8690: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
8691: SELECT ITM.ID
8692: FROM OKC_K_ITEMS ITM,
8693: OKC_K_LINES_B CLE,
8694: OKC_LINE_STYLES_B LSE
8695: WHERE ITM.CLE_ID = cle.ID
8696: AND CLE.CLE_ID = p_cle_id
8697: AND CLE.LSE_ID = LSE.ID