APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKC_K_ITEMS

Line 202: -- FUNCTION get_rec for: OKC_K_ITEMS_V

198: --------------------------------------------------------------------------------------------------------
199: --Bug# 5946411 End
200: ------------------------------------------------------------------------------------------------------
201: ---------------------------------------------------------------------------
202: -- FUNCTION get_rec for: OKC_K_ITEMS_V
203: ---------------------------------------------------------------------------
204: FUNCTION get_cimv_rec (p_cle_id IN NUMBER,
205: x_no_data_found OUT NOCOPY BOOLEAN
206: ) RETURN cimv_rec_type IS

Line 229: FROM Okc_K_Items_V cim

225: cim.CREATION_DATE,
226: cim.LAST_UPDATED_BY,
227: cim.LAST_UPDATE_DATE,
228: cim.LAST_UPDATE_LOGIN
229: FROM Okc_K_Items_V cim
230: where cle_id = p_cle_id;
231:
232: l_cimv_rec cimv_rec_type;
233: BEGIN

Line 1789: OKC_K_ITEMS cov_ast_cim,

1785: OKL_K_LINES cov_ast_kle,
1786: OKC_K_LINES_B cov_ast_cle,
1787: OKC_LINE_STYLES_B cov_ast_lse,
1788: OKC_STATUSES_B cov_ast_sts,
1789: OKC_K_ITEMS cov_ast_cim,
1790: OKC_K_LINES_B fa_cle,
1791: OKC_K_LINES_B src_cle
1792: Where fee_kle.id = fee_cle.id
1793: and fee_kle.fee_type = 'CAPITALIZED'

Line 1919: OKC_K_ITEMS cim,

1915: --CURSOR to fetch expense account id
1916: CURSOR exp_act_csr (p_kle_id IN NUMBER) IS
1917: SELECT msi.expense_account
1918: FROM MTL_SYSTEM_ITEMS msi,
1919: OKC_K_ITEMS cim,
1920: OKC_K_LINES_B mdl,
1921: OKC_K_LINES_B fal
1922: WHERE cim.object1_id1 = msi.inventory_item_id
1923: AND cim.object1_id2 = to_char(msi.organization_id)

Line 4476: End If; --if unplugged okc_k_items records for fa line

4472: RAISE OKL_API.G_EXCEPTION_ERROR;
4473: END IF;
4474: --End Bug# 4028371
4475: End If;--if asset transaction records found
4476: End If; --if unplugged okc_k_items records for fa line
4477: End If; --fa line is found
4478: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
4479: EXCEPTION
4480: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 5235: OKC_K_ITEMS cim

5231: p_effective_date IN DATE) IS
5232: Select '!'
5233: from OKC_K_LINES_B cle,
5234: OKC_STATUSES_B sts,
5235: OKC_K_ITEMS cim
5236: Where cle.sts_code = sts.CODE
5237: And cle.id = cim.cle_id
5238: And cle.dnz_chr_id = p_chr_id
5239: And cim.dnz_chr_id = p_chr_id

Line 6475: OKC_K_ITEMS cim

6471: p_effective_date IN DATE) IS
6472: Select '!'
6473: from OKC_K_LINES_B cle,
6474: OKC_STATUSES_B sts,
6475: OKC_K_ITEMS cim
6476: Where cle.sts_code = sts.CODE
6477: --sechawla : Bug# 8370324
6478: --And p_effective_date between cle.start_date and cle.end_date
6479: And cle.id = cim.cle_id

Line 7412: okc_k_items fa_cim,

7408: fa_books fab,
7409: --Bug# 6373605 start
7410: fa_book_controls fbc,
7411: --Bug# 6373605 end
7412: okc_k_items fa_cim,
7413: okl_trx_types_tl ttyp,
7414: okl_trx_assets trx,
7415: okl_txl_assets_b txl,
7416: okc_k_lines_b fa_cleb,

Line 7604: OKC_K_ITEMS cov_ast_cim,

7600: OKL_K_LINES cov_ast_kle,
7601: OKC_K_LINES_B cov_ast_cle,
7602: OKC_LINE_STYLES_B cov_ast_lse,
7603: OKC_STATUSES_B cov_ast_sts,
7604: OKC_K_ITEMS cov_ast_cim,
7605: OKC_K_LINES_B fa_cle
7606: Where fee_kle.id = fee_cle.id
7607: and fee_kle.fee_type = 'CAPITALIZED'
7608: and fee_cle.id = cov_ast_cle.cle_id

Line 9095: okc_k_items cim,

9091: fa.asset_number
9092: from fa_additions fa,
9093: fa_books fab,
9094: fa_book_controls fbc,
9095: okc_k_items cim,
9096: okc_k_lines_b cleb,
9097: okc_line_styles_b lseb
9098: where fab.asset_id = fa.asset_id
9099: and fab.transaction_header_id_out is null

Line 9345: OKC_K_ITEMS cov_ast_cim

9341: OKC_STATUSES_B fee_sts,
9342: OKL_K_LINES cov_ast_kle,
9343: OKC_K_LINES_B cov_ast_cle,
9344: OKC_STATUSES_B cov_ast_sts,
9345: OKC_K_ITEMS cov_ast_cim
9346: Where fee_kle.id = fee_cle.id
9347: and fee_kle.fee_type = 'CAPITALIZED'
9348: and fee_cle.dnz_chr_id = p_chr_id
9349: and fee_cle.chr_id = p_chr_id