APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_ITEMS

Line 6424: okc_k_items item,

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

Line 8038: okc_k_items cim,

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

Line 8096: FROM OKC_K_ITEMS ITM,

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

Line 8634: okc_k_items cim,

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

Line 8692: FROM OKC_K_ITEMS ITM,

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