APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_ITEMS

Line 6258: okc_k_items item,

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
6261: AND okc_line.lse_id = lse.id
6262: AND lse.lty_code = 'FEE'

Line 7839: okc_k_items cim,

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,
7843: okc_k_lines_b fa_cle,

Line 7897: FROM OKC_K_ITEMS ITM,

7893: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;
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

Line 8435: okc_k_items cim,

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,
8439: okc_k_lines_b fa_cle,

Line 8493: FROM OKC_K_ITEMS ITM,

8489: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;
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