APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_LINES_B

Line 2746: FROM OKC_K_LINES_B KLE,

2742: -- RMUNJULU 20-FEB-03 2757368 Changed code to get only active lines
2743: CURSOR k_lines_csr (p_khr_id IN NUMBER) IS
2744: SELECT KLE.id kle_id,
2745: KLE.line_number line_number
2746: FROM OKC_K_LINES_B KLE,
2747: OKC_K_HEADERS_B KHR
2748: WHERE KLE.dnz_chr_id = p_khr_id
2749: AND KLE.sts_code = KHR.sts_code
2750: AND KLE.dnz_chr_id = KHR.id;

Line 6240: okc_k_lines_b okc_line,

6236: -- removed reference to stream type view.
6237: CURSOR idc_accel_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER,p_kle_id IN Number) IS
6238: SELECT okl_line.fee_type fee_type
6239: FROM okl_k_lines okl_line,
6240: okc_k_lines_b okc_line,
6241: okc_line_styles_b lse,
6242: okl_streams stm
6243: WHERE okl_line.id = okc_line.id AND
6244: okc_line.lse_id = lse.id AND lse.lty_code = 'FEE' AND

Line 6256: FROM okc_k_lines_b okc_line,

6252:
6253: -- ansethur for bug#6156337 08-aug-07 start
6254: CURSOR primary_sty_id_csr (p_khr_id IN NUMBER) IS
6255: SELECT sty.id Primary_sty_id, sty.code,okc_line.id kle_id
6256: FROM okc_k_lines_b okc_line,
6257: okc_line_styles_b lse,
6258: okc_k_items item,
6259: okl_strm_type_b sty
6260: WHERE okc_line.dnz_chr_id = p_khr_id

Line 7838: FROM okc_k_lines_b cle,

7834: cim.object1_id1,
7835: cim.object1_id2,
7836: cim.number_of_items,
7837: fa_kle.year_of_manufacture
7838: FROM okc_k_lines_b cle,
7839: okc_k_items cim,
7840: okc_line_styles_b lse,
7841: okc_statuses_b sts,
7842: okl_k_lines fa_kle,

Line 7843: okc_k_lines_b fa_cle,

7839: okc_k_items cim,
7840: okc_line_styles_b lse,
7841: okc_statuses_b sts,
7842: okl_k_lines fa_kle,
7843: okc_k_lines_b fa_cle,
7844: okc_line_styles_b fa_lse
7845: WHERE cle.dnz_chr_id = p_chr_id
7846: AND cle.cle_id = p_cle_id
7847: AND cle.lse_id = lse.id

Line 7898: OKC_K_LINES_B CLE,

7894:
7895: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
7896: SELECT ITM.ID
7897: FROM OKC_K_ITEMS ITM,
7898: OKC_K_LINES_B CLE,
7899: OKC_LINE_STYLES_B LSE
7900: WHERE ITM.CLE_ID = cle.ID
7901: AND CLE.CLE_ID = p_cle_id
7902: AND CLE.LSE_ID = LSE.ID

Line 8434: FROM okc_k_lines_b cle,

8430: cim.object1_id1,
8431: cim.object1_id2,
8432: cim.number_of_items,
8433: fa_kle.year_of_manufacture
8434: FROM okc_k_lines_b cle,
8435: okc_k_items cim,
8436: okc_line_styles_b lse,
8437: okc_statuses_b sts,
8438: okl_k_lines fa_kle,

Line 8439: okc_k_lines_b fa_cle,

8435: okc_k_items cim,
8436: okc_line_styles_b lse,
8437: okc_statuses_b sts,
8438: okl_k_lines fa_kle,
8439: okc_k_lines_b fa_cle,
8440: okc_line_styles_b fa_lse
8441: WHERE cle.dnz_chr_id = p_chr_id
8442: AND cle.cle_id = p_cle_id
8443: AND cle.lse_id = lse.id

Line 8494: OKC_K_LINES_B CLE,

8490:
8491: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
8492: SELECT ITM.ID
8493: FROM OKC_K_ITEMS ITM,
8494: OKC_K_LINES_B CLE,
8495: OKC_LINE_STYLES_B LSE
8496: WHERE ITM.CLE_ID = cle.ID
8497: AND CLE.CLE_ID = p_cle_id
8498: AND CLE.LSE_ID = LSE.ID